BUSINESS_UNITMG_SHIFT1=1
2=2
3=3
C=Compressed
N=Not Applicable
R=Rotating
END=End Time
STRT=Start Time
MG_SHIFTS_VW(SQL View) |
Index Back |
|---|---|
Manufacturing Shifts View07/23/98 TKI CN#MG800-5.0 Removed SHIFT and replaced with MG_SHIFT; replaced a.shift with a.mg_shift in query for database reconciliation project |
| SELECT a.business_unit , a.mg_shift , a.descr , a.ce_shift_premium , a.start_time , a.end_time , a.time_assoc_prdn_dt FROM PS_MG_SHIFTS a |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 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 | CE_SHIFT_PREMIUM | Signed Number(32,15) | DECIMAL(30,15) NOT NULL | Shift Premium |
| 5 | START_TIME | Time(15) | TIMESTAMP | Start of Shift |
| 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 |