HRS_INTNJO_SCHD

(SQL View)
Index Back

SELECT DISTINCT A.HRS_PERSON_ID ,A.HRS_RCMNT_ID , B.HRS_JOB_OPENING_ID , '3' , B.STATUS_CODE , C.DESCR FROM PS_HRS_INT_SCHED A , PS_HRS_RCMNT_I B , PS_HRS_STS_REC_I C WHERE A.HRS_RCMNT_ID = B.HRS_RCMNT_ID AND B.HRS_JOB_OPENING_ID=0 AND C.STATUS_CODE = B.STATUS_CODE

# 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 STATUS_AREA Character(1) VARCHAR2(1) NOT NULL Defines an area in the system that track statuses.
1=1-Job Opening
2=2-Applicant
3=3-Recruitment Summary
4=4-Route
5=5-Interview
6=6-Offer
5 STATUS_CODE Character(3) VARCHAR2(3) NOT NULL Identifies a status.
6 DESCR Character(30) VARCHAR2(30) NOT NULL Description