HRS_JO_SCR_S_VW

(SQL View)
Index Back

Job Opening Screening Summary

Job Opening Screening Summary view

SELECT A.HRS_JOB_OPENING_ID , A.HRS_JO_RQMT_SEQ , A.HRS_JO_SCR_SUMM_ID , A.JOBCODE , 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_JOB_OPENING
  • # 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 HRS_JO_RQMT_SEQ Number(3,0) SMALLINT NOT NULL Job opening requirement sequence
    3 HRS_JO_SCR_SUMM_ID Number(15,0) DECIMAL(15) NOT NULL JO Screening Summary ID
    4 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code
    5 HRS_JO_SCR_SEQ Number(3,0) SMALLINT NOT NULL Job opening screening sequence
    6 HRS_SCREENING_ID Number(15,0) DECIMAL(15) NOT NULL Screening ID

    Prompt Table: HRS_SCREEN_VW