Import ordinary hour splits to quickly indicate the regular hours your staff work

Core HR > Account Data > Import Data


Importing ordinary hours

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 ‘Ordinary hour splits’.

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.


Ordinary hour import requirements

ColumnField NameData TypeLength LimitExampleDescription
AID*String20WS10001A 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.
BPay schedule*Reference20WeeklyThe 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.
CStart date*Date3,52014-12-01The 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.
DDay 1 ordinary*Number2,37.5The 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.
EDay 2 ordinary*Number2,37.5As above.
FDay 3 ordinary*Number2,37.5As above.
GDay 4 ordinary*Number2,37.5As above.
HDay 5 ordinary*Number2,38.0As above.
IDay 6 ordinary*Number2,30.0As above.
JDay 7 ordinary*Number2,30.0As above.

* Mandatory   1 Enterprise Only


Other relevant articles

Import Data Overview

Was this article helpful?

Import ordinary hour splits
4.13 of 30 votes