1. Tables and Views for Sales and Fusion Service
  2. CN_SRP_PARTICIPANT_HDR_RO_V

CN_SRP_PARTICIPANT_HDR_RO_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

ATTRIBUTE_DATE1

ATTRIBUTE_DATE2

ATTRIBUTE_DATE3

ATTRIBUTE_DATE4

ATTRIBUTE_DATE5

ATTRIBUTE_DATE6

ATTRIBUTE_DATE7

ATTRIBUTE_DATE8

ATTRIBUTE_DATE9

ATTRIBUTE_DATE10

ATTRIBUTE_NUMBER1

ATTRIBUTE_NUMBER2

ATTRIBUTE_NUMBER3

ATTRIBUTE_NUMBER4

ATTRIBUTE_NUMBER5

ATTRIBUTE_NUMBER6

ATTRIBUTE_NUMBER7

ATTRIBUTE_NUMBER8

ATTRIBUTE_NUMBER9

ATTRIBUTE_NUMBER10

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

ORG_ID

OBJECT_VERSION_NUMBER

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

EMAIL_ADDRESS

ORIG_SYSTEM_REFERENCE

ORIG_SYSTEM

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.ATTRIBUTE_DATE1,

SRP.ATTRIBUTE_DATE2,

SRP.ATTRIBUTE_DATE3,

SRP.ATTRIBUTE_DATE4,

SRP.ATTRIBUTE_DATE5,

SRP.ATTRIBUTE_DATE6,

SRP.ATTRIBUTE_DATE7,

SRP.ATTRIBUTE_DATE8,

SRP.ATTRIBUTE_DATE9,

SRP.ATTRIBUTE_DATE10,

SRP.ATTRIBUTE_NUMBER1,

SRP.ATTRIBUTE_NUMBER2,

SRP.ATTRIBUTE_NUMBER3,

SRP.ATTRIBUTE_NUMBER4,

SRP.ATTRIBUTE_NUMBER5,

SRP.ATTRIBUTE_NUMBER6,

SRP.ATTRIBUTE_NUMBER7,

SRP.ATTRIBUTE_NUMBER8,

SRP.ATTRIBUTE_NUMBER9,

SRP.ATTRIBUTE_NUMBER10,

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.PARTY_NAME PARTICIPANT_NAME ,

HZP.PARTY_NUMBER,

HZP.PERSON_LAST_NAME PARTICIPANT_LAST_NAME ,

HZP.PERSON_FIRST_NAME PARTICIPANT_FIRST_NAME ,

CASE

WHEN (srp.source_system='FUSION_HCM')

THEN

(SELECT PERSON_NUMBER

FROM PER_ALL_PEOPLE_F PER

WHERE srp.source_system_id = person_id

AND TRUNC(sysdate) >= EFFECTIVE_START_DATE

AND TRUNC(sysdate) <= EFFECTIVE_END_DATE

)

ELSE NULL

END HR_PERSON_NUMBER,

SRP.HR_PRIMARY_WORKER_NUMBER HR_PRIMARY_WORKER_NUMBER ,

SRP.DISPLAY_IDENTIFIER,

SRP.SOURCE_SYSTEM,

HZP.USER_GUID,

SRP.PAYEE_ONLY,

SRP.REQUEST_ID,

SRP.JOB_DEFINITION_NAME,

SRP.JOB_DEFINITION_PACKAGE,

HZP.EMAIL_ADDRESS,

HSR.ORIG_SYSTEM_REFERENCE,

HSR.ORIG_SYSTEM,

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,

HZ_ORIG_SYS_REFERENCES HSR

WHERE SRP.PARTY_ID = HZP.PARTY_ID

AND HZP.PARTY_ID = HSR.OWNER_TABLE_ID(+)

AND HSR.OWNER_TABLE_NAME(+) = 'HZ_PARTIES'

AND HSR.STATUS(+) ='A'