PL_PRDN_CAL_AET(SQL Table) |
Index Back |
|---|---|
PL AE Production Cal Check AET04/16/02 EGS (CN#PL900-1): Added |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 3 | PRODUCTION_ID | Character(10) | VARCHAR2(10) NOT NULL | Production ID |
| 4 | PLAN_NEW_FLG | Character(1) | VARCHAR2(1) NOT NULL | New Order / Schedule |
| 5 | PL_SEQ_NBR | Number(9,0) | DECIMAL(9) NOT NULL | 01/09/02 EGS (CN#PL900-1): Added |
| 6 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 7 | TOTAL_QTY | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Total Quantity |
| 8 | NEW_PRDN_QTY | Number(12,4) | DECIMAL(11,4) NOT NULL | Production Start Qty |
| 9 | OP_SEQ | Number(3,0) | SMALLINT NOT NULL | Op Seq |
| 10 | CONFIG_CODE | Character(50) | VARCHAR2(50) NOT NULL | Product Configurator |
| 11 | CHECK_DATE | Date(10) | DATE | Check Date |
| 12 | CHECK_TIME | Time(15) | TIMESTAMP | 04/16/02 EGS (CN#PL900-1): Added |
| 13 | START_DATE | Date(10) | DATE | Start Date for Gen Standing PO |
| 14 | START_TIME | Time(15) | TIMESTAMP | Start of Shift |
| 15 | END_DATE | Date(10) | DATE | End Date |
| 16 | END_TIME | Time(15) | TIMESTAMP | End of Shift |
| 17 | START_TM | Time(15) | TIMESTAMP | Represents the process starting time associated with position calculation. |
| 18 | END_TM | Time(15) | TIMESTAMP | End Time |
| 19 | APPROVED_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Approved by Auditor
D=Denied N=Not Approved Y=Approved |
| 20 | BOM_CODE | Number(2,0) | SMALLINT NOT NULL | CN# EN800-3.0, anna 09/21 added new field to database |
| 21 | CUM_YIELD | Number(8,4) | DECIMAL(7,4) NOT NULL | Expected Yield % |
| 22 | EXPECTED_PRDN_QTY | Number(12,4) | DECIMAL(11,4) NOT NULL | Production End Qty |
| 23 | FROZEN_SUBSTITUTES | Character(1) | VARCHAR2(1) NOT NULL |
Frozen Substitutes
B=Both N=No Y=Yes |
| 24 | NEW_END_DATE | Date(10) | DATE | Due Date |
| 25 | NEW_END_TIME | Time(15) | TIMESTAMP | Due Time |
| 26 | NEW_START_DATE | Date(10) | DATE | Start Date |
| 27 | NEW_START_TIME | Time(15) | TIMESTAMP | Start Time |
| 28 | PL_CHUNK_SORT | Character(43) | VARCHAR2(43) NOT NULL | Sort Sequence for Chunking |
| 29 | PL_PLAN_STATUS | Character(2) | VARCHAR2(2) NOT NULL |
11/01/01 PCL (CN#PL900-1): Added
05=Planned 15=Firmed 90=Canceled |
| 30 | PLAN_FROZEN_FLG | Character(1) | VARCHAR2(1) NOT NULL |
11/01/01 PCL (CN#PL900-1): Updated
N=No Y=Yes |
| 31 | PRDN_DUE_DATE | Date(10) | DATE | Prdn Due Date |
| 32 | PRDN_START_DATE | Date(10) | DATE | Prdn Start Date |
| 33 | PROBINST | Character(20) | VARCHAR2(20) NOT NULL | Optimization Problem Instance |
| 34 | REF_ROUTING_ITEM | Character(18) | VARCHAR2(18) NOT NULL | Reference Routing Item |
| 35 | RTG_CODE | Number(2,0) | SMALLINT NOT NULL | Routing Code |
| 36 | SEQ_NBR | Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |
| 37 | MA_PRDN_ID_FLG | Character(1) | VARCHAR2(1) NOT NULL |
10/18/99 SCC CN#IC800: Add label MAINTAIN_PID
N=No Y=Yes |
| 38 | ORIG_END_DATE | Date(10) | DATE | Original Due Date |
| 39 | ORIG_END_TIME | Time(15) | TIMESTAMP | Original DueTime |
| 40 | ORIG_START_DATE | Date(10) | DATE | Original Start Date |
| 41 | ORIG_START_TIME | Time(15) | TIMESTAMP | Original Start Time |
| 42 | PRDN_AREA_CODE | Character(10) | VARCHAR2(10) NOT NULL | Production Area |
| 43 | PROD_STATUS | Character(2) | VARCHAR2(2) NOT NULL |
Production Status
10=Entered 15=Firmed 20=Released 30=In Process 40=Pend Cmpl 50=Completed 60=Clsd/Labor 70=Clsd/Acctg 90=Canceled |
| 44 | PRODUCTION_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
JNW 11/1/98 (CN#SF800-13) activated teardown xlat
PR=Production RW=Rework SV=Service TD=Teardown |
| 45 | TOLERANCE_FLG | Character(1) | VARCHAR2(1) NOT NULL | jnw changed long description for planning phoenix - commit plan 10/18/02 JC (CN#PL880-1): Added TOLERANCE label |
| 46 | PEG_STATUS | Character(2) | VARCHAR2(2) NOT NULL |
07/21/04 EGS: Created
10=Open 20=Completed 30=Canceled 40=Not Pegged |
| 47 | ORIG_PRDN_QTY | Number(12,4) | DECIMAL(11,4) NOT NULL | Original Production Qty |
| 48 | 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 |