One of the fundamentals of relational database design is the use of unique identifiers. So it’s a reasonable assumption that Payroll Elements can be easily identified by a unique ID of some sort. However nothing is that simple in PeopleSoft Global Payroll. Each Element is assigned a numerical value called a Pin Number (PIN_NUM). Pin… Read More »
As any auditor will tell you: controls, processes and procedures are the secret to mitigating risk and ensuring regulatory compliance. Organisations are like a garden shed, they start off clean and tidy, but have a tendency to accumulate clutter as successive projects, reorganisation and management changes add layer upon layer of controls and processes. Controls,… Read More »
It is sometimes very useful to be able to un-finalize a pay period/Calendar Group while testing and/or debugging. However, there is no online functionality to enable this. The following SQL Script can be used to reset a Calendar Group. After running the script it is important that you run the “Cancel” process using the online… Read More »
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 »
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 »
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 »
I haven’t posted for ages. But I found a workaround that is worth sharing. For those of you that like to use Google Chrome (I do, it’s fast). You may have found that the “Ctrl J” sequence doesn’t work, as this is the shortcut key for the Chrome downloads page. I have found a simple… Read More »
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 »
Mass Triggers are new to version 8.9 and are useful in triggering retrospective calculation when setup tables are changed. For example, if an allowance rate is changed retrospectively Mass Triggers can be used create Iterative and Retro triggers for Employees who have the Earning assigned via EDAP. Unfortunately, the process of creating Mass Triggers is… Read More »
It looks like the Software as a Service (SaaS) model is gaining popularity. PeopleSoft’s founder, David Duffield has signed some major customers for his new “Workday” solution. See this “Information Week” article for more info…