HRS_JO_SCRLV_VW

(SQL View)
 Index Back

Job Opening Screening Lvl Vw

Job opening screening level view

SELECT A.HRS_JOB_OPENING_ID , A.HRS_JO_RQMT_SEQ , A.HRS_JO_SCR_SUMM_ID , B.HRS_JO_SCR_SEQ , B.HRS_SCREENING_ID FROM PS_HRS_JO_SCRSM_VW A , PS_HRS_JO_SCR_LVL B WHERE A.HRS_JO_SCR_SUMM_ID = B.HRS_JO_SCR_SUMM_ID

  • Parent record: HRS_JO_SCRSM_VW

    • # 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

    Prompt Table: HRS_JOB_OPENING

    2 HRS_JO_RQMT_SEQ Number(3,0) SMALLINT NOT NULL Job opening requirement sequence

    Prompt Table: HRS_JO_RQMT

    3 HRS_JO_SCR_SUMM_ID Number(15,0) DECIMAL(15) NOT NULL JO Screening Summary ID

    Prompt Table: HRS_JO_SCR_SUMM

    4 HRS_JO_SCR_SEQ Number(3,0) SMALLINT NOT NULL Job opening screening sequence
    5 HRS_SCREENING_ID Number(15,0) DECIMAL(15) NOT NULL Screening ID