EN_TASK_TIME

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: BUS_UNIT_OPT_MG
2	TASK_CODE	Character(6)	VARCHAR2(6) NOT NULL	Task Code
3	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
4	OP_TIME	Number(9,2)	DECIMAL(8,2) NOT NULL	Op Time
5	OP_RATE	Number(9,2)	DECIMAL(8,2) NOT NULL	Op Rate
6	OP_TIME_UNIT	Character(2)	VARCHAR2(2) NOT NULL	Time Unit DY=Days HR=Hours MN=Minutes
7	OP_RATE_UNIT	Character(2)	VARCHAR2(2) NOT NULL	Op Rate Unit UD=Units/Day UH=Units/Hour UM=Units/Min
8	INCLUDE_SETUP	Character(1)	VARCHAR2(1) NOT NULL	Include Setup in Lead Time N=No Y=Yes Y/N Table Edit Default Value: Y
9	SCHED_BY_CALENDAR	Character(1)	VARCHAR2(1) NOT NULL	Schedule by Calendar Y/N Table Edit Default Value: Y