BUSINESS_UNITPrompt Table: SP_BUMGOP_NONVW
MG_SHIFT1=1
2=2
3=3
C=Compressed
N=Not Applicable
R=Rotating
Default Value: 1
END=End Time
STRT=Start Time
MG_SHIFTS(SQL Table) |
Index Back |
|---|---|
Manufacturing Shifts07/23/98 TKI CN#MG800-5.0 Removed SHIFT field and replaced with MG_SHIFT for database reconciliation project |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BUMGOP_NONVW |
| 2 | MG_SHIFT |
Number(2,0) | SMALLINT NOT NULL |
MG_SHIFT represents the shift code (i.e., 1, 2, 3, etc) for a manufacturing shift.
07/23/98 TKI CN#MG800-5.0
Created to replace SHIFT for the database reconcilation project (8.0)
1=1 2=2 3=3 C=Compressed N=Not Applicable R=Rotating |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | START_TIME | Time(15) | TIMESTAMP | Start of Shift |
| 5 | CE_SHIFT_PREMIUM | Signed Number(32,15) | DECIMAL(30,15) NOT NULL |
Shift Premium
Default Value: 1 |
| 6 | END_TIME | Time(15) | TIMESTAMP | End of Shift |
| 7 | TIME_ASSOC_PRDN_DT | Character(4) | VARCHAR2(4) NOT NULL |
Time Assoc. with Prdn Date
END=End Time STRT=Start Time |