SF_OP_LLT_TMP(SQL Table) |
Index Back |
|---|---|
Operation and Lead Time List01/16/07 EGS: Created |
| # | 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: SP_BUMGOP_NONVW |
| 2 | PRODUCTION_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Production ID
Prompt Table: SF_PRDNID_HEADR |
| 3 | OP_SEQUENCE |
Number(4,0) | SMALLINT NOT NULL | Operation Sequence |
| 4 | TASK_CODE | Character(6) | VARCHAR2(6) NOT NULL |
Task Code
Prompt Table: EN_TASKS |
| 5 | TASK_INTENSITY | Character(1) | VARCHAR2(1) NOT NULL |
Intensity
0=Labor Time 1=Mach Time 2=Longest 3=Cumulative |
| 6 | MACHINE_CODE | Character(10) | VARCHAR2(10) NOT NULL | Machine Code |
| 7 | 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 Y/N Table Edit Default Value: N |
| 8 | SUBCONTRACTED | Character(1) | VARCHAR2(1) NOT NULL |
Subcontracted
N=No Y=Yes Y/N Table Edit Default Value: N |
| 9 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 10 | WORK_CENTER_CODE | Character(10) | VARCHAR2(10) NOT NULL |
Work Center
Prompt Table: EN_WORK_CENTER |
| 11 | QTY_ISS_TO_OP | Number(12,4) | DECIMAL(11,4) NOT NULL | Quantity Issued to Operation |
| 12 | QTY_COMP_AND_AT | Number(12,4) | DECIMAL(11,4) NOT NULL | Qty Completed and at Operation |
| 13 | QTY_COMP_AND_THRU | Number(12,4) | DECIMAL(11,4) NOT NULL | Qty Completed and Thru Oper |
| 14 | QTY_SCRAPPED | Number(12,4) | DECIMAL(11,4) NOT NULL | Assembly Qty Scrapped at Op |
| 15 | PERCENT_COMP | Number(6,2) | DECIMAL(5,2) NOT NULL | Scrap Prdn Pct |
| 16 | OPERATION_YIELD | Number(8,4) | DECIMAL(7,4) NOT NULL | Operation Yield |
| 17 | OP_COMPLETED | Character(1) | VARCHAR2(1) NOT NULL |
Operation Completed
Y/N Table Edit Default Value: N |
| 18 | SETUP_EARNED | Character(1) | VARCHAR2(1) NOT NULL |
Setup Earned
Y/N Table Edit Default Value: N |
| 19 | POST_PROD_EARNED | Character(1) | VARCHAR2(1) NOT NULL |
Post Production Earned
Y/N Table Edit Default Value: N |
| 20 | OP_OVERLAP | Number(5,1) | DECIMAL(4,1) NOT NULL | CN#PL800-20.0 MACN 06/14/99- Changed the short name |
| 21 | SEND_AHEAD_QTY | Number(12,4) | DECIMAL(11,4) NOT NULL | Send Ahead Quantity |
| 22 | OP_START_DT | Date(10) | DATE | Operation Start Date |
| 23 | OP_START_TIME | Time(15) | TIMESTAMP | Operation's Start Time |
| 24 | OP_START_SHIFT | Signed Number(2,0) | DECIMAL(1) NOT NULL | Operation's Start Shift |
| 25 | OP_END_DT | Date(10) | DATE | Operation Due Date |
| 26 | OP_END_TIME | Time(15) | TIMESTAMP | Operation's Due Time |
| 27 | OP_END_SHIFT | Signed Number(2,0) | DECIMAL(1) NOT NULL | Operation's Due Shift |
| 28 | OP_RUN_START_DT | Date(10) | DATE | Operation's Run Start Date |
| 29 | OP_RUN_START_TIME | Time(15) | TIMESTAMP | Operation's Run Start Time |
| 30 | OP_RUN_START_SHIFT | Signed Number(2,0) | DECIMAL(1) NOT NULL | Operation's Run Start Shift |
| 31 | OP_PRDN_START_DT | Date(10) | DATE | Operation's Prdn Start Date |
| 32 | OP_PRDN_START_SHFT | Number(1,0) | SMALLINT NOT NULL | Operation's Prdn Start Shift |
| 33 | OP_PRDN_END_DT | Date(10) | DATE | Operation's Prdn Due Date |
| 34 | OP_PRDN_END_SHFT | Number(1,0) | SMALLINT NOT NULL | Operation's Prdn Due Shift |
| 35 | OP_PRDN_RUN_ST_DT | Date(10) | DATE | Operation Prdn Run Start Date |
| 36 | OP_PRDN_RUN_ST_SH | Number(1,0) | SMALLINT NOT NULL | Operation Prdn Run Start Shift |
| 37 | SIM_SETUP_QUEUE | Character(1) | VARCHAR2(1) NOT NULL |
Simultaneous Setup and Queue
Y/N Table Edit Default Value: N |
| 38 | PLAN_FROZEN_FLG | Character(1) | VARCHAR2(1) NOT NULL |
11/01/01 PCL (CN#PL900-1): Updated
N=No Y=Yes |
| 39 | ASSY_STARTS_QTY | Number(12,4) | DECIMAL(11,4) NOT NULL | Assembly Starts Qty |
| 40 | EXPECTD_CMPL_QTY | Number(12,4) | DECIMAL(11,4) NOT NULL | Expected Completions Qty |
| 41 | FIXED_SCRAP_QTY | Number(12,4) | DECIMAL(11,4) NOT NULL | YBO Enhancement |
| 42 | SETUP_LT | Signed Number(14,4) | DECIMAL(12,4) NOT NULL | Setup Leadtime |
| 43 | SETUP_NO_LT | Signed Number(14,4) | DECIMAL(12,4) NOT NULL | Setup Leadtime Not Included |
| 44 | FXRUN_LT | Signed Number(14,4) | DECIMAL(12,4) NOT NULL | Fixed Run Leadtime |
| 45 | TOT_RUN_LT | Signed Number(14,4) | DECIMAL(12,4) NOT NULL | Total Run Leadtime |
| 46 | QUEUE_LT | Signed Number(14,4) | DECIMAL(12,4) NOT NULL | Queue Leadtime |
| 47 | QUEUE_ADJ_LT | Signed Number(14,4) | DECIMAL(12,4) NOT NULL | Adjusted Queue Leadtime |
| 48 | INTRANS_LT | Signed Number(14,4) | DECIMAL(12,4) NOT NULL | Intransit Leadtime |
| 49 | RUN_RATE | Number(11,4) | DECIMAL(10,4) NOT NULL |
Run Rate
Default Value: 0 |
| 50 | OVERLAP_FLG | Character(1) | VARCHAR2(1) NOT NULL | Overlap Flag |