Category Archives: All Posts

Off-Cycle design using Generation Controls

This post explores an Off-Cycle design pattern for scenarios where automatic resolution of selected “downstream” Elements is required. To facilitate automatic processing it is necessary to use the Off-Cycle, Element Selection “ALL” option. However, using the “ALL” setting may result in resolution of unwanted elements. This post describes a solution using Generation Controls to govern… Read More: Off-Cycle design using Generation Controls »

Absence Management/Leave Queries

I frequently get requests to report absences.  Most Absences are administered using Absence Management.  However, extended leave requests/absences are typically administered via Job Data, which is more difficult to extract. This is a relatively simple to extract Global Payroll absence events using the “PS_GP_ABS_EVENT” record.  For example the following SQL Script: SELECT c.EMPLID, c.EMPL_RCD, c.NAME,… Read More: Absence Management/Leave Queries »

How to remove a blocked Global Payroll Run Control

This post covers options for dealing with the following PeopleSoft, Global Payroll process (GPPDPRUN) error: User %1 has started or scheduled a run for all groups using Run Control %2. This error is caused by another process that is running or blocked/locked/stuck. The following scenarios will cause this error: If the payroll process is in… Read More: How to remove a blocked Global Payroll Run Control »

Select Recipient at Element Assignment

Assigning a Deduction Recipient to an Earning or Deduction at Employee level using the “Payee Data > Net Pay / Recipient Elections > Add Deduction Recipients” Component works, but there’s an easier way that improves usability for payroll administrators. Here’s how to configure a solution that allows Deduction Recipients to be selected from Element Assignment, using… Read More: Select Recipient at Element Assignment »

How to Prevent Submission of Ineligible Absence Requests

I have worked at a number of PeopleSoft, Global Payroll sites that customized the Self Service Component/s to prevent Employees and/or Managers from submitting an Ineligible Absence Request.  Here’s how to present an Error if an Ineligible Absence Request is submitted via Self Service, without customization: Use the “Maintain Text Catalog” Component to create an… Read More: How to Prevent Submission of Ineligible Absence Requests »

Monitoring the Progress of the Global Payroll Process

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 »

How to Uniquely Identify Payroll Elements

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 »

Outsourcing & Off-shoring: The Cost of Regulatory Compliance and Risk Mitigation

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… »

How to Un-Finalize a Global Payroll Calendar Group

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 »