---
title: "Work patterns file format"
id: "work-patterns-file-format"
project: "EHR User Guide"
url: "https://help.cloud5.com.au/articles/ehr-user-guide/work-patterns-file-format"
updated: 2026-10-19T00:53:13Z
---

# Work patterns file format

When uploading work pattern codes in bulk to EmpowerHR, you use the option called **Work Pattern Code Data Load** ****from the **Data Take-On Initiation** screen. Here are the file formats to use.

## What files do I need to prepare?

You need to create a tab-delimited (**.txt**) file for each type of required data.

| ![Information](/resources/Storage/ehr-user-guide/ehr-user-guide/Info.png) | Remember  to exclude column headings from the files. |
| --- | --- |

### Work pattern code file format 

Here's the format to use. An asterisk (**\***) shows which data is mandatory.

| **Column &gt;** | **A\*** | **B** | **C** | **D** | **E** | **F** |
| --- | --- | --- | --- | --- | --- | --- |
|  | Work Pattern Code | Description | Abbreviation | Leave Hours Without Certificate | Leave Hours with Paramedical Certificate | Leave Hours with Carer's Certificate |
| **Characters &gt;** | 4 | 30 | 10 | 8 including decimal point | 8 including decimal point | 8 including decimal point |

### Work pattern detail file format 

Here's the format to use. An asterisk (**\***) shows which data is mandatory.

| **Column &gt;** | **A\*** | **B** | **C** | **D** |
| --- | --- | --- | --- | --- |
|  | Work Pattern Code | Pay Hours | Leave Hours | Shift Code |
| **Characters &gt;** | 4 | 8 | ​8 | 4 |

## Examples of files

The following examples show **Work Pattern Code** and **Work Pattern Details** spreadsheets.

| ![Information](/resources/Storage/ehr-user-guide/ehr-user-guide/Info.png) | **Things to note**<br><ul><li>You must exclude column headings from the files. We&#39;ve included them just to explain the examples.</li><li>You save each spreadsheet as a <b>.txt </b>file for loading.</li></ul> |
| --- | --- |

Here we are loading only one work pattern which is for a standard 38 hour morning shift (and the payroll works on a 28 day calendar).

| Work Pattern Code | The **Work Pattern Code** spreadsheet has one line with the **leave hours without certificate** detail.<br><br>![](/resources/Storage/ehr-user-guide/work-patterns-file-format/wk%20patt%20-%20ssheet%201.png) |
| --- | --- |
| Work Pattern Detail | The **Work Pattern Detail** spreadsheet has a line for each of the 28 days.<br><br>![](/resources/Storage/ehr-user-guide/work-patterns-file-format/wk%20patt%20-%20ssheet%202.png) |

| Next topic<br><br>[GL payment code accounts file format](/articles/ehr-user-guide/gl-payment-code-accounts-file-format) |
| --- |

© 2023 Fusion5. All rights reserved.