PL_PROD_OP_TMP(SQL Table) |
Index Back |
|---|---|
PL_PROD_OP_TMP03/03/97 JJO CN# PL601-3.4 Made business_unit and op_sequence duplicate keys. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | OP_SEQUENCE | Number(4,0) | SMALLINT NOT NULL | Operation Sequence |
| 3 | PRODUCTION_TASK | Character(254) | VARCHAR2(254) NOT NULL | Production ID from Red Pepper |
| 4 | OP_START_DT | Date(10) | DATE | Operation Start Date |
| 5 | OP_START_TIME | Time(15) | TIMESTAMP | Operation's Start Time |
| 6 | OP_END_DT | Date(10) | DATE | Operation Due Date |
| 7 | OP_END_TIME | Time(15) | TIMESTAMP | Operation's Due Time |
| 8 | FROZEN_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Frozen Flag
B=Both N=No Y=Yes |