PROBINSTBUSINESS_UNITPRODUCTION_IDOP_SEQUENCEPrompt Table: PL_PR_O_OP_VW
N=No
Y=Yes
Y/N Table Edit
Default Value: N
Y/N Table Edit
Default Value: N
0=Labor Time
1=Mach Time
2=Longest
3=Cumulative
N=No
Y=Yes
Y/N Table Edit
PL_PR_OP_LISDEL(SQL Table) |
Index Back |
|---|---|
PL Production Op List Delete10/29/01 EGS (CN#PL900-1): Added, delete table for PL_PR_OP_LIST. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROBINST |
Character(20) | VARCHAR2(20) NOT NULL | Optimization Problem Instance |
| 2 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 3 | PRODUCTION_ID |
Character(10) | VARCHAR2(10) NOT NULL | Production ID |
| 4 | OP_SEQUENCE |
Number(4,0) | SMALLINT NOT NULL |
Operation Sequence
Prompt Table: PL_PR_O_OP_VW |
| 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 | QTY_COMP_AND_THRU | Number(12,4) | DECIMAL(11,4) NOT NULL | Qty Completed and Thru Oper |
| 13 | PLAN_FROZEN_FLG | Character(1) | VARCHAR2(1) NOT NULL |
11/01/01 PCL (CN#PL900-1): Updated
N=No Y=Yes |
| 14 | OP_COMPLETED | Character(1) | VARCHAR2(1) NOT NULL |
Operation Completed
Y/N Table Edit |
| 15 | ORIG_START_DTTM | DateTime(26) | TIMESTAMP | 04/29/02 EGS (CN#PL900-1): Added |
| 16 | ORIG_END_DTTM | DateTime(26) | TIMESTAMP | 04/29/02 EGS (CN#PL900-1): Added. |
| 17 | PLAN_START_DTTM | DateTime(26) | TIMESTAMP | 08/29/01 EGS (CN#PL900-1): Added. |
| 18 | PLAN_END_DTTM | DateTime(26) | TIMESTAMP | 08/29/01 EGS (CN#PL900-1): Added. |
| 19 | QTY_SCRAPPED | Number(12,4) | DECIMAL(11,4) NOT NULL | Assembly Qty Scrapped at Op |
| 20 | OPERATION_YIELD | Number(8,4) | DECIMAL(7,4) NOT NULL | Operation Yield |
| 21 | ORIG_OP_YIELD | Number(8,4) | DECIMAL(7,4) NOT NULL | 09/20/02 EGS (CN#PL880-1): Added. |
| 22 | ASSY_STARTS_QTY | Number(12,4) | DECIMAL(11,4) NOT NULL | Assembly Starts Qty |
| 23 | EXPECTD_CMPL_QTY | Number(12,4) | DECIMAL(11,4) NOT NULL | Expected Completions Qty |
| 24 | ORIG_COMP_QTY | Signed Number(13,4) | DECIMAL(11,4) NOT NULL | 08/29/01 EGS (CN#PL900-1): Added. |
| 25 | ORIG_STARTS_QTY | Number(12,4) | DECIMAL(11,4) NOT NULL | 12/12/2007 JAA 9.1 Apply Planning Updates. Field used to store original PID start quantity |
| 26 | ORIG_EXPECTED_QTY | Number(12,4) | DECIMAL(11,4) NOT NULL | 12/12/2007 JAA 9.1 Apply Planning Updates. Field used to store original PID end quantity |
| 27 | ORIG_SCRAP_QTY | Signed Number(13,4) | DECIMAL(11,4) NOT NULL | 08/29/01 EGS (CN#PL900-1): Added. |
| 28 | ORIG_OP_COMPLETED | Character(1) | VARCHAR2(1) NOT NULL | Original Op Completed Flag |
| 29 | CREWSIZE | Number(7,2) | DECIMAL(6,2) NOT NULL | Crew Size |
| 30 | MACH_RESOURCES | Number(7,2) | DECIMAL(6,2) NOT NULL | Machine Resources |
| 31 | VERSION | Number(10,0) | DECIMAL(10) NOT NULL | Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference |