Category Archives: All Posts

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 »

Running an Element Resolution Chain on the Forecasting Process

Warning: This is an advanced trick. It is not for the faint hearted and I would definitely not do this in a production environment (i.e. “don’t try this at home…”). The Element Resolution Chain is an invaluable tool for debugging Global Payroll rules. However, it is not possible to generate an Element Resolution Chain when… Read More: Running an Element Resolution Chain on the Forecasting Process »

Documentation Tool

One of the best ways to document GP Configuration is to put an explanation into the “Comments” of the Elements.  This makes it easier for those who follow in your foot sets to understand the configuration without looking in archives and searching through documents formatted by Project Managers who think paper grows on trees :-P. However, I… Read More: Documentation Tool »

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 »

Instant HR Manual, just add water and Hey Presto!

I came across an interesting software application for generating a “Manager/Supervisor Manual”. I would be interested to hear if anyone has used it. http://www.gneil.com/products/employee-handbook-software/default.aspx Tags: hrmanual, policies, procedures, software, hr

Generic vs. Product Specific Skills/Knowledge

I recently had the pleasure of attending a HRMS conference attended by SAP, Oracle & PeopleSoft specialists. I was surprised to find there are many common/non-vendor specific issues. A definitive set of Competencies to work with is a good example. Competencies may be utilized throughout the employee life-cycle, including: Talent Acquisition/Recruitment, Performance Management, Remuneration, Training… Read More: Generic vs. Product Specific Skills/Knowledge »