HRS_PERSON_IDHRS_RCMNT_IDHRS_PREPNHIRE_I(SQL View) |
Index Back |
|---|---|
Offer Accepted ApplicantsOffer Accepted Applicants |
| SELECT DISTINCT C.HRS_PERSON_ID , C.HRS_RCMNT_ID , OPR.OPRID FROM PS_HRS_JOB_OPENING B , PS_HRS_RCMNT C , PSOPRDEFN OPR , PS_HRS_JO_TEAM TM WHERE C.HRS_JOB_OPENING_ID = B.HRS_JOB_OPENING_ID AND TM.HRS_JOB_OPENING_ID = B.HRS_JOB_OPENING_ID AND TM.EMPLID = OPR.EMPLID AND B.STATUS_CODE = ( SELECT STS.STATUS_CODE FROM PS_HRS_STS_TBL STS WHERE STS.STATUS_AREA = '1' AND STS.DEFAULT_STS_IND = 'Y') AND C.STATUS_CODE ='071' |
| # | 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 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |