Import public holidays to be observed by specific locations or the entire company.
Core HR > Account Data > Import Data
Public holidays will need to be loaded into your account based on your region. Your Implementation Consultant will set up your initial public holidays for the current year, and you will need to set them up for each following year.
Best practice is to do this around November or December for the following year, to ensure you have them entered prior to rostering for the new year, as some of these, particularly local public holidays, can change from year to year.
Importing public holidays
To start a new file import, go to Core HR > Account data > Import data and click Create new.
Open the Type dropdown list and select ‘ public holiday’. This name may change depending on your chosen terminology for public holidays .
The purple bar under the file selection will then update to include a ‘Click here’ link for downloading a CSV template that includes all the fields necessary to get importing.
More general information on preparing import files can be found in Importing data overview.
public holidays import requirements
The import will require a unique ID for the public holiday, a name, a specified date, and an ‘Attached to’ reference.
public holidays can be attached to Company, location, or (if location groupings are enabled), the name of a location grouping such as State or Division etc, specify by using the name reference here (not ID). Below the locations are called Store:
| Name | Data type | Length limit | Example | Mandatory | Description |
| ID | String | 20 | PH10001 | Yes |
A unique identifier for the public holiday record. An ID can be comprised of text and/or numbers up to 20 characters in length. If the ID used belongs to an existing deleted public holiday, it will be un-deleted.
|
| Name | String | Christmas 2014 | Yes |
A short name used within the roster and drop-down lists to help you identify the record.
|
|
| Date | Date | 2014-12-25 | Yes |
The date the public holiday falls on. In YYYY-MM-DD format.
|
|
| Attached to | Reference | Company | Yes |
The level within your company the public holiday affects. In most cases this will be set to ‘Company’ as the holiday will affect all areas within it. It could also be attached to specific ‘Areas’ only. Enterprise customers can also attach holidays to their groupings by selecting their group names here.
|
|
| Affects | Reference List | No |
Comma separated list of ID’s. Each must match a predefined, non-deleted ID of records belonging to the ‘attached to’ level. Note: If ‘attached to’ setting is ‘company’ this field will be ignored.
|
||
| Affects | Helper | No |
Each of the ‘attached to’ levels the public holiday is attached to. If the ‘attached to’ setting is ‘company’ this field will not show.
|
When setting Company wide holidays, the ‘Affects’ column will be ignored. You can comma separate a list of location IDs or location grouping IDs to create holidays that will only affect those specific locations orlocation groupings, such as States or Regions.
Once you have imported the data successfully, it will show up and can be edited under Payroll & leave > public holidays .
PLEASE NOTE: If you create or import a public holiday for a period where there are already shifts rostered, please contact Ento Support to arrange a recost of the existing shifts, to ensure any updated earning rates can be applied.