EX_APPR_TYPE_VW

(SQL View)
 Index Back

Approver Types View

Defines the approver types used to map to Approval Routing. This view excludes the HR Supervisor and Project Manager as they do not use routing lists.

SELECT SETID , APPRVR_TYPE , DESCR , DESCR254 , APPROVER_CATEGORY , ROUTING_CHARTFIELD FROM PS_EX_APPRVR_TYPE WHERE APPRVR_TYPE NOT IN ('SUPERVISOR', 'PROJAPPRVR')

  • Related Language Record: EX_APR_T_LNG_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Prompt Table: SP_SETID_NONVW

    2 APPRVR_TYPE Character(10) VARCHAR2(10) NOT NULL Approver type used to cross reference an AWE process id and stage.
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
    5 APPROVER_CATEGORY Character(3) VARCHAR2(3) NOT NULL Approver Category. Used to categorized approver types.
    APP=Expense Approver
    HRS=HR Supervisor
    PRE=Pre Pay Audit
    PRO=Project Manager
    PRS=Project Supplemental
    PST=Post Pay Audit
    REC=Receipt Verifier
    REV=Reviewer
    6 ROUTING_CHARTFIELD Character(18) VARCHAR2(18) NOT NULL Routing Chartfield. Determines which chartfield is used to route transactions for approval.

    Prompt Table: EX_CF_PROMPT_VW