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 »
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 »
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 »
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 »
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 »
It looks like the Software as a Service (SaaS) model is gaining popularity. PeopleSoft’s founder, David Duffield has signed some major customers for his new “Workday” solution. See this “Information Week” article for more info…
I came across an interesting software application for generating a “Manager/Supervisor Manual”. I would be interested to hear if anyone has used it. http://www.gneil.com/products/employee-handbook-software/default.aspx Tags: hrmanual, policies, procedures, software, hr
Testing if a Date Element is null within a Formula Element is simple, right? It is not as obvious as you may think. If you attempt to do this by comparing the date to a numeric value of zero you receive the following error when validating the formula “Mixed datatypes used as operands. (17000,1768) The… Read More »