CN_SRP_PARTICIPANT_NAME_V

Details

• Schema: FUSION

• Object owner: CN

• Object type: VIEW

Columns

Name
PARTICIPANT_ID PARTY_ID START_DATE END_DATE ACTIVE_FLAG PARTICIPANT_TYPE ORG_ID PARTY_NAME PARTICIPANT_NAME EMAIL_ADDRESS REHIRE_COUNT REHIRE_DATE PREVIOUS_TERMINATION_DATE PREVIOUS_COMP_END_DATE

Query

SQL_Statement
SELECT csp.participant_id, csp.party_id, csp.start_date, csp.end_date, csp.active_flag, csp.participant_type, csp.org_id, hzp.party_name, hzp.party_name participant_name, hzp.email_address, csp.rehire_count, csp.rehire_date, csp.previous_termination_date, csp.previous_comp_end_date FROM cn_srp_participants_all csp, hz_parties hzp WHERE csp.party_id = hzp.party_id