Skip to main content

Where to find leave in days information

Affinity Knowledge HubLeaveNZ leaveLeave in days
Table of contents

In Affinity

Using Query Manager, Payroll Analyst and myPA, information can be extracted from pay adjustments, timesheets and leave history in order to analyse leave payments made in days. This is particularly useful during leave audits. Here are some suggested queries you can run in Query Manager.

  • Under the Emp Leave History category, create a query based on fields in the PHOL table that reports on leave data created and stored in each pay period.

  • Under the Allowances and Deductions category, create a query based on fields in the ALLDED table that reports on current pay element configuration. Note that this query will not report on any changes to pay element configuration (run the Combined Audit Report to get that information).

  • Under the Awards category, create a query based on fields in the AWARD table that reports on current award configuration. Note that this query will not report on any changes to award configuration (run the Combined Audit Report to get that information).