HRS_ONL_SCRN_VW

(SQL View)
 Index Back

Online Screening Definitions

This view is used to show all Screening Levels that have been defined as available for Online Screening.

SELECT HRS_SCREENING_ID , DESCR , DESCRSHORT FROM PS_HRS_SCREEN_TBL WHERE STATUS = 'A' AND (HRS_SCR_AFT_SUB = 'Y' AND HRS_PRE_APP_SCR = 'N')

  • Related Language Record: HRS_ONL_SCRN_LV

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 HRS_SCREENING_ID Number(15,0) DECIMAL(15) NOT NULL Screening ID

    Prompt Table: HRS_SCREEN_TBL

    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    3 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description