How to accommodate the new bank holiday in your Sage People HRIS
Bank holiday announced for Her Majesty Queen Elizabeth II’s State Funeral on Monday 19 September
It has been announced that Monday, 19 September, the date of Her Majesty Queen Elizabeth II’s State Funeral, will be a national bank holiday.
Declaring this day as a Bank holiday will enable all individuals, businesses and other organisations to pay their respects to Her Majesty and commemorate Her Reign while marking the final day of the period of national mourning.
This bank holiday will operate in the same way as other bank holidays, and there is no statutory entitlement to time off. However, employers may include bank holidays as part of a worker’s leave entitlement.
The bank holiday will take place across the United Kingdom.
How to process this change in Sage People
If you are running the Sage People HRIS, you need to accommodate the change to this day in your system, then please follow the steps below:
Locate your relevant Work Day Patterns that contain your UK Public Holidays, and click the “Holidays” tab.
Then, click the “New” button in the top right corner of the screen:
Enter details as follows:
This is a one-off public holiday, so we do not need to check the “Recurring” field.
We also need to consider existing absences booked over 19 September 2022. When the absence was first booked, the system calculated how many days/hours the period of absence was, given the public holidays entered at the time. The absence record does not recalculate when the new public holiday has been entered.
To find affected records, create a new formula (checkbox) field on the absence object:
Formula to copy: IF(DATE(2022,9,19) >= fHCM2__Start_Date__c && DATE(2022,9,19) <= fHCM2__End_Date__c ,TRUE,FALSE)
Create a new report based on an “Absences” report type. Here we’ve used the standard “Employment History with Absences” report type.
Bring in the newly created field and add a filter as follows:
You may also want to bring in additional fields such as “Absence #” to locate the record easily, “Start Date”, “End Date” and the new “Date check field”.
Additionally, you may wish to bring in further filters for those on UK HR Departments, Policies or Work Day Patterns so you know whose records meet the criteria.
The records that now appear will need their days/hours value manually amending directly on the absence record.
For further Support
If you have any questions or would like any support on any of the above, please feel free to reach out to the Tugela People Managed Services team at firstname.lastname@example.org
We would like to express our sincerest and heartfelt condolences to The Royal family and all those affected by the passing of Queen Elizabeth II. May the Queen's humility, strength, and resilience be an ongoing example to us all. May Her Majesty the Queen rest well, and May God save the King.