HWM_TCD_EXP_DATA_PER_ALL_VL

Details

• Schema: FUSION

• Object owner: HWM

• Object type: VIEW

Columns

Name

CREATED_BY CREATION_DATE DELETE_FLAG ENTERPRISE_ID FIRST_NAME LAST_NAME LAST_UPDATE_DATE LAST_UPDATE_LOGIN LAST_UPDATED_BY LATEST_VERSION NAME_EFFECTIVE_END_DATE NAME_EFFECTIVE_START_DATE OBJECT_VERSION_NUMBER PERSON_BADGE_ID PERSON_DATA_ID PERSON_DATA_VERSION PERSON_ID PERSON_NAME_ID PERSON_NUMBER REC_TYPE TCD_EXP_DATA_ESS_PROCESS_ID TXN_CREATED_BY TXN_CREATION_DATE TXN_DELETE_FLAG TXN_ENTERPRISE_ID TXN_LAST_UPDATE_DATE TXN_LAST_UPDATE_LOGIN TXN_LAST_UPDATED_BY TXN_OBJECT_VERSION_NUMBER TXN_PERSON_DATA_ID TXN_PERSON_DATA_VERSION TXN_STATUS TCD_EXP_DATA_PER_TXN_ID TCD_EXP_DATA_TXN_BATCH_ID TCD_EXP_DATA_TXN_ID TCD_EXP_DATA_TXN_TYPE

Query

SQL_Statement

SELECT PER.CREATED_BY, PER.CREATION_DATE, PER.DELETE_FLAG, PER.ENTERPRISE_ID, PER.FIRST_NAME, PER.LAST_NAME, PER.LAST_UPDATE_DATE, PER.LAST_UPDATE_LOGIN, PER.LAST_UPDATED_BY, PER.LATEST_VERSION, PER.NAME_EFFECTIVE_END_DATE, PER.NAME_EFFECTIVE_START_DATE, PER.OBJECT_VERSION_NUMBER, PER.PERSON_BADGE_ID, PER.PERSON_DATA_ID, PER.PERSON_DATA_VERSION, PER.PERSON_ID, PER.PERSON_NAME_ID, PER.PERSON_NUMBER, PER.REC_TYPE, PER.TCD_EXP_DATA_ESS_PROCESS_ID, PER_TXN.CREATED_BY TXN_CREATED_BY, PER_TXN.CREATION_DATE TXN_CREATION_DATE, PER_TXN.DELETE_FLAG TXN_DELETE_FLAG, PER_TXN.ENTERPRISE_ID TXN_ENTERPRISE_ID, PER_TXN.LAST_UPDATE_DATE TXN_LAST_UPDATE_DATE, PER_TXN.LAST_UPDATE_LOGIN TXN_LAST_UPDATE_LOGIN, PER_TXN.LAST_UPDATED_BY TXN_LAST_UPDATED_BY, PER_TXN.OBJECT_VERSION_NUMBER TXN_OBJECT_VERSION_NUMBER, PER_TXN.PERSON_DATA_ID TXN_PERSON_DATA_ID, PER_TXN.PERSON_DATA_VERSION TXN_PERSON_DATA_VERSION, PER_TXN.STATUS TXN_STATUS, PER_TXN.TCD_EXP_DATA_PER_TXN_ID, PER_TXN.TCD_EXP_DATA_TXN_BATCH_ID, PER_TXN.TCD_EXP_DATA_TXN_ID, PER_TXN.TCD_EXP_DATA_TXN_TYPE FROM HWM_TCD_EXP_DATA_PER PER, HWM_TCD_EXP_DATA_PER_TXN PER_TXN WHERE PER.PERSON_DATA_ID = PER_TXN.PERSON_DATA_ID AND PER_TXN.PERSON_DATA_VERSION = PER.PERSON_DATA_VERSION AND PER.LATEST_VERSION = 'Y'