HS_TEST_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.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 TL.DESCR FROM PS_HS_TEST_LANG TL WHERE TL.SETID = RR.DEFAULT_SETID AND TL.TEST_CODE = HS.TEST_CODE AND TL.LANGUAGE_CD = L.LANGUAGE_CD AND %EffdtCheck(HS_TEST_LANG TL1, TL, %CurrentDateIn)), ( SELECT TST.DESCR FROM PS_HS_TEST_TBL TST WHERE TST.SETID = RR.DEFAULT_SETID AND TST.TEST_CODE = HS.TEST_CODE AND %EffdtCheck(HS_TEST_TBL TST1, TST, %CurrentDateIn)), ' ') FROM PS_HS_SS_TEST_DAT HS , PSLANGUAGES L , PS_REG_REGION_TBL RR WHERE RR.REG_REGION = HS.REG_REGION

  • Related Language Record for HS_TEST_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 TEST_CODE Character(4) VARCHAR2(4) NOT NULL Code for type of test
    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