BUSINESS_UNITMFG_DATEMFG_SHIFTAFT=After Midnight
BEF=Before Midnight
NON=None
Default Value: NON
MG_CAL_REL_COPY(SQL Table) |
Index Back |
|---|---|
Runtime Prod Calendar Copy |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | MFG_DATE |
Date(10) | DATE | Date |
| 3 | MFG_SHIFT |
Signed Number(3,0) | DECIMAL(2) NOT NULL | MFG Shift |
| 4 | MFG_SHIFT_CD | Number(2,0) | SMALLINT NOT NULL | Shift Code |
| 5 | START_TIME | Time(15) | TIMESTAMP | Start of Shift |
| 6 | END_TIME | Time(15) | TIMESTAMP | End of Shift |
| 7 | MFG_REL_CAP | Number(13,2) | DECIMAL(12,2) NOT NULL | Relative Capacity |
| 8 | MFG_MONTH | Number(2,0) | SMALLINT NOT NULL | Month |
| 9 | MFG_YEAR | Number(4,0) | SMALLINT NOT NULL | Year |
| 10 | MFG_MIDNIGHT_FLG | Character(4) | VARCHAR2(4) NOT NULL |
Midnight Indicator
AFT=After Midnight BEF=Before Midnight NON=None Default Value: NON |
| 11 | MFG_PRDN_DATE | Date(10) | DATE | MFG Production Date |
| 12 | MFG_PRDN_SHIFT | Number(2,0) | SMALLINT NOT NULL | MFG Production Shift |