Import Work schedules to quickly indicate the regular hours your staff work
Core HR > Account Data > Import Data
Importing Work schedules
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 ‘Work Schedules’.
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 import a Work Schedule importing.
More general information on preparing import files can be found in Importing data overview.
Work schedule import requirements
Column | Field Name | Data Type | Length Limit | Example | Description |
---|---|---|---|---|---|
A | ID* | String | 20 | WS10001 | A unique identifier for the work schedule. 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 work schedule it will be un-deleted. |
B | Pay schedule* | Reference | 20 | Weekly | The pay schedule the work schedule relates to. The work schedule will only show as an option for staff connected to this pay schedule and where their ordinary hours match the total hours defined in the 'Day x ordinary' fields. If the pay schedule is weekly, 7 days worth of 'Day x ordinary' hours need to be defined. If the pay schedule is fortnightly or monthly, 14 days worth of 'Day x ordinary' need to be defined. |
C | Start date* | Date | 3,5 | 2014-12-01 | The start date of the work schedule. This can be in the past or future. This becomes the 'anchor' point for the work schedule's cycle. If the pay schedule you're connecting the work schedule to is weekly or fortnightly, we recommend using the start date of one of the pay cycles. |
D | Day 1 ordinary* | Number | 2,3 | 7.5 | The amount of hours normally worked on the first day of the work schedule. If the date entered in the 'Start date' field is the first day of the pay cycle (recommended for weekly and fortnightly), this number will be the hours normally worked on the first day of the pay cycle. |
E | Day 1 start time | Time | 09:00 | The normal shift start time on the first day of the work schedule. If the date entered in the 'Start date' field is the first day of the pay cycle (recommended for weekly and fortnightly), this number will be the hours normally worked on the first day of the pay cycle. | |
F | Day 2 ordinary* | Number | 2,3 | 7.5 | As above. |
G | Day 2 start time | Time | 09:00 | As above. | |
H | Day 3 ordinary* | Number | 2,3 | 7.5 | As above. |
I | Day 3 start time | Time | 09:00 | As above. | |
J | Day 4 ordinary* | Number | 2,3 | 7.5 | As above. |
K | Day 4 start time | Time | 09:00 | As above. | |
L | Day 5 ordinary* | Number | 2,3 | 8.0 | As above. |
M | Day 5 start time | Time | 09:00 | As above. | |
N | Day 6 ordinary* | Number | 2,3 | 0.0 | As above. |
O | Day 6 start time | Time | 09:00 | As above. | |
P | Day 7 ordinary* | Number | 2,3 | 0.0 | As above. |
Q | Day 7 start time | Time | 09:00 | As above. |
* Mandatory 1 Enterprise Only