HRS_SCR_RCJB_VW

(SQL View)
 Index Back

Recruitment Job Status View


SELECT A.HRS_PERSON_ID ,A.HRS_RCMNT_ID ,C.HRS_JOB_OPENING_ID ,A.JOBCODE ,A.STATUS_CODE ,A.STATUS_REASON ,B.OPEN_STS_IND ,B.STATUS_PHASE ,D.HRS_SCR_RSL_SEQ ,D.HRS_SCREENING_ID ,D.HRS_SCR_STATUS ,D.HRS_SCR_STS_RSN , %subrec(HRS_AUDIT_SBR, D) FROM PS_HRS_RCMNT_JOB A , PS_HRS_STS_REC_I B , PS_HRS_RCMNT C , PS_HRS_SCR_RSLT D WHERE B.STATUS_AREA = '3' AND A.STATUS_CODE = B.STATUS_CODE AND A.HRS_PERSON_ID = C.HRS_PERSON_ID AND A.HRS_RCMNT_ID = C.HRS_RCMNT_ID AND A.HRS_PERSON_ID = D.HRS_PERSON_ID AND A.HRS_RCMNT_ID = D.HRS_RCMNT_ID AND C.HRS_JOB_OPENING_ID = D.HRS_JOB_OPENING_ID

# 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_JOB_OPENING_ID Number(15,0) DECIMAL(15) NOT NULL Job Opening Clone
4 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code
5 STATUS_CODE Character(3) VARCHAR2(3) NOT NULL Identifies a status.
6 STATUS_REASON Character(3) VARCHAR2(3) NOT NULL Identifies a reason associated with a particular status.
7 OPEN_STS_IND Character(1) VARCHAR2(1) NOT NULL Indicates an open state.
8 STATUS_PHASE Character(1) VARCHAR2(1) NOT NULL Identifies a phase within a status area.
1=1-Applied
2=2-Reviewed
3=3-Screen
4=4-Route
5=5-Interview
6=6-Offer
7=7-Hire
8=8-Hold
9=9-Reject
9 HRS_SCR_RSL_SEQ Number(3,0) SMALLINT NOT NULL Screening Result Sequence
10 HRS_SCREENING_ID Number(15,0) DECIMAL(15) NOT NULL Screening ID
11 HRS_SCR_STATUS Character(1) VARCHAR2(1) NOT NULL Screening Status
1=Passed
2=Failed
12 HRS_SCR_STS_RSN Character(254) VARCHAR2(254) NOT NULL Screening Status Reason
13 HRS_ROW_ADD_DTTM DateTime(26) TIMESTAMP Row Added DateTime
14 HRS_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Added Operator Id
15 HRS_ROW_UPD_DTTM DateTime(26) TIMESTAMP Row Updated DateTime
16 HRS_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Updated Operator Id