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 NOT NULL	Effective Date Default Value: %date
6	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A
7	RISK_DESCR30	Character(30)	VARCHAR2(30) NOT NULL	Risk Description
8	ENABLE_EMAIL_LINE	Character(1)	VARCHAR2(1) NOT NULL	Enable Email Approvals Y/N Table Edit Default Value: N
9	TA_LT_ER_DAYS_FLG	Character(1)	VARCHAR2(1) NOT NULL	Travel Auth < Expense Days Y/N Table Edit Default Value: N
10	TA_LT_ER_DAYS_TOL	Character(1)	VARCHAR2(1) NOT NULL	Tolerance Y/N Table Edit Default Value: N
11	TA_LT_ER_DAYS	Number(3,0)	SMALLINT NOT NULL	Tolerence Days
12	TA_AMT_LT_ER_AMT	Character(1)	VARCHAR2(1) NOT NULL	Tauth Amount < Expense Amount Y/N Table Edit Default Value: N
13	TA_LT_ER_AMT_TOL	Character(1)	VARCHAR2(1) NOT NULL	Tolerance Y/N Table Edit Default Value: N
14	TA_LT_ER_AMT_PER	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	Tolerence Percent
15	NEG_EXPENSE_RPT	Character(1)	VARCHAR2(1) NOT NULL	Negative Expense Report Y/N Table Edit Default Value: N
16	CASH_ADV_APPLIED	Character(1)	VARCHAR2(1) NOT NULL	Cash Advance Applied Y/N Table Edit Default Value: N
17	OUT_OF_POLICY	Character(1)	VARCHAR2(1) NOT NULL	Authorized Amount Exceeded Y/N Table Edit Default Value: N
18	TAX_IMPLICATIONS	Character(1)	VARCHAR2(1) NOT NULL	Items with Tax Implications Y/N Table Edit Default Value: N
19	VAT_ENTRIES	Character(1)	VARCHAR2(1) NOT NULL	VAT Items Y/N Table Edit Default Value: N
20	VAT_RECEIPT	Character(1)	VARCHAR2(1) NOT NULL	No VAT Receipt Y/N Table Edit Default Value: N
21	DUPLICATES_EXIST	Character(1)	VARCHAR2(1) NOT NULL	Duplicates Exist Y/N Table Edit Default Value: N
22	CC_FEED_FLG	Character(1)	VARCHAR2(1) NOT NULL	Field used to indicate whether a credit card feed was used to populate an expense sheet or not. Y/N Table Edit Default Value: N
23	PREF_MRCH_NOT_USED	Character(1)	VARCHAR2(1) NOT NULL	Non-Preferred Merchant Y/N Table Edit Default Value: N
24	NO_RECEIPT_FLG	Character(1)	VARCHAR2(1) NOT NULL	No Receipt Y/N Table Edit Default Value: N
25	PROJ_EXPENSE_SW	Character(1)	VARCHAR2(1) NOT NULL	Project expenses Y/N Table Edit Default Value: N
26	BILLABLE_HRS_SW	Character(1)	VARCHAR2(1) NOT NULL	Project expenses Y/N Table Edit Default Value: N
27	BILL_HOURS_LT	Number(3,0)	SMALLINT NOT NULL	Billable Hours <
28	NONBILL_HRS_GT	Number(3,0)	SMALLINT NOT NULL	Non-Billable Hours >
29	HOURS_GT	Number(3,0)	SMALLINT NOT NULL	Total hours greater than.
30	HOURS_LT	Number(3,0)	SMALLINT NOT NULL	Total hours less than.
31	PROJ_HOURS_LT	Number(3,0)	SMALLINT NOT NULL	Project hours less than
32	PROJ_HOURS_GT	Number(3,0)	SMALLINT NOT NULL	Project hours greater than
33	BILL_LT_NONBILL	Character(1)	VARCHAR2(1) NOT NULL	Billable Hours < Non-Billable Y/N Table Edit Default Value: N
34	MULT_PER_DIEM	Character(1)	VARCHAR2(1) NOT NULL	Multip Per Diem Exist Per Day Y/N Table Edit Default Value: N
35	OLDER_TRANSACTION	Character(1)	VARCHAR2(1) NOT NULL	Older Transactions Y/N Table Edit Default Value: N