The “PS_SCH_CLND_VW” view shows Schedule Details by calendar day, including Shift ID, Workday day and Scheduled Hours.
This is very useful for Arrays that require schedule details. It is equally useful for analysis of payroll/absence results (e.g. Forecasting validation)
The following SQL shows an example of its use:
WHERE SCHEDULE_ID = ‘KA8HRDAY’
AND DUR >= ‘01-SEP-2011’
AND DUR <= ’30-SEP-2011’
Update, 2 Nov 2017: The “PS_TL_DATES_TBL” is also useful to derive schedule related information.