HRS_LVL_LST_LVW

(SQL View)
Index Back

Screening Level Lists

Returns a list of screening levels associated with the job opening/jobcode. Used on the screening component

SELECT DISTINCT A.HRS_JOB_OPENING_ID ,A.JOBCODE ,A.HRS_SCREENING_ID ,B.LANGUAGE_CD ,B.DESCR FROM PS_HRS_SCR_RSLT A , PS_HRS_SCREEN_LN_I B WHERE A.HRS_SCREENING_ID = B.HRS_SCREENING_ID

  • Related Language Record for HRS_LVL_LST_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
    2 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code
    3 HRS_SCREENING_ID Number(15,0) DECIMAL(15) NOT NULL Screening ID
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 HRS_SCR_DESCR Character(30) VARCHAR2(30) NOT NULL Screening Level