There are a number of scenarios where it is necessary to identify changes in specific fields in Effective Dated data sets. For example: identifying changes to Full/Part Time Status in Job Data. The following screenshot shows the results of a PS Query that uses the Oracle SQL “LAG” function to identify changes to the FULL_PART_TIME… Read More: Identifying Field Changes using the “LAG” Function »
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 »
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: Identifying a Record/Field name from a Page control »
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 »
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 »
I was recently involved in the design and development of a very useful new piece of functionality for PeopleSoft Global Payroll. The “Self Service Payment Add-On” (SSP) enables employees to submit payment requests directly into PeopleSoft. Requests are then routed for a approval before being posted directly to Positive Input or Element Assignment. SSP is… Read More: PeopleSoft Self Service Payments »
The performance of the Global Payroll configuration Components can be very slow, particularly when working in an environment with a large amount of payroll results. I was recently unable to create a new Accumulator in a client’s environment. Everytime I tried to change the Accumulator to “Use Corrective” checkbox the Component timed out! Here’s some… Read More: Global Payroll Setup Performance Hacks »
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 »
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 »
I had the pleasure of attending the PeopleSoft Partner Summit last week. One of the topics covered was “Selective Adoption”. Selective Adoption represents a major shift in the way the PeopleSoft is “kept current”. No more major upgrades! Version 9.2 will be the last “versioned” release of PeopleSoft. The version number will be redundant within… Read More: PeopleSoft Selective Adoption »