BUSINESS_UNITNEW_END_DATENEW_END_SHIFTSF_WCCAL_ESH_VW(SQL View) |
Index Back |
|---|---|
SF WKC Calend End 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_WKC_RCAP a, ps_mg_shifts b where 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 | NEW_END_DATE |
Date(10) | DATE | Due Date |
| 3 | NEW_END_SHIFT |
Signed Number(2,0) | DECIMAL(1) NOT NULL | Due Shift |
| 4 | START_TIME | Time(15) | TIMESTAMP | Start of Shift |
| 5 | END_TIME | Time(15) | TIMESTAMP | End of Shift |