HS_IMMUN_USR_LV

(SQL View)
 Index Back

Approval Requestor Name

Used to display employee/requestor name in approvals.

SELECT HS.EMPLID , HS.ACTION_DT_SS , HS.EFFSEQ , HS.HS_EMPLID , HS.REG_REGION , HS.IMMUN_CODE , HS.START_DATE , L.LANGUAGE_CD , COALESCE (( SELECT NL.NAME_DISPLAY FROM PS_NAMES_LNG NL WHERE NL.EMPLID = HS.EMPLID AND NL.NAME_TYPE = 'PRI' AND NL.LANGUAGE_CD = L.LANGUAGE_CD AND %EffdtCheck(NAMES_LNG NL1, NL, %CurrentDateIn)), ( SELECT N.NAME_DISPLAY FROM PS_NAMES N WHERE N.EMPLID = HS.EMPLID AND N.NAME_TYPE = 'PRI' AND %EffdtCheck(NAMES N1, N, %CurrentDateIn)), ' ') , COALESCE (( SELECT IML.DESCR FROM PS_HS_IMMUN_LANG IML WHERE IML.SETID = RR.DEFAULT_SETID AND IML.IMMUN_CODE = HS.IMMUN_CODE AND IML.LANGUAGE_CD = L.LANGUAGE_CD AND %EffdtCheck(HS_IMMUN_LANG IML1, IML, %CurrentDateIn)), ( SELECT IM1.DESCR FROM PS_HS_IMMUN_TBL IM1 WHERE IM1.SETID = RR.DEFAULT_SETID AND IM1.IMMUN_CODE = HS.IMMUN_CODE AND %EffdtCheck(HS_IMMUN_TBL IMED, IM1, %CurrentDateIn)), ' ') FROM PS_HS_SS_IMMUN_DAT HS , PSLANGUAGES L , PS_REG_REGION_TBL RR WHERE RR.REG_REGION = HS.REG_REGION

  • Related Language Record for HS_IMMUN_USR_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    2 ACTION_DT_SS Date(10) DATE Termination Date
    3 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence
    4 HS_EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID for Health and Safety
    5 REG_REGION Character(5) VARCHAR2(5) NOT NULL Regulatory Region
    6 IMMUN_CODE Character(4) VARCHAR2(4) NOT NULL Immunization Code
    7 START_DATE Date(10) DATE Start Date for Gen Standing PO
    8 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    9 NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Display Name - name formatted for Display based on the Country
    10 DESCR Character(30) VARCHAR2(30) NOT NULL Description