Script to find approved absences not transferred to Fusion Payroll

Summary

Script to find approved absences not transferred to Fusion Payroll

Content

Below script will find all the approved absences that are not transferred to Fusion payroll

 

Please change the Period Start Date and Period End date based on the requirement that is highlight in red below

 SELECT PER.PERSON_NUMBER "Employee Number",
  TYP_VL.NAME "Absence Type",
  ABS.START_DATE "Absence Start Date",
  TO_CHAR(ABS.START_DATETIME,'hh24:mi') "Start Time",
  ABS.END_DATE "Absence End Date",
  TO_CHAR(ABS.END_DATETIME,'hh24:mi') "End Time",
  ABS.DURATION "Absence Duration"
FROM fusion.anc_per_abs_entries ABS,
  fusion.anc_absence_types_vl TYP_VL,