Category Archives: All Posts

Identifying a Record/Field name from a Page control

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 »

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 »

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 »

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 »

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 »

Calendar View: PS_SCH_CLND_VW

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 »