CN_SRP_PARTICIPANT_SIMPLE_V

Details

• Schema: FUSION

• Object owner: CN

• Object type: VIEW

Columns

Name
PARTICIPANT_ID PARTY_ID ORG_ID START_DATE END_DATE ACTIVE_FLAG ANALYST_ID COMPENSATION_END_DATE DISPLAY_IDENTIFIER HOLD_PAYMENT_FLAG HOLD_REASON HR_PRIMARY_WORKER_NUMBER PARTICIPANT_FIRST_NAME PARTICIPANT_LAST_NAME PARTICIPANT_NAME PARTICIPANT_TYPE PARTY_NUMBER PAYEE_ONLY SOURCE_SYSTEM SOURCE_SYSTEM_ID USER_GUID CREATION_DATE CREATED_BY LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN

Query

SQL_Statement

SELECT SRP.PARTICIPANT_ID, HZP.PARTY_ID, SRP.ORG_ID, SRP.START_DATE, SRP.END_DATE, SRP.ACTIVE_FLAG, SRP.ANALYST_ID, SRP.COMPENSATION_END_DATE, SRP.DISPLAY_IDENTIFIER, SRP.HOLD_PAYMENT_FLAG, SRP.HOLD_REASON, SRP.HR_PRIMARY_WORKER_NUMBER, HZP.PERSON_FIRST_NAME PARTICIPANT_FIRST_NAME, HZP.PERSON_LAST_NAME PARTICIPANT_LAST_NAME, HZP.PARTY_NAME PARTICIPANT_NAME, SRP.PARTICIPANT_TYPE, HZP.PARTY_NUMBER, SRP.PAYEE_ONLY, SRP.SOURCE_SYSTEM, SRP.SOURCE_SYSTEM_ID, HZP.USER_GUID, SRP.CREATION_DATE, SRP.CREATED_BY, SRP.LAST_UPDATED_BY, SRP.LAST_UPDATE_DATE, SRP.LAST_UPDATE_LOGIN FROM CN_SRP_PARTICIPANTS_ALL SRP, HZ_PARTIES HZP WHERE SRP.PARTY_ID = HZP.PARTY_ID