HS_AWE_TEST_LVW

(SQL View)
 Index Back

Immunization Details for AWE

Immunization Details related language record for AWE.

SELECT HS.EMPLID , HS.ACTION_DT_SS , HS.EFFSEQ , HS.HS_EMPLID , HS.REG_REGION , HS.TEST_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_TEST_LANG IML WHERE IML.SETID = RR.SETID AND IML.TEST_CODE = HS.TEST_CODE AND IML.LANGUAGE_CD = L.LANGUAGE_CD AND %EffdtCheck(HS_TEST_LANG IML1, IML, %CurrentDateIn)), ( SELECT IM1.DESCR FROM PS_HS_TEST_TBL IM1 WHERE IM1.SETID = RR.SETID AND IM1.TEST_CODE = HS.TEST_CODE AND %EffdtCheck(HS_TEST_TBL IMED, IM1, %CurrentDateIn)), ' ') , ' ' , ' ' FROM PS_HS_SS_TEST_DAT HS, PS_SET_CNTRL_GROUP RR, PSLANGUAGES L WHERE HS.REG_REGION = RR.SETCNTRLVALUE AND RR.REC_GROUP_ID = 'HR_08'

  • Related Language Record for HS_AWE_TEST_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PERSON

    2 ACTION_DT_SS Date(10) DATE NOT NULL Transaction Date

    Default Value: %date

    3 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence

    Default Value: 0

    4 HS_EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID for Health and Safety

    Prompt Table: HS_PER_ORG_ASGN

    5 REG_REGION Character(5) VARCHAR2(5) NOT NULL Regulatory Region

    Prompt Table: REG_REGION_TBL

    6 TEST_CODE Character(4) VARCHAR2(4) NOT NULL Code for type of test

    Prompt Table: HS_TEST_TBL

    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 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50
    11 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    12 DESCR50_1 Character(50) VARCHAR2(50) NOT NULL Description of length 50
    13 ADDRESSLONG Long Character CLOB Address Long