SPR_CONPER_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 Prompt Table: SPR_SUPPLR_DIM
4	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField
5	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department Prompt Table: SPR_DEPT_DIM
6	APPROVAL_OPRID	Character(30)	VARCHAR2(30) NOT NULL	A system generated value that reflects the operator that approved a given transaction. Prompt Table: SPR_PERSON_DIM
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	WO_CONID	Character(15)	VARCHAR2(15) NOT NULL	Service Provider's ID assigned on work order
11	TIME_SHEET_ID	Character(10)	VARCHAR2(10) NOT NULL	Time Sheet Unique Identifier (System Generated)
12	ACTIVITY_ID	Character(15)	VARCHAR2(15) NOT NULL	Activity ID
13	TIME_SHEET_STATUS	Character(3)	VARCHAR2(3) NOT NULL	Time Sheet Status ADJ=Adjusted APR=Approved DEN=Denied DNA=Denied by Approver DNU=Denied by Project Manager HDA=Hold by Approver HDU=Hold by Project Manager HLD=Hold MFS=Marked for Submit PAR=Approvals in Process PND=Pending PRO=In Process SFA=Submission in Process SUB=Submitted for Approval XML=Submitted, Pending Validation Default Value: PND
14	PERIOD_END_DT	Date(10)	DATE NOT NULL	Represents the date termination point for a given time set utilized in cash worksheet processing.
15	APPR_RATING_NUM	Number(4,2)	DECIMAL(3,2) NOT NULL	Performance Rating
16	BUSINESS_UNIT_PC	Character(5)	VARCHAR2(5) NOT NULL	PC Business Unit