HRS_APPL_JO_I3

(SQL View)
 Index Back

Applicant's Job Opening Data


SELECT RC.HRS_PERSON_ID , RC.HRS_RCMNT_ID , RC.HRS_PROFILE_SEQ , RC.HRS_JOB_OPENING_ID , 'E:' %Concat JO.EMPLID FROM PS_HRS_RN_R_IDX_VW RC , PS_HRS_SJT_JO JO WHERE RC.HRS_JOB_OPENING_ID = JO.HRS_JOB_OPENING_ID AND JO.EMPLID <> ' ' UNION SELECT RC.HRS_PERSON_ID , RC.HRS_RCMNT_ID , RC.HRS_PROFILE_SEQ , RC.HRS_JOB_OPENING_ID , 'C:' %Concat CLS.CLASSID FROM PS_HRS_RN_R_IDX_VW RC , PS_HRS_SJT_JO JO , PS_SJT_CLASS_ALL CLS WHERE RC.HRS_JOB_OPENING_ID = JO.HRS_JOB_OPENING_ID AND CLS.SCRTY_SET_CD = 'RSOPN' AND CLS.SCRTY_TYPE_CD = JO.SCRTY_TYPE_CD AND CLS.SCRTY_KEY1 = JO.SCRTY_KEY1 AND CLS.SCRTY_KEY2 = JO.SCRTY_KEY2 AND CLS.SCRTY_KEY3 = JO.SCRTY_KEY3 AND JO.EMPLID = ' ' UNION SELECT RC.HRS_PERSON_ID , RC.HRS_RCMNT_ID , RC.HRS_PROFILE_SEQ , RC.HRS_JOB_OPENING_ID , 'C:' %Concat CLS.CLASSID FROM PS_HRS_RN_R_IDX_VW RC , PS_HRS_SJT_JO JO , PS_SJT_CLASS_ALL CLS WHERE RC.HRS_JOB_OPENING_ID = JO.HRS_JOB_OPENING_ID AND CLS.SCRTY_SET_CD = 'PPLJOB' AND CLS.SCRTY_TYPE_CD = '001' AND CLS.SCRTY_KEY1 = JO.SCRTY_KEY1 AND CLS.SCRTY_KEY2 = JO.SCRTY_KEY2 AND CLS.SCRTY_KEY3 = JO.SCRTY_KEY3 AND JO.EMPLID = ' ' UNION SELECT RC.HRS_PERSON_ID , RC.HRS_RCMNT_ID , RC.HRS_PROFILE_SEQ , 0 , 'A:ALL' FROM PS_HRS_RN_R_IDX_VW RC

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 HRS_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL Person Id
2 HRS_RCMNT_ID Number(15,0) DECIMAL(15) NOT NULL App Tracking Recruitment ID
3 HRS_PROFILE_SEQ Number(3,0) SMALLINT NOT NULL Profile sequece
4 HRS_JOB_OPENING_ID Number(15,0) DECIMAL(15) NOT NULL Job Opening Clone
5 HRS_DESCR Character(30) VARCHAR2(30) NOT NULL Description