CALENDAR_CODEBUSINESS_UNITPrompt Table: SP_BUMGOP_NONVW
MFG_CAPMFG_DATEMFG_SHIFTAFT=After Midnight
BEF=Before Midnight
NON=None
MG_CAL_WKC_RCAP(SQL Table) |
Index Back |
|---|---|
Runtime Work Center Calendar10/25/00 TKI CN#MG801-2.0 Changed key order for compliance with APRD GPENN-FV28X (switched BUSINESS_UNIT with CALENDAR_CODE) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CALENDAR_CODE |
Character(10) | VARCHAR2(10) NOT NULL | This code is for a group of dates associated with exchange (stock, money, commodity) traded future or option contracts. |
| 2 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BUMGOP_NONVW |
| 3 | MFG_CAP |
Number(13,2) | DECIMAL(12,2) NOT NULL | Capacity |
| 4 | MFG_DATE |
Date(10) | DATE | Date |
| 5 | MFG_SHIFT |
Signed Number(3,0) | DECIMAL(2) NOT NULL | MFG Shift |
| 6 | MFG_SHIFT_CD | Number(2,0) | SMALLINT NOT NULL | Shift Code |
| 7 | START_TIME | Time(15) | TIMESTAMP | Start of Shift |
| 8 | END_TIME | Time(15) | TIMESTAMP | End of Shift |
| 9 | MFG_MONTH | Number(2,0) | SMALLINT NOT NULL | Month |
| 10 | MFG_YEAR | Number(4,0) | SMALLINT NOT NULL | Year |
| 11 | MFG_MIDNIGHT_FLG | Character(4) | VARCHAR2(4) NOT NULL |
Midnight Indicator
AFT=After Midnight BEF=Before Midnight NON=None |
| 12 | MFG_PRDN_DATE | Date(10) | DATE | MFG Production Date |
| 13 | MFG_PRDN_SHIFT | Number(2,0) | SMALLINT NOT NULL | MFG Production Shift |