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 »