EX_PROF_ATTR

(SQL Table)
 Index Back

Approver profile attributes

Approver Profile Attributes. This record stores the T&E approver profile (chile) definitions.

  • Parent record: EX_PROF_APPRVR

    • # 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 APPROVER_PROFILE Character(15) VARCHAR2(15) NOT NULL Approver profile name
    3 APPR_TRANS_TYPE Character(4) VARCHAR2(4) NOT NULL Approval Transaction Type.
    CA=Cash Advance
    ER=Expense Report
    TA=Travel Authorization
    TJ=Time Adjustment
    TR=Time Report
    4 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    5 REFINEMENT_TMPL_ID Character(15) VARCHAR2(15) NOT NULL Refinement template name

    Prompt Table: EX_REFINE_VW

    6 PRIVILEGE_TMPL_ID Character(15) VARCHAR2(15) NOT NULL Privilege Template Id. Contains the name of the privilege template.

    Prompt Table: EX_PRIV_VW

    7 RISK_TMPL_ID Character(15) VARCHAR2(15) NOT NULL Risk Template ID

    Prompt Table: EX_RISK_VW

    8 ENABLE_EMAIL_HDR Character(1) VARCHAR2(1) NOT NULL Enable Email Approvals

    Y/N Table Edit

    Default Value: N

    9 CHANGE_FLAG Character(1) VARCHAR2(1) NOT NULL Yes/No indicator

    Y/N Table Edit

    Default Value: N