Sometimes it is necessary to know the Table and Field name associated with a text box or control on displayed on a PeopleSoft Page. Here’s a few ways to identify the table/field: “Inspect Element” Right click the control for which you want to know the table/field name. Select “Inspect” In the “Elements” tab of the… Read More »
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 »
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 »
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 »
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 »
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 »
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 »