HRS_INT_TMSCHD

(SQL View)
 Index Back

SS Requisition Search -Routing

HR_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 , A.POSTING_TITLE , A.STATUS_CODE , B.OPEN_STS_IND , B.DESCR , A.DEPTID , A.SETID_DEPT , C.DESCR FROM PS_HRS_JO_I A ,PS_HRS_STS_REC_I B , PS_HRS_DEPT_I C WHERE B.STATUS_CODE = A.STATUS_CODE AND C.SETID=A.SETID_DEPT AND C.DEPTID=A.DEPTID AND C.EFFDT = ( SELECT MAX(D.EFFDT) FROM PS_HRS_DEPT_I D WHERE D.SETID = C.SETID AND D.DEPTID = C.DEPTID AND D.EFF_STATUS='A') AND EXISTS( SELECT 'X' FROM PS_HRS_INT_SRCH2 S WHERE S.HRS_JOB_OPENING_ID = A.HRS_JOB_OPENING_ID AND STATUS_CODE NOT IN ('020'))

  • Related Language Record: HRS_INT_TMSD_LN

    • # 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 POSTING_TITLE Character(200) VARCHAR2(200) NOT NULL Job posting title
    3 STATUS_CODE Character(3) VARCHAR2(3) NOT NULL Identifies a status.

    Prompt Table: HRS_STS_JO_VW

    4 OPEN_STS_IND Character(1) VARCHAR2(1) NOT NULL Indicates an open state.
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
    7 SETID_DEPT Character(5) VARCHAR2(5) NOT NULL Department SetID
    8 DESCR_DEPT Character(30) VARCHAR2(30) NOT NULL Description