HRS_INT_TMSCHD2

(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 , ' ' FROM PS_HRS_JO_I A ,PS_HRS_STS_REC_I B WHERE B.STATUS_CODE = A.STATUS_CODE AND (A.DEPTID= ' ' OR A.SETID_DEPT=' ') AND EXISTS( SELECT 'X' FROM PS_HRS_INT_SRCH2 S WHERE S.HRS_JOB_OPENING_ID = A.HRS_JOB_OPENING_ID)

  • Related Language Record: HRS_INTTMSD2_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