SPR_ROSTER_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	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier Default Value: SPR_ROSTER_FACT.VENDOR_ID Prompt Table: SPR_SUPPLR_DIM
4	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField Prompt Table: SPR_PROJECT_DIM
5	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department Prompt Table: SPR_DEPT_DIM
6	TE_APPROVER	Character(30)	VARCHAR2(30) NOT NULL	Time Approver Prompt Table: SPF_APPROVER_VW
7	PROJ_ROLE	Character(15)	VARCHAR2(15) NOT NULL	Project Role Prompt Table: SPR_ROLE_DIM
8	SP_REQ_ID	Character(10)	VARCHAR2(10) NOT NULL	Service Request ID Prompt Table: SPF_REQ_HDR
9	WORK_ORDER_ID	Character(15)	VARCHAR2(15) NOT NULL	Work Order ID
10	DISTRIB_LINE_NUM	Number(5,0)	INTEGER NOT NULL	Distribution Line Default Value: 1
11	WO_CONID	Character(15)	VARCHAR2(15) NOT NULL	Service Provider's ID assigned on work order Prompt Table: SPR_PERSON_DIM
12	WO_CLIID	Character(30)	VARCHAR2(30) NOT NULL	Requester
13	START_DATE	Date(10)	DATE NOT NULL	Start Date for Gen Standing PO Default Value: %date
14	END_DATE	Date(10)	DATE NOT NULL	End Date Default Value: %date
15	PO_ID	Character(10)	VARCHAR2(10) NOT NULL	Purchase Order
16	POAMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Purchase Order / Work Order Amount
17	WO_RATE	Signed Number(16,4)	DECIMAL(14,4) NOT NULL	WorkOrder Rate
18	BUSINESS_UNIT_PC	Character(5)	VARCHAR2(5) NOT NULL	PC Business Unit
19	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
20	REQ_ID	Character(10)	VARCHAR2(10) NOT NULL	Requisition ID