Category Archives: SQL

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 »