RS_AGG_CACHE

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	START_DT	Date(10)	DATE NOT NULL	Start Date
3	AS_OF_DATE	Date(10)	DATE	As of Date
4	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
5	PER_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Personnel Status E=Employee N=Non-Employee
6	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
7	BU_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Business unit description.
8	LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Location Code
9	LOCATION_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Location
10	SETID_LOCATION	Character(5)	VARCHAR2(5) NOT NULL	Location SetID
11	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
12	DEPT_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Department ID Description
13	SETID_DEPT	Character(5)	VARCHAR2(5) NOT NULL	Department SetID
14	JOBCODE	Character(6)	VARCHAR2(6) NOT NULL	Job Code
15	JOBCODE_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Jobcode Description
16	SETID_JOBCODE	Character(5)	VARCHAR2(5) NOT NULL	Job Code SetID
17	FORECAST_PRJ_HRS	Signed Number(10,2)	DECIMAL(8,2) NOT NULL	Forecast Project Hours
18	FORECAST_PLCY_HRS	Signed Number(10,2)	DECIMAL(8,2) NOT NULL	Forecast Policy Hours
19	ACT_PLCY_HRS	Signed Number(10,2)	DECIMAL(8,2) NOT NULL	Actual Policy Hours
20	ACT_PRJ_HRS	Signed Number(10,2)	DECIMAL(8,2) NOT NULL	Actual Project Hours
21	CAPACITY_HOURS	Signed Number(10,2)	DECIMAL(8,2) NOT NULL	Capacity Hours