The Global Payroll process is a Cobol program. It is not unusual for the payroll process to take a number of hours to complete, depending on factors such as: The number of payees The complexity of the payroll element configuration Infrastructure capability The type of database used The amount of performance tuning employed It is… Read More: Monitoring the Progress of the Global Payroll Process »
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: How to Uniquely Identify Payroll Elements »
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: Outsourcing & Off-shoring: The Cost of Regulatory Compliance and Risk… »
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: How to Un-Finalize a Global Payroll Calendar Group »
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 »
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 »
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 »
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: “Ctrl J” in Google Chrome »
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 »
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: Setting up Mass Triggers »