BUSINESS_UNITPRDNSCH_DATEPRDNSCH_SHIFTSF_MG_CAL_SH_VW(SQL View) |
Index Back |
|---|---|
MFG Calendar Shift View07/23/98 TKI CN#MG800-5.0 Replaced b.shift with b.mg_shift in query for database reconciliation project |
| select a.business_unit, a.mfg_date, a.mfg_shift, b.start_time, b.end_time from ps_mg_cal_rel_cap a, PS_MG_SHIFTS b where a.mfg_shift >= 1 and a.mfg_shift <= 3 and a.business_unit = b.business_unit and a.mfg_shift_cd = b.mg_shift |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | PRDNSCH_DATE |
Date(10) | DATE | Production Schedule Date |
| 3 | PRDNSCH_SHIFT |
Signed Number(2,0) | DECIMAL(1) NOT NULL | Production Schedule Shift |
| 4 | START_TIME | Time(15) | TIMESTAMP | Start of Shift |
| 5 | END_TIME | Time(15) | TIMESTAMP | End of Shift |