PL_SF_OP_LIST(SQL Table) |
Index Back |
|---|---|
PL/Prd Operation ListThis record identifies the Red Pepper operation sequencing and operation related information based on the exported planning cycle. SCC 01/13/97 (MFG-SCHEW-8): Production ID was added in between keys SEQ_NBR and OP_SEQUENCE in release 6. Fix record so that Production ID is after the keys. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | SEQ_NBR |
Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |
| 3 | OP_SEQUENCE |
Number(4,0) | SMALLINT NOT NULL | Operation Sequence |
| 4 | PROBINST | Character(20) | VARCHAR2(20) NOT NULL | Optimization Problem Instance |
| 5 | PL_SEQ_NBR | Number(9,0) | DECIMAL(9) NOT NULL | 01/09/02 EGS (CN#PL900-1): Added |
| 6 | PRODUCTION_ID | Character(10) | VARCHAR2(10) NOT NULL | Production ID |
| 7 | OP_START_DT | Date(10) | DATE | Operation Start Date |
| 8 | OP_START_TIME | Time(15) | TIMESTAMP | Operation's Start Time |
| 9 | OP_START_SHIFT | Signed Number(2,0) | DECIMAL(1) NOT NULL | Operation's Start Shift |
| 10 | OP_END_DT | Date(10) | DATE | Operation Due Date |
| 11 | OP_END_TIME | Time(15) | TIMESTAMP | Operation's Due Time |
| 12 | OP_END_SHIFT | Signed Number(2,0) | DECIMAL(1) NOT NULL | Operation's Due Shift |
| 13 | OP_PRDN_START_DT | Date(10) | DATE | Operation's Prdn Start Date |
| 14 | OP_PRDN_START_SHFT | Number(1,0) | SMALLINT NOT NULL | Operation's Prdn Start Shift |
| 15 | OP_PRDN_END_DT | Date(10) | DATE | Operation's Prdn Due Date |
| 16 | OP_PRDN_END_SHFT | Number(1,0) | SMALLINT NOT NULL | Operation's Prdn Due Shift |
| 17 | FROZEN_CD | Character(1) | VARCHAR2(1) NOT NULL |
Frozen code
1=Change from unfrozen to frozen 2=Change from frozen to unfrozen 3=No Change |
| 18 | PLAN_FROZEN_FLG | Character(1) | VARCHAR2(1) NOT NULL |
11/01/01 PCL (CN#PL900-1): Updated
N=No Y=Yes Default Value: N |
| 19 | SCHED_CHNG_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Planning Schedule Change
Y/N Table Edit |
| 20 | RTG_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Routing Type
PR=Production RW=Rework TD=Teardown |
| 21 | TASK_CODE | Character(6) | VARCHAR2(6) NOT NULL |
Task Code
Prompt Table: EN_TASKS |
| 22 | TASK_INTENSITY | Character(1) | VARCHAR2(1) NOT NULL |
Intensity
0=Labor Time 1=Mach Time 2=Longest 3=Cumulative |
| 23 | CREWSIZE | Number(7,2) | DECIMAL(6,2) NOT NULL | Crew Size |
| 24 | MACH_RESOURCES | Number(7,2) | DECIMAL(6,2) NOT NULL | Machine Resources |
| 25 | SUBCONTRACTED | Character(1) | VARCHAR2(1) NOT NULL |
Subcontracted
N=No Y=Yes |
| 26 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 27 | WORK_CENTER_CODE | Character(10) | VARCHAR2(10) NOT NULL |
Work Center
Prompt Table: EN_WORK_CENTER |
| 28 | OPERATION_YIELD | Number(8,4) | DECIMAL(7,4) NOT NULL | Operation Yield |
| 29 | ASSY_STARTS_QTY | Number(12,4) | DECIMAL(11,4) NOT NULL | Assembly Starts Qty |
| 30 | EXPECTD_CMPL_QTY | Number(12,4) | DECIMAL(11,4) NOT NULL | Expected Completions Qty |
| 31 | OPERATION_FLOAT | Character(1) | VARCHAR2(1) NOT NULL | Allow Operation Float |
| 32 | OP_OVERLAP | Number(5,1) | DECIMAL(4,1) NOT NULL | CN#PL800-20.0 MACN 06/14/99- Changed the short name |
| 33 | SEND_AHEAD_QTY | Number(12,4) | DECIMAL(11,4) NOT NULL | Send Ahead Quantity |
| 34 | SIM_SETUP_QUEUE | Character(1) | VARCHAR2(1) NOT NULL | Simultaneous Setup and Queue |
| 35 | CONVERSION_CODE | Character(4) | VARCHAR2(4) NOT NULL | Conversion Code |
| 36 | CON_OH_CODE_1 | Character(4) | VARCHAR2(4) NOT NULL | First Conversion Ovhd Code |
| 37 | CON_OH_CODE_2 | Character(4) | VARCHAR2(4) NOT NULL | Second Conversion Ovhd Code |
| 38 | COUNT_POINT | Character(1) | VARCHAR2(1) NOT NULL |
3/22/2000 dfl - Change short name from cnt ptr to cnt pt, more std.
N=No Y=Yes |
| 39 | CON_OH_CODE_3 | Character(4) | VARCHAR2(4) NOT NULL | Third Conversion Ovhd Code |
| 40 | CON_OH_CODE_4 | Character(4) | VARCHAR2(4) NOT NULL | Fourth Conversion Ovhd Code |
| 41 | IGNORE_CAPACITY | Character(1) | VARCHAR2(1) NOT NULL | 08/29/01 EGS (CN#PL900-1): Added. |
| 42 | CONTINUOUS_FLG | Character(1) | VARCHAR2(1) NOT NULL | 08/29/01 EGS (CN#PL900-1): Added. |
| 43 | TEXT254 | Character(254) | VARCHAR2(254) NOT NULL | Text |
| 44 | PLANNER_CD | Character(12) | VARCHAR2(12) NOT NULL | Planner Code |
| 45 | PLANNING_TIMESTAMP | DateTime(26) | TIMESTAMP | Planning Date and Time |
| 46 | PLANNING_VERSION | Character(20) | VARCHAR2(20) NOT NULL | Planning Version |