HRS_INT_TMSD_LN(SQL View) |
Index Back |
---|---|
SS Requisition Search -RoutingHR_SS_REQ_SRCH2 is used for the Self Service transaction to retrieve those requisitions, where applicants past the screening and are ready for routing. |
SELECT A.HRS_JOB_OPENING_ID , AA.LANGUAGE_CD , AA.POSTING_TITLE , BB.DESCR , C.DESCR FROM PS_HRS_JO_I A ,PS_HRS_STS_REC_I B , PS_HRS_JO_LN_I AA , PS_HRS_STS_LNG BB , PS_HRS_DEPT_LNI C WHERE AA.LANGUAGE_CD = C.LANGUAGE_CD AND AA.LANGUAGE_CD = BB.LANGUAGE_CD AND A.HRS_JOB_OPENING_ID = AA.HRS_JOB_OPENING_ID AND B.STATUS_AREA = BB.STATUS_AREA AND B.STATUS_CODE = BB.STATUS_CODE AND B.STATUS_CODE = A.STATUS_CODE AND C.SETID=A.SETID_DEPT AND C.DEPTID=A.DEPTID AND EXISTS( SELECT 'X' FROM PS_HRS_INT_SRCH2 S WHERE S.HRS_JOB_OPENING_ID = A.HRS_JOB_OPENING_ID) |
# | 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 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
3 | POSTING_TITLE | Character(200) | VARCHAR2(200) NOT NULL | Job posting title |
4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
5 | DESCR_DEPT | Character(30) | VARCHAR2(30) NOT NULL | Description |