EX_PRIV_TMPL

(SQL Table)
Index Back

Privilege Template

Privilege Template. This record stores the privilege templates for the T&E approval transactions.

  • Related Language Record: EX_PRIV_T_LNG
  • # 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 PRIVILEGE_TMPL_ID Character(15) VARCHAR2(15) NOT NULL Privilege Template Id. Contains the name of the privilege template.
    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 Effective Date

    Default Value: %date

    5 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    7 DFLT_ACCTG_FLG Character(1) VARCHAR2(1) NOT NULL Default Accounting Flag.
    H=Hide
    M=Modify
    V=View

    Default Value: V

    8 TRANS_LINES_FLG Character(1) VARCHAR2(1) NOT NULL Transaction Lines Flag.
    A=Add
    D=Delete
    F=Full
    M=Modify
    V=View

    Default Value: V

    9 RCPT_REQUIRED_FLG Character(1) VARCHAR2(1) NOT NULL Receipt Required Flag
    H=Hide
    V=View

    Default Value: V

    10 RCPT_VERIFIED_FLG Character(1) VARCHAR2(1) NOT NULL Receipt Verified Flag.
    H=Hide
    M=Modify
    V=View

    Default Value: V

    11 USER_DEFAULTS_FLG Character(1) VARCHAR2(1) NOT NULL User Defaults Flag.
    H=Hide
    V=View

    Default Value: V

    12 ACCTG_DATE_FLG Character(1) VARCHAR2(1) NOT NULL Accounting Date Flag.
    H=Hide
    M=Modify
    V=View

    Default Value: V

    13 ADV_APPLIED_FLG Character(1) VARCHAR2(1) NOT NULL Cash Advance Applied Flag.
    H=Hide
    M=Modify
    V=View

    Default Value: V

    14 ADV_TAX_FLG Character(1) VARCHAR2(1) NOT NULL Cash Advance Tax Flag.
    H=Hide
    M=Modify
    V=View

    Default Value: V

    15 ADV_ADJUSTMENT_FLG Character(1) VARCHAR2(1) NOT NULL Cash Advance Adjustment Flag.
    H=Hide
    M=Modify
    V=View

    Default Value: V

    16 DISTRIBUTIONS_FLG Character(1) VARCHAR2(1) NOT NULL Distributions flag.
    F=Full
    H=Hide
    M=Modify
    V=View

    Default Value: V

    17 CHARTFIELDS_GL_FLG Character(1) VARCHAR2(1) NOT NULL GL Chartfields flag.
    H=Hide
    M=Modify
    V=View

    Default Value: V

    18 CHARTFIELDS_PC_FLG Character(1) VARCHAR2(1) NOT NULL Projects Chartfields Flag
    H=Hide
    M=Modify
    V=View

    Default Value: V

    19 VAT_INFO_FLG Character(1) VARCHAR2(1) NOT NULL VAT Information Flag
    H=Hide
    M=Modify
    V=View

    Default Value: V

    20 DOC_SEQ_TYPE_FLG Character(1) VARCHAR2(1) NOT NULL Document Sequence Flag
    H=Hide
    M=Modify
    V=View

    Default Value: V

    21 BILLING_ACT_FLG Character(1) VARCHAR2(1) NOT NULL Billing Action Flag
    H=Hide
    M=Modify
    V=View

    Default Value: V

    22 ATTACHMENT_FLG Character(1) VARCHAR2(1) NOT NULL Expense attachment flag
    A=Add
    D=Delete
    F=Full
    V=View

    Default Value: V

    23 ATTENDEES_FLG Character(1) VARCHAR2(1) NOT NULL Expenses attendees flag
    M=Modify
    V=View

    Default Value: V