HWM_TCD_EXP_DATA_PAY_ALL_VL

Details

• Schema: FUSION

• Object owner: HWM

• Object type: VIEW

Columns

Name

CREATED_BY CREATION_DATE DELETE_FLAG ELIGIBILITY ENTERPRISE_ID LAST_UPDATE_DATE LAST_UPDATE_LOGIN LAST_UPDATED_BY LATEST_VERSION OBJECT_VERSION_NUMBER PAY_DATA_ID PAY_DATA_VERSION PAYROLL_TIME_TYPE PERSON_ID REC_TYPE STATUS 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_PAY_DATA_ID TXN_PAY_DATA_VERSION TCD_EXP_DATA_PAY_TXN_ID TCD_EXP_DATA_TXN_BATCH_ID TCD_EXP_DATA_TXN_ID TCD_EXP_DATA_TXN_TYPE TXN_STATUS

Query

SQL_Statement

SELECT PAY.CREATED_BY, PAY.CREATION_DATE, PAY.DELETE_FLAG, PAY.ELIGIBILITY, PAY.ENTERPRISE_ID, PAY.LAST_UPDATE_DATE, PAY.LAST_UPDATE_LOGIN, PAY.LAST_UPDATED_BY, PAY.LATEST_VERSION, PAY.OBJECT_VERSION_NUMBER, PAY.PAY_DATA_ID, PAY.PAY_DATA_VERSION, PAY.PAYROLL_TIME_TYPE, PAY.PERSON_ID, PAY.REC_TYPE, PAY.STATUS, PAY.TCD_EXP_DATA_ESS_PROCESS_ID, PAY_TXN.CREATED_BY TXN_CREATED_BY, PAY_TXN.CREATION_DATE TXN_CREATION_DATE, PAY_TXN.DELETE_FLAG TXN_DELETE_FLAG, PAY_TXN.ENTERPRISE_ID TXN_ENTERPRISE_ID, PAY_TXN.LAST_UPDATE_DATE TXN_LAST_UPDATE_DATE, PAY_TXN.LAST_UPDATE_LOGIN TXN_LAST_UPDATE_LOGIN, PAY_TXN.LAST_UPDATED_BY TXN_LAST_UPDATED_BY, PAY_TXN.OBJECT_VERSION_NUMBER TXN_OBJECT_VERSION_NUMBER, PAY_TXN.PAY_DATA_ID TXN_PAY_DATA_ID, PAY_TXN.PAY_DATA_VERSION TXN_PAY_DATA_VERSION, PAY_TXN.TCD_EXP_DATA_PAY_TXN_ID, PAY_TXN.TCD_EXP_DATA_TXN_BATCH_ID, PAY_TXN.TCD_EXP_DATA_TXN_ID, PAY_TXN.TCD_EXP_DATA_TXN_TYPE, PAY_TXN.STATUS TXN_STATUS FROM HWM_TCD_EXP_DATA_PAY PAY, HWM_TCD_EXP_DATA_PAY_TXN PAY_TXN WHERE PAY.PAY_DATA_ID = PAY_TXN.PAY_DATA_ID AND PAY.PAY_DATA_VERSION = PAY_TXN.PAY_DATA_VERSION AND PAY.LATEST_VERSION = 'Y'