PC_SCH_ACT_SEL

#	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	PC_SCH_PRODUCT	Character(3)	VARCHAR2(3) NOT NULL	Product code used by Projects to determine the third party scheduling product being integrated with.
3	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: SP_BU_PC_NONVW
4	ACTIVITY_ID	Character(15)	VARCHAR2(15) NOT NULL	Activity ID
5	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
6	ACTIVITY_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Activity Type A=Activity Type E=Entry Type G=Group Type/Origin O=Activity Type/Origin R=Entry Type/Reason
7	WBS_ID	Character(100)	VARCHAR2(100) NOT NULL	WBS ID
8	PERCENT_COMPLETE	Number(6,2)	DECIMAL(5,2) NOT NULL	% Complete
9	EARLY_START_DT	Date(10)	DATE	Early Start Date
10	LATE_START_DT	Date(10)	DATE	Late Start Date
11	ACTUAL_START_DT	Date(10)	DATE	Actual Start Date
12	EARLY_FINISH_DT	Date(10)	DATE	Early Finish Date
13	LATE_FINISH_DT	Date(10)	DATE	Late Finish Date
14	ACTUAL_FINISH_DT	Date(10)	DATE	Actual Finish Date
15	BASELINE_FINISH_DT	Date(10)	DATE	Baseline Finish Date
16	BASELINE_START_DT	Date(10)	DATE	Baseline Start Date
17	BCWP	Number(3,0)	SMALLINT NOT NULL	BCWP - Worked Performed
18	BCWS	Number(3,0)	SMALLINT NOT NULL	BCWS Work Scheduled
19	TASK_ID	Character(18)	VARCHAR2(18) NOT NULL	Task Identification
20	TASK_TYPE	Character(18)	VARCHAR2(18) NOT NULL	Task Category
21	TASK_CODE	Character(6)	VARCHAR2(6) NOT NULL	Task Code
22	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField