HRS_APPL_JO_I

(SQL View)
 Index Back

Applicant's Job Opening Data


SELECT APP.HRS_PERSON_ID , APP.HRS_PROFILE_SEQ , RCMNT.HRS_RCMNT_ID , 0 , JOFAM.JOB_FAMILY ,0 FROM PS_HRS_APPI_ALL_VW APP , PS_HRS_RCMNT RCMNT , PS_HRS_APP_JOBFAM JOFAM WHERE APP.HRS_PERSON_ID = RCMNT.HRS_PERSON_ID AND APP.HRS_PROFILE_SEQ = RCMNT.HRS_PROFILE_SEQ AND APP.HRS_PERSON_ID = JOFAM.HRS_PERSON_ID AND APP.HRS_PROFILE_SEQ = JOFAM.HRS_PROFILE_SEQ AND JOFAM.JOB_FAMILY <> ' ' UNION SELECT APP.HRS_PERSON_ID , APP.HRS_PROFILE_SEQ , RCMNT.HRS_RCMNT_ID , JO.HRS_JOB_OPENING_ID , JO.JOB_FAMILY , 0 FROM PS_HRS_APPI_ALL_VW APP , PS_HRS_RCMNT RCMNT , PS_HRS_JOB_OPENING JO WHERE APP.HRS_PERSON_ID = RCMNT.HRS_PERSON_ID AND APP.HRS_PROFILE_SEQ = RCMNT.HRS_PROFILE_SEQ AND RCMNT.HRS_JOB_OPENING_ID = JO.HRS_JOB_OPENING_ID AND JO.JOB_FAMILY <> ' ' UNION SELECT APP.HRS_PERSON_ID , APP.HRS_PROFILE_SEQ , RCMNT.HRS_RCMNT_ID , 0 , '' , LOC.HRS_DES_LOC1 FROM PS_HRS_APPI_ALL_VW APP , PS_HRS_RCMNT RCMNT , PS_HRS_APP_PROFILE LOC WHERE APP.HRS_PERSON_ID = RCMNT.HRS_PERSON_ID AND APP.HRS_PROFILE_SEQ = RCMNT.HRS_PROFILE_SEQ AND LOC.HRS_PERSON_ID = RCMNT.HRS_PERSON_ID AND LOC.HRS_PROFILE_SEQ = RCMNT.HRS_PROFILE_SEQ AND LOC.HRS_DES_LOC1 > 0 UNION SELECT APP.HRS_PERSON_ID , APP.HRS_PROFILE_SEQ , RCMNT.HRS_RCMNT_ID , 0 , '' , LOC.HRS_DES_LOC2 FROM PS_HRS_APPI_ALL_VW APP , PS_HRS_RCMNT RCMNT , PS_HRS_APP_PROFILE LOC WHERE APP.HRS_PERSON_ID = RCMNT.HRS_PERSON_ID AND APP.HRS_PROFILE_SEQ = RCMNT.HRS_PROFILE_SEQ AND LOC.HRS_PERSON_ID = RCMNT.HRS_PERSON_ID AND LOC.HRS_PROFILE_SEQ = RCMNT.HRS_PROFILE_SEQ AND LOC.HRS_DES_LOC2 > 0

# 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_PROFILE_SEQ Number(3,0) SMALLINT NOT NULL Profile sequece
3 HRS_RCMNT_ID Number(15,0) DECIMAL(15) NOT NULL App Tracking Recruitment ID
4 HRS_JOB_OPENING_ID Number(15,0) DECIMAL(15) NOT NULL Job Opening Clone
5 JOB_FAMILY Character(6) VARCHAR2(6) NOT NULL Job Family
6 HRS_LOCATION_ID Number(15,0) DECIMAL(15) NOT NULL Recruiting location area