BUSINESS_UNITPRDN_START_DATEPRDN_START_SHIFTSF_MGCAL_SSH_VW(SQL View) |
Index Back |
|---|---|
SF MFG Calend Start 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 | PRDN_START_DATE |
Date(10) | DATE | Prdn Start Date |
| 3 | PRDN_START_SHIFT |
Signed Number(2,0) | DECIMAL(1) NOT NULL | Prdn Start Shift |
| 4 | START_TIME | Time(15) | TIMESTAMP | Start of Shift |
| 5 | END_TIME | Time(15) | TIMESTAMP | End of Shift |