BUSINESS_UNITPRDNSCH_CAL_CODEPRDNSCH_DATEPRDNSCH_SHIFTSF_WC_CAL_SH_VW(SQL View) |
Index Back |
|---|---|
Work Ctr 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.calendar_code, a.mfg_date, a.mfg_shift, b.start_time, b.end_time from PS_MG_CAL_WKC_RCAP 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_CAL_CODE |
Character(10) | VARCHAR2(10) NOT NULL | Production Schedule Cal Code |
| 3 | PRDNSCH_DATE |
Date(10) | DATE | Production Schedule Date |
| 4 | PRDNSCH_SHIFT |
Signed Number(2,0) | DECIMAL(1) NOT NULL | Production Schedule Shift |
| 5 | START_TIME | Time(15) | TIMESTAMP | Start of Shift |
| 6 | END_TIME | Time(15) | TIMESTAMP | End of Shift |