PL_PLNPRD_OPDEL

(SQL Table)
 Index Back

PL Planned Prod Operation Del

10/29/01 EGS (CN#PL900-1): Added, delete table for 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