EX_RISK_AUTHAMT (SQL Table)	Index Back
Risk Authorized Amt Vairance Risk table storing Expense Types and the Risk Variance percentage.

EX_RISK_AUTHAMT

(SQL Table)

Risk Authorized Amt Vairance

Risk table storing Expense Types and the Risk Variance percentage.

# 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 EXPENSE_TYPE Character(7) VARCHAR2(7) NOT NULL Expense Type
Prompt Table: EX_TYPES_TBL

7 AUTHORIZED_AMT_FLG Character(1) VARCHAR2(1) NOT NULL Authorized Amount
Y/N Table Edit
Default Value: N

8 VARIANCE_PCT Signed Number(7,2) DECIMAL(5,2) NOT NULL Variance Percent

#	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	EXPENSE_TYPE	Character(7)	VARCHAR2(7) NOT NULL	Expense Type Prompt Table: EX_TYPES_TBL
7	AUTHORIZED_AMT_FLG	Character(1)	VARCHAR2(1) NOT NULL	Authorized Amount Y/N Table Edit Default Value: N
8	VARIANCE_PCT	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	Variance Percent