CE_ACT_HRS_CONV

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CE_SOURCE	Character(15)	VARCHAR2(15) NOT NULL	source
2	TIME_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Time / Resource Type 0100=Planning Labor Setup 0200=Planning Labor Fixed Run 0300=Planning Labor Run 0400=Planning Labor Post Prod 0500=Planning Machine Setup 0600=Planning Machine Fixed Run 0700=Planning Machine Run 0800=Planning Machine Post Prod 1100=Costing Labor Setup 1200=Costing Labor Fixed Run 1300=Costing Labor Run 1400=Costing Labor Post Prod 1500=Costing Machine Setup 1600=Costing Machine Fixed Run 1700=Costing Machine Run 1800=Costing Machine Post Prod 2000=Queue Time 3000=Intransit Time
3	LAB_SETUP	Signed Number(10,2)	DECIMAL(8,2) NOT NULL	Labor Setup
4	LAB_RUN	Signed Number(10,2)	DECIMAL(8,2) NOT NULL	Labor Run
5	LAB_FIXED_RUN	Signed Number(10,2)	DECIMAL(8,2) NOT NULL	Labor Fixed Run
6	LAB_POSTPROD	Signed Number(10,2)	DECIMAL(8,2) NOT NULL	Labor Post Production
7	MACH_SETUP	Signed Number(10,2)	DECIMAL(8,2) NOT NULL	Machine Setup
8	MACH_RUN	Signed Number(10,2)	DECIMAL(8,2) NOT NULL	Machine Run
9	MACH_FIXED_RUN	Signed Number(10,2)	DECIMAL(8,2) NOT NULL	Machine Fixed Run
10	MACH_POSTPROD	Signed Number(10,2)	DECIMAL(8,2) NOT NULL	Machine Post Production