HRS_SCRLVL_LN_I

(SQL View)
Index Back

Screening Lvl w/Defn RL Intfc

Related language for screening level with definition view interface

SELECT B.HRS_SCR_TMPL_ID , B.HRS_SEQ_NUM , A.LANGUAGE_CD , A.DESCR , A.DESCRSHORT FROM PS_HRS_SCREEN_LN_I A , PS_HRS_SCR_LVL_I B WHERE A.HRS_SCREENING_ID = B.HRS_SCREENING_ID

  • Related Language Record for HRS_SCR_LVL_VW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 HRS_SCR_TMPL_ID Number(15,0) DECIMAL(15) NOT NULL Screening template ID

    Prompt Table: HRS_SCR_TMPL

    2 HRS_SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence Number
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description