BUSINESS_UNITPRDNSCH_CAL_CODEPRDN_DUE_DATEPRDN_DUE_SHIFTSF_WC_CAL_ST_VW(SQL View) |
Index Back |
|---|---|
Work Ctr Calendar Shift View |
| select business_unit, prdnsch_cal_code, prdnsch_date, prdnsch_shift, start_time, end_time from PS_SF_WC_CAL_SH_VW |
| # | 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 | PRDN_DUE_DATE |
Date(10) | DATE | Prdn Due Date |
| 4 | PRDN_DUE_SHIFT |
Signed Number(2,0) | DECIMAL(1) NOT NULL | Prdn Due Shift |
| 5 | START_TIME | Time(15) | TIMESTAMP | Start of Shift |
| 6 | END_TIME | Time(15) | TIMESTAMP | End of Shift |