EX_RISK_BU

(SQL Table)
 Index Back

Risk for Business Unit

This table stores Business Units for Risk.

  • 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
    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 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Prompt Table: SP_BU_GL_NONVW