EX_APR_T_LNG_VW

(SQL View)
 Index Back

Approver type related lang vw

Approver type related language used for Routing list. Excludes the HR Supervisor and Project Manager as they do not use lists.

SELECT SETID , APPRVR_TYPE , LANGUAGE_CD , DESCR , DESCR254 FROM PS_EX_APPRVR_T_LNG WHERE APPRVR_TYPE NOT IN ('SUPERVISOR', 'PROJAPPRVR')

  • Related Language Record for EX_APPR_TYPE_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    2 APPRVR_TYPE Character(10) VARCHAR2(10) NOT NULL Approver type used to cross reference an AWE process id and stage.
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254