Home » PeopleSoft HCM
Calendar View: PS_SCH_CLND_VW
Thứ Hai, 7 tháng 8, 2017
Bởi: Đoàn Thành Trung
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:
SELECT DUR,
SCHED_HRS
FROM PS_SCH_CLND_VW
WHERE SCHEDULE_ID = ‘KA8HRDAY’
AND DUR >= ‘01-SEP-2011’
AND DUR <= ’30-SEP-2011’
|
Comments[ 0 ]
Đăng nhận xét