PGM_DWRKLD_TAO

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
3	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
4	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField
5	ACTIVITY_ID	Character(15)	VARCHAR2(15) NOT NULL	Activity ID
6	TEAM_MEMBER	Character(30)	VARCHAR2(30) NOT NULL	Team Member
7	DT_OF_WEEK	Date(10)	DATE	Date of week
8	HOLIDAY_LIST_ID	Character(10)	VARCHAR2(10) NOT NULL	This is used to identify what holiday calendar to use. This is the access field for all financials groups.
9	ASSGND_WORK	Signed Number(16,2)	DECIMAL(14,2) NOT NULL	Assigned Work
10	ACT_ASSGN_DAYS	Number(8,2)	DECIMAL(7,2) NOT NULL	Actual Assignment Days
11	DAILY_WLOAD	Number(15,2)	DECIMAL(14,2) NOT NULL	Daily Workload
12	STD_HRS_DEFAULT	Number(7,2)	DECIMAL(6,2) NOT NULL	Default Standard Hours
13	OVERLOAD_INDICATOR	Character(1)	VARCHAR2(1) NOT NULL	Overload Indicator
14	MONHRS	Number(15,2)	DECIMAL(14,2) NOT NULL	Monday Hours
15	TUEHRS	Number(15,2)	DECIMAL(14,2) NOT NULL	Tuesday Hours
16	WEDHRS	Number(15,2)	DECIMAL(14,2) NOT NULL	Wednesday Hours
17	THRHRS	Number(15,2)	DECIMAL(14,2) NOT NULL	Thursday Hours
18	FRIHRS	Number(15,2)	DECIMAL(14,2) NOT NULL	Friday Hours
19	SATHRS	Number(15,2)	DECIMAL(14,2) NOT NULL	saturday Hours
20	SUNHRS	Number(15,2)	DECIMAL(14,2) NOT NULL	Sunday Hours
21	DOW	Character(3)	VARCHAR2(3) NOT NULL	Day of week
22	RM_RES_YN	Character(1)	VARCHAR2(1) NOT NULL	RM Resource Flag
23	OVERLOAD_DATE	Date(10)	DATE	Overload Date