EX_REFINE_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	REFINEMENT_TMPL_ID	Character(15)	VARCHAR2(15) NOT NULL	Refinement template name
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	VAT_ENTRIES	Character(1)	VARCHAR2(1) NOT NULL	VAT Items Y/N Table Edit Default Value: N
8	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
9	NO_RECEIPT_FLG	Character(1)	VARCHAR2(1) NOT NULL	No Receipt Y/N Table Edit Default Value: N
10	HOURS_GT	Number(3,0)	SMALLINT NOT NULL	Total hours greater than.
11	HOURS_LT	Number(3,0)	SMALLINT NOT NULL	Total hours less than.
12	OUT_OF_POLICY	Character(1)	VARCHAR2(1) NOT NULL	Authorized Amount Exceeded Y/N Table Edit Default Value: N
13	VAT_RECEIPT	Character(1)	VARCHAR2(1) NOT NULL	No VAT Receipt Y/N Table Edit Default Value: N
14	PREF_MRCH_NOT_USED	Character(1)	VARCHAR2(1) NOT NULL	Non-Preferred Merchant Y/N Table Edit Default Value: N
15	REVIEW_EVERY_RPT	Number(3,0)	SMALLINT NOT NULL	Approve every nth report.
16	PROJ_HOURS_GT	Number(3,0)	SMALLINT NOT NULL	Project hours greater than
17	PROJ_HOURS_LT	Number(3,0)	SMALLINT NOT NULL	Project hours less than
18	TAX_IMPLICATIONS	Character(1)	VARCHAR2(1) NOT NULL	Items with Tax Implications Y/N Table Edit Default Value: N
19	DUPLICATES_EXIST	Character(1)	VARCHAR2(1) NOT NULL	Duplicates Exist Y/N Table Edit Default Value: N
20	TOTAL_LIMIT_SW	Character(1)	VARCHAR2(1) NOT NULL	Total limit amount Y/N Table Edit Default Value: N
21	PROJ_EXPENSE_SW	Character(1)	VARCHAR2(1) NOT NULL	Project expenses Y/N Table Edit Default Value: N
22	BILLABLE_HRS_SW	Character(1)	VARCHAR2(1) NOT NULL	Project expenses Y/N Table Edit Default Value: N
23	NONBILLABLE_HRS_SW	Character(1)	VARCHAR2(1) NOT NULL	Project expenses Y/N Table Edit Default Value: N
24	OLDER_TRANSACTION	Character(1)	VARCHAR2(1) NOT NULL	Older Transactions Y/N Table Edit Default Value: N