HRS_BIP_JACNTVW

(SQL View)
 Index Back

Used in XMLP report for Job O

XMLP report for Print Job Opening Applicant per status code chart

SELECT A.HRS_JOB_OPENING_ID , A.STATUS_CODE , B.DESCR FROM PS_HRS_RCMNT A , PS_HRS_STS_REC_I B WHERE A.STATUS_CODE = B.STATUS_CODE AND B.STATUS_AREA = '3'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 HRS_JOB_OPENING_ID Number(15,0) DECIMAL(15) NOT NULL Job Opening Clone
2 STATUS_CODE Character(3) VARCHAR2(3) NOT NULL Identifies a status.
3 DESCR Character(30) VARCHAR2(30) NOT NULL Description