EX_RISK_TYPLMT

(SQL Table)
 Index Back

Risk Expense Type Limits

Expense Risk Expense Type Limits stored by Business Unit and Risk Template ID.

  • Parent record: EX_RISK_TMPL

    • # 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 RISK_TMPL_ID Character(15) VARCHAR2(15) NOT NULL Risk Template ID

    Prompt Table: EX_RISK_TMPL

    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 RISK_LEVEL Character(1) VARCHAR2(1) NOT NULL Risk Level
    1=Level 1
    2=Level 2
    3=Level 3
    4=Level 4
    5=Level 5
    5 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    6 EXPENSE_TYPE Character(7) VARCHAR2(7) NOT NULL Expense Type

    Prompt Table: EX_TYPES_TBL

    7 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit

    Prompt Table: SP_BU_GL_NONVW

    8 RISK_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Specifies the amount of a draft payment. This field is maintained by the Draft Creation process.
    9 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Prompt Table: CURRENCY_CD_TBL