CN_SRP_PARTICIPANT_HDR_UPD_V

Details

• Schema: FUSION

• Object owner: CN

• Object type: VIEW

Columns

Name

PARTICIPANT_ID PARTY_ID START_DATE END_DATE ACTIVE_FLAG ANALYST_ID PARTICIPANT_TYPE COMPENSATION_END_DATE HOLD_PAYMENT_FLAG HOLD_REASON SOURCE_SYSTEM_ID ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN ORG_ID OBJECT_VERSION_NUMBER EMAIL_ADDRESS PARTICIPANT_NAME PARTY_NUMBER PARTICIPANT_LAST_NAME PARTICIPANT_FIRST_NAME HR_PERSON_NUMBER HR_PRIMARY_WORKER_NUMBER DISPLAY_IDENTIFIER SOURCE_SYSTEM USER_GUID PAYEE_ONLY REQUEST_ID JOB_DEFINITION_NAME JOB_DEFINITION_PACKAGE CLASSIFY_BATCH_NUMBER CREDITING_BATCH_NUMBER ROLLUP_BATCH_NUMBER CALC_BATCH_NUMBER

Query

SQL_Statement

SELECT SRP.PARTICIPANT_ID, HZP.PARTY_ID, SRP.START_DATE, SRP.END_DATE, SRP.ACTIVE_FLAG, SRP.ANALYST_ID, SRP.PARTICIPANT_TYPE, SRP.COMPENSATION_END_DATE, SRP.HOLD_PAYMENT_FLAG, SRP.HOLD_REASON, SRP.SOURCE_SYSTEM_ID, SRP.ATTRIBUTE_CATEGORY, SRP.ATTRIBUTE1 , SRP.ATTRIBUTE2 , SRP.ATTRIBUTE3 , SRP.ATTRIBUTE4 , SRP.ATTRIBUTE5 , SRP.ATTRIBUTE6 , SRP.ATTRIBUTE7 , SRP.ATTRIBUTE8 , SRP.ATTRIBUTE9 , SRP.ATTRIBUTE10 , SRP.ATTRIBUTE11 , SRP.ATTRIBUTE12 , SRP.ATTRIBUTE13 , SRP.ATTRIBUTE14 , SRP.ATTRIBUTE15 , SRP.CREATED_BY , SRP.CREATION_DATE , SRP.LAST_UPDATED_BY , SRP.LAST_UPDATE_DATE , SRP.LAST_UPDATE_LOGIN , SRP.ORG_ID , SRP.OBJECT_VERSION_NUMBER , HZP.EMAIL_ADDRESS, HZP.PARTY_NAME PARTICIPANT_NAME , HZP.PARTY_NUMBER , HZP.PERSON_LAST_NAME PARTICIPANT_LAST_NAME , HZP.PERSON_FIRST_NAME PARTICIPANT_FIRST_NAME , ( SELECT per.person_number FROM PER_ALL_PEOPLE_F PER WHERE srp.source_system_id = PER.PERSON_ID AND srp.source_system = 'FUSION_HCM' AND TRUNC(sysdate) >= PER.EFFECTIVE_START_DATE AND TRUNC(sysdate) <= PER.EFFECTIVE_END_DATE AND rownum = 1) HR_PERSON_NUMBER, SRP.HR_PRIMARY_WORKER_NUMBER HR_PRIMARY_WORKER_NUMBER , SRP.DISPLAY_IDENTIFIER , SRP.SOURCE_SYSTEM , SRP.USER_GUID, SRP.PAYEE_ONLY , SRP.REQUEST_ID , SRP.JOB_DEFINITION_NAME, SRP.JOB_DEFINITION_PACKAGE, SRP.CLASSIFY_BATCH_NUMBER, SRP.CREDITING_BATCH_NUMBER, SRP.ROLLUP_BATCH_NUMBER, SRP.CALC_BATCH_NUMBER FROM CN_SRP_PARTICIPANTS_ALL SRP, HZ_PARTIES HZP WHERE SRP.PARTY_ID = HZP.PARTY_ID