BUSINESS_UNITPrompt Table: BUS_UNIT_TBL_MG
1=1
2=2
3=3
C=Compressed
N=Not Applicable
R=Rotating
Prompt Table: MG_SHIFTS_VW
MG_WORK_WKSH_VW(SQL View) |
Index Back |
|---|---|
Work Week Shift View07/23/98 TKI CN#MG800-5.0 Replaced SHIFT with MG_SHIFT; replaced a.shift with a.mg_shift and b.shift with b.mg_shift in query for database reconciliation project |
| select a.business_unit, a.mg_shift, b.start_time, b.end_time from PS_MG_WORK_WK_DEFN a, ps_mg_shifts b where a.business_unit = b.business_unit and a.mg_shift = b.mg_shift |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: BUS_UNIT_TBL_MG |
| 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 Prompt Table: MG_SHIFTS_VW |
| 3 | WWK_START_TM | Time(15) | TIMESTAMP | Work Week Start Time |
| 4 | WWK_END_TM | Time(15) | TIMESTAMP | Work Week End Time |