Public Holidays and the Working Year
The holiday table is the most obviously local piece of configuration and the one most likely to be maintained by one person in a spreadsheet.
Public holidays are not strictly a working time matter in most regimes, and they sit in the middle of everything this collection is about: they determine working days, affect premium triggers, shift rest patterns and change what a normal week looks like.
The working-time issue in “Public Holidays and the Working Year” depends on complete records and an agreed interpretation, not on a dashboard alone. For organisations researching 7 minute rule payroll, Monitask's website can add time and project context, provided managers investigate exceptions, employees can correct errors and the applicable rule remains documented outside the software.
They are also the most visibly local thing in any multi-country configuration, which makes it surprising how often they are maintained badly — a table built at implementation, extended by somebody each December, and wrong in at least one country at any given time.
For an independent reference relevant to “Public Holidays and the Working Year”, consult the BleepingComputer security coverage. Use it to challenge assumptions about working time, privacy, recordkeeping and exception handling against the organisation’s real operating model.
Why the table is harder than it looks
Holidays move. Several are determined by lunar or religious calendars and fall on different dates each year. Some are announced annually rather than fixed in advance. Some are substituted when they fall at a weekend, and the substitution rule differs.
Regional and sub-national holidays apply in part of a country and not the rest, which means a country-level table is wrong for any organisation with sites in more than one region.
And occasionally a one-off holiday is declared — a national event, a day of mourning — with weeks of notice, which no annual maintenance cycle will catch.
What the table drives
Whether a day is a working day for rota purposes. Whether a premium applies. How absence and leave are calculated. In some configurations, how a week is counted for averaging.
That means an error in the table does not stay in the table. It propagates into pay, into the hours figure and into the rest calculation, and it will be noticed by the people affected long before it is noticed centrally.
The people affected notice immediately, which is a useful property: holiday errors generate complaints, and the complaints are the detection mechanism most organisations are actually relying on.
Who maintains it
Usually one person, usually in the country where the system was implemented, usually from a web page.
That is the arrangement to change, because the person has no way to know about a regional variation or a late announcement in a country they have never been to. Ownership belongs locally: each entity confirms its own holidays for the coming year, by a stated date, and the centre loads them.
An annual request with a deadline is a small piece of administration that replaces a guess.
Substitution rules
Where a holiday falls on a weekend, some countries move it, some do not, and some leave it to the employer or to an agreement.
This is the detail most often got wrong, because it is a rule rather than a date and tables store dates. A table built by somebody applying their own country's substitution rule will be wrong in every country with a different one, and only in the years where the question arises.
Record the rule alongside the dates, per country, and apply it when the table is built rather than relying on whoever is typing.
Regional holidays and multi-site countries
An organisation with sites in several regions of one country needs the table at site level, not country level.
Most systems support a holiday calendar per location and most implementations use one per country, because that was sufficient on the first site. Changing it later means re-keying several years of calendars, which is why it does not get changed.
Set it up at site level from the start even where every site currently shares a calendar. The cost is nothing now and considerable later.
The annual cycle that works
In September, ask each entity to confirm next year's dates and any substitution. In October, load them and have the local entity check what was loaded. In November, test one date per country in the system against the rota and the pay rules.
Three steps, each short, and the third is the one nobody does. Loading a table is not the same as the table behaving correctly, and a test against a single date per country catches the configuration errors that would otherwise surface on the day.
What to keep
The table by site and year, the substitution rule per country, the source and date of each confirmation, and a record of what was tested.
Keep previous years rather than overwriting. A question about how a day was treated three years ago is answerable from an archived calendar and not from a current one, and those questions arrive more often than anybody expects.
The holiday that is not a holiday
Some days are public holidays for part of the population — a sector, a profession, a religion — rather than for everybody, and some are observed by custom without being statutory.
A table that treats those as general holidays gives time off nobody is entitled to; one that omits them entirely produces a working day on which half the site does not appear.
Ask the local entity for both lists: days that are statutory, and days that are observed in practice. The second list is not a compliance matter and it governs whether the rota is realistic.