HRS_BIP_SCR_LV

(SQL View)
 Index Back

Screening level Lang view

Screening level Lang view

( SELECT D.HRS_SCREENING_ID ,E.LANGUAGE_CD ,E.DESCR FROM PS_HRS_SCREEN_TBL D ,PS_HRS_SCREEN_LNG E WHERE D.HRS_SCREENING_ID=E.HRS_SCREENING_ID AND D.HRS_SCR_AFT_SUB <> 'Y' AND D.HRS_PRE_APP_SCR <> 'Y' AND D.STATUS='A') UNION ( SELECT 999999999999997 ,E.LANGUAGE_CD ,COALESCE(E.MESSAGE_TEXT ,'Online Screening') FROM PS_HRS_SCREEN_TBL D LEFT OUTER JOIN PSMSGCATLANG 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 999999999999998 ,E.LANGUAGE_CD ,COALESCE(E.MESSAGE_TEXT ,'Pre Screening') FROM PS_HRS_SCREEN_TBL D LEFT OUTER JOIN PSMSGCATLANG 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 ,E.LANGUAGE_CD ,COALESCE(E.MESSAGE_TEXT ,'Additional Questions') FROM PS_INSTALLATION LEFT OUTER JOIN PSMSGCATLANG E ON 1=1 AND E.MESSAGE_SET_NBR=18178 AND E.MESSAGE_NBR=1334 )

  • Related Language Record for HRS_BIP_SCR_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 HRS_SCREENING_ID Number(15,0) DECIMAL(15) NOT NULL Screening ID
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description