peoplesoft – SupportingElement

Calendar View: PS_SCH_CLND_VW

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… Read More: Calendar View: PS_SCH_CLND_VW »

Preventing a formula from being processed in retro calculations

It is often necessary to change the behaviour of a formula depending on wether it is being called from the current calendar or a retro calendar. This tip shows you a simple method for determining if a formula is being processed in the current calendar. The “CURR PRD CAL ID” System Element returns the Calendar… Read More: Preventing a formula from being processed in retro calculations »