SF_OP_TIME

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