HRS_BIP_SCR_VW

(SQL View)
Index Back

Screening level

Defines Screening level

( SELECT HRS_SCREENING_ID ,DESCR ,'N' ,'N' FROM PS_HRS_SCREEN_TBL D WHERE D.HRS_SCR_AFT_SUB <> 'Y' AND D.HRS_PRE_APP_SCR <> 'Y' AND D.STATUS='A') UNION ( SELECT 999999999999998 ,COALESCE(E.MESSAGE_TEXT ,'Online Screening') ,'N' ,'N' FROM PS_HRS_SCREEN_TBL D LEFT OUTER JOIN PSMSGCATDEFN E ON 1=1 AND E.MESSAGE_SET_NBR=18178 AND E.MESSAGE_NBR=1333 WHERE D.HRS_SCR_AFT_SUB = 'Y' AND D.STATUS='A') UNION ( SELECT 999999999999997 ,COALESCE(E.MESSAGE_TEXT ,'Pre Screening') ,'N' ,'N' FROM PS_HRS_SCREEN_TBL D LEFT OUTER JOIN PSMSGCATDEFN E ON 1=1 AND E.MESSAGE_SET_NBR=18178 AND E.MESSAGE_NBR=1332 WHERE D.HRS_PRE_APP_SCR = 'Y' AND D.STATUS='A') UNION ( SELECT 999999999999999 ,COALESCE(E.MESSAGE_TEXT ,'Additional Questions') ,'N' ,'N' FROM PS_INSTALLATION LEFT OUTER JOIN PSMSGCATDEFN E ON 1=1 AND E.MESSAGE_SET_NBR=18178 AND E.MESSAGE_NBR=1334 )

  • Related Language Record: HRS_BIP_SCR_LV
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 HRS_SCREENING_ID Number(15,0) DECIMAL(15) NOT NULL Screening ID
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    3 HRS_PRINT_QUES_DAT Character(1) VARCHAR2(1) NOT NULL Determines if Questionnaire data is available
    4 HRS_PRINT_QUES_SEL Character(1) VARCHAR2(1) NOT NULL Determines if Questionnaire data is available