Mondayised Public Holiday - report guide

Follow

This guide will show you more about the data that is in the Mondayised Public Holiday PowerBi report.

What does the report do?

The report looks at Public Holidays that have an Observed day, e.g. Mondayised public holidays. This gives a view of Pathways Emplive timesheets where a public holiday entitlement is due based on NZ legislation.  This compares to what EmpLive config would generate and show if there is a discrepancy that would require manual adjustment in either EmpLive or Datapay.

NZ Legislation looks at the actual public holiday date first, and if that is a normal working day (NWD) then the entitlements apply to that day, and the public holiday is not mondayised.  If the actual public holiday is not a NWD, then it is Mondayised so all entitlements go to that date.

Emplive has been incorrectly configured to look at everyone that worked Saturday and give them entitlements on that day, and ignore Monday rules unless they didn’t work on Saturday.

Parameters

  • The hours are looked at for shifts with a start or end time on the Public holiday or the Public Holiday observed.
  • NWD is calculated using the same criteria an Alt Day generation.  Worked 4 of the previous 4 of the same day, or 50% of the past 13 of the same day
  • Key to column headings is available on the BI report

Where does the data come from? 

The data is come from a table in WiseStrategicData called general.NZPublicHolidays, it has both regional and non-regional public holidays. The data for the table is pulled from the NZ Public Holidays API https://www.public-holidays.nz/

What data is excluded?

  • People who have left.
  • People that had no timesheet for either the public holiday or the public holiday observed
  • People not using EmpLive

Who gets access?

Report is limited to IS and Payroll

If you need to check why someone doesn't have access then contact helpdesk@wisegroup.co.nz.

To request access request access for a non-manager raise a Data access request.     

0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.