SPR_EXPVAR_FACT

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
3	WORK_ORDER_ID	Character(15)	VARCHAR2(15) NOT NULL	Work Order ID
4	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
5	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
6	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField
7	PO_ID	Character(10)	VARCHAR2(10) NOT NULL	Purchase Order
8	WO_CONID	Character(15)	VARCHAR2(15) NOT NULL	Service Provider's ID assigned on work order
9	APPROVAL_OPRID	Character(30)	VARCHAR2(30) NOT NULL	A system generated value that reflects the operator that approved a given transaction.
10	ACCOUNT	Character(10)	VARCHAR2(10) NOT NULL	Account
11	SP_REQ_ID	Character(10)	VARCHAR2(10) NOT NULL	Service Request ID
12	SP_CONTRACTOR_NAME	Character(50)	VARCHAR2(50) NOT NULL	Service Provider
13	BUSINESS_UNIT_PC	Character(5)	VARCHAR2(5) NOT NULL	PC Business Unit
14	WO_RATE	Signed Number(16,4)	DECIMAL(14,4) NOT NULL	WorkOrder Rate
15	UNIT_OF_MEASURE	Character(3)	VARCHAR2(3) NOT NULL	Used on an approval rule set. MHR=Muti Hourly PER=Percentage SQF=Square Footage
16	POAMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Purchase Order / Work Order Amount
17	SPR_TOTAL_TIME	Number(27,3)	DECIMAL(26,3) NOT NULL	sPro Total Time Field for Analysis - Total Hours by Multiplies Time Reporting Code
18	SPR_TOTAL_EXPNS	Number(27,3)	DECIMAL(26,3) NOT NULL	sPro Total Expense Amount
19	SPR_TOTAL_AMT	Number(27,3)	DECIMAL(26,3) NOT NULL	sPro Total Amount Calculated from Hours Worked
20	SPR_AVAIL_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Available Amount Field for Analysis
21	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Default Value: BUS_UNIT_TBL_EX.BASE_CURRENCY Prompt Table: CURRENCY_CD_TBL