PL_PLNPRD_OP

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROBINST	Character(20)	VARCHAR2(20) NOT NULL	Optimization Problem Instance
2	PL_SEQ_NBR	Number(9,0)	DECIMAL(9) NOT NULL	01/09/02 EGS (CN#PL900-1): Added
3	OP_SEQUENCE	Number(4,0)	SMALLINT NOT NULL	Operation Sequence
4	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
5	WORK_CENTER_CODE	Character(10)	VARCHAR2(10) NOT NULL	Work Center
6	OP_OVERLAP	Number(5,1)	DECIMAL(4,1) NOT NULL	CN#PL800-20.0 MACN 06/14/99- Changed the short name
7	SEND_AHEAD_QTY	Number(12,4)	DECIMAL(11,4) NOT NULL	Send Ahead Quantity
8	SUBCONTRACTED	Character(1)	VARCHAR2(1) NOT NULL	Subcontracted N=No Y=Yes
9	IGNORE_CAPACITY	Character(1)	VARCHAR2(1) NOT NULL	08/29/01 EGS (CN#PL900-1): Added. Y/N Table Edit Default Value: N
10	CONTINUOUS_FLG	Character(1)	VARCHAR2(1) NOT NULL	08/29/01 EGS (CN#PL900-1): Added. Y/N Table Edit Default Value: N
11	TASK_INTENSITY	Character(1)	VARCHAR2(1) NOT NULL	Intensity 0=Labor Time 1=Mach Time 2=Longest 3=Cumulative
12	PLAN_FROZEN_FLG	Character(1)	VARCHAR2(1) NOT NULL	11/01/01 PCL (CN#PL900-1): Updated N=No Y=Yes Y/N Table Edit
13	PLAN_START_DTTM	DateTime(26)	TIMESTAMP	08/29/01 EGS (CN#PL900-1): Added.
14	PLAN_END_DTTM	DateTime(26)	TIMESTAMP	08/29/01 EGS (CN#PL900-1): Added.
15	OPERATION_YIELD	Number(8,4)	DECIMAL(7,4) NOT NULL	Operation Yield
16	ASSY_STARTS_QTY	Number(12,4)	DECIMAL(11,4) NOT NULL	Assembly Starts Qty
17	EXPECTD_CMPL_QTY	Number(12,4)	DECIMAL(11,4) NOT NULL	Expected Completions Qty
18	VERSION	Number(10,0)	DECIMAL(10) NOT NULL	Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference