---
title: "Organisational level file format"
id: "organisational-level-file-format"
project: "EHR User Guide"
url: "https://help.cloud5.com.au/articles/ehr-user-guide/organisational-level-file-format"
updated: 2026-10-19T00:53:18Z
---

# Organisational level file format

When uploading organisational level codes in bulk to EmpowerHR, you use the following options from the **Data Take-On Initiation** screen:

* Org Level 1 Code Data Load
* Org Level 2 Code Data Load
* Org Level 3 Code Data Load
* Division Codes Data Load
* Branch Codes Data Load
* Section Codes Data Load

Here's the file format to use.

## What file do I need to prepare?

You need to create a tab-delimited (**.txt**) file containing the required data.

| ![Information](/resources/Storage/ehr-user-guide/ehr-user-guide/Info.png) | Remember  to exclude column headings from the files. |
| --- | --- |

### 

Here's the format to use. An asterisk (**\***) shows which data is mandatory.

| **Column &gt;** | **A\*** | **B** | **C** | **D** | **E** | **F** | **G** |
| --- | --- | --- | --- | --- | --- | --- | --- |
|  | Code for:<br><br>Org Level, *or*<br><br>Division, *or*<br><br>Branch, *or*<br><br>Section | Description | Abbreviation | Gene Flag | Manager Position | Admin Position | Contact Name |
| **Characters &gt;** | 4 | 40 | 10 | 1 | 10 | 10 | 40 |

| **Column &gt;** | **H** | **I** | **J** | **K** | **L** |
| --- | --- | --- | --- | --- | --- |
|  | Contact Address Line 1 | Contact Address Line 2 | Contact Suburb | Contact State | Contact Postcode |
| **Characters &gt;** | 30 | 30 | ​30 | 3 | 10 |

| **Column &gt;** | **M** | **N** | **O** | **P** | **Q** | **R** | **S** |
| --- | --- | --- | --- | --- | --- | --- | --- |
|  | Contact Country | Postal Address Line 1 | Postal Address Line 2 | Postal Suburb | Postal State | Postal Postcode | Postal Country |
| **Characters &gt;** | 20 | 30 | 30 | 30 | 3 | 10 | 20 |

| **Column &gt;** | **T** | **U** | **V** | **W** | **X** | **Y** | **Z** |
| --- | --- | --- | --- | --- | --- | --- | --- |
|  | Phone Number | Fax Number | Email Address | Sort Code 1 | Sort Code 2 | Sort Code 3 | Sort Code 4 |
| **Characters &gt;** | 20 | 20 | 50 | 4 | 4 | 4 | 4 |

| **Column &gt;** | **AA** | **AB** | **AC** | **AD** |
| --- | --- | --- | --- | --- |
|  | Sort Code 5 | Sort Code 6 | Information | Website |
| **Characters &gt;** | 4 | 4 | 1200 | 200 |
|  |  |  | Org Levels 1 & 2 only | Org Levels 1 & 2 only |

| Next topic<br><br>[Work patterns file format](/articles/ehr-user-guide/work-patterns-file-format) |
| --- |

© 2023 Fusion5. All rights reserved.