HWM_TCD_EXP_DATA_PER_BDG_AL_VL

Details

• Schema: FUSION

• Object owner: HWM

• Object type: VIEW

Columns

Name

PERSON_BADGE_ID PERSON_ID DATE_FROM DATE_TO ASSIGNMENT_ID OBJECT_VERSION_NUMBER ENTERPRISE_ID CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN STATUS PER_BADGE_DATA_ID PER_BADGE_DATA_VERSION REC_TYPE DELETE_FLAG LATEST_VERSION TCD_EXP_DATA_ESS_PROCESS_ID PER_BADGE_TXN_ID TXN_PER_BADGE_DATA_ID TXN_PER_BADGE_DATA_VERSION TCD_EXP_DATA_TXN_ID TCD_EXP_DATA_TXN_BATCH_ID TXN_DELETE_FLAG TXN_STATUS TXN_OBJECT_VERSION_NUMBER TXN_ENTERPRISE_ID TXN_CREATED_BY TXN_CREATION_DATE TXN_LAST_UPDATED_BY TXN_LAST_UPDATE_DATE TXN_LAST_UPDATE_LOGIN

Query

SQL_Statement

SELECT PER_BDG.PERSON_BADGE_ID, PER_BDG.PERSON_ID, PER_BDG.DATE_FROM, PER_BDG.DATE_TO, PER_BDG.ASSIGNMENT_ID, PER_BDG.OBJECT_VERSION_NUMBER, PER_BDG.ENTERPRISE_ID, PER_BDG.CREATED_BY, PER_BDG.CREATION_DATE, PER_BDG.LAST_UPDATED_BY, PER_BDG.LAST_UPDATE_DATE, PER_BDG.LAST_UPDATE_LOGIN, PER_BDG.STATUS, PER_BDG.PER_BADGE_DATA_ID, PER_BDG.PER_BADGE_DATA_VERSION, PER_BDG.REC_TYPE, PER_BDG.DELETE_FLAG, PER_BDG.LATEST_VERSION, PER_BDG.TCD_EXP_DATA_ESS_PROCESS_ID, PER_BDG_TXN.PER_BADGE_TXN_ID, PER_BDG_TXN.PER_BADGE_DATA_ID TXN_PER_BADGE_DATA_ID, PER_BDG_TXN.PER_BADGE_DATA_VERSION TXN_PER_BADGE_DATA_VERSION, PER_BDG_TXN.TCD_EXP_DATA_TXN_ID, PER_BDG_TXN.TCD_EXP_DATA_TXN_BATCH_ID, PER_BDG_TXN.DELETE_FLAG TXN_DELETE_FLAG, PER_BDG_TXN.STATUS TXN_STATUS, PER_BDG_TXN.OBJECT_VERSION_NUMBER TXN_OBJECT_VERSION_NUMBER, PER_BDG_TXN.ENTERPRISE_ID TXN_ENTERPRISE_ID, PER_BDG_TXN.CREATED_BY TXN_CREATED_BY, PER_BDG_TXN.CREATION_DATE TXN_CREATION_DATE, PER_BDG_TXN.LAST_UPDATED_BY TXN_LAST_UPDATED_BY, PER_BDG_TXN.LAST_UPDATE_DATE TXN_LAST_UPDATE_DATE, PER_BDG_TXN.LAST_UPDATE_LOGIN TXN_LAST_UPDATE_LOGIN FROM HWM_TCD_EXP_DATA_PER_BDG PER_BDG, HWM_TCD_EXP_DATA_PER_BDG_TXN PER_BDG_TXN WHERE PER_BDG.PER_BADGE_DATA_ID = PER_BDG_TXN.PER_BADGE_DATA_ID AND PER_BDG.PER_BADGE_DATA_VERSION = PER_BDG_TXN.PER_BADGE_DATA_VERSION AND PER_BDG.LATEST_VERSION = 'Y'