HS_REQ_USR_LV

(SQL View)
 Index Back

Approval Requestor Name

Used to display incident report requestors name.

SELECT HS.EMPLID , HS.ACTION_DT_SS , HS.EFFSEQ , HS.INCIDENT_NBR , A.LANGUAGE_CD , A.NAME_DISPLAY , A.NAME_DISPLAY_SRCH , A.NAME FROM PS_HS_SS_INCDT_DAT HS , PS_NAMES_LNG A WHERE HS.EMPLID = A.EMPLID AND A.NAME_TYPE = 'PRI' AND A.EFFDT = ( SELECT MAX(AA.EFFDT) FROM PS_NAMES_LNG AA WHERE AA.EMPLID = A.EMPLID AND AA.NAME_TYPE = A.NAME_TYPE AND AA.EFFDT <= %CurrentDateIn )

  • Related Language Record for HS_IMMUN_USR_V HS_REQ_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 INCIDENT_NBR Character(8) VARCHAR2(8) NOT NULL Incident Number
    5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Display Name - name formatted for Display based on the Country
    7 NAME_DISPLAY_SRCH Character(50) VARCHAR2(50) NOT NULL Uppercase version of Name to improve performance on searches.
    8 NAME_PSFORMAT Character(50) VARCHAR2(50) NOT NULL A Person's name in the Peoplesoft Format (basically LN,FN MI