---
title: "Personal data file format"
id: "personal-data-file-format"
project: "EHR User Guide"
url: "https://help.cloud5.com.au/articles/ehr-user-guide/personal-data-file-format"
updated: 2026-10-19T00:54:19Z
---

# Personal data file format

Generally, when doing a bulk take-on of new employees, you first load your data file using **Employee personal data load**.

The **Employee personal d****ata load** also allows you to load (enhanced) demographics data and gender diversity data if your organisation uses either of these features. In that case, see also [demographics data file format](/articles/ehr-user-guide/demographics-data-file-format) and [gender diversity data file format](/articles/ehr-user-guide/gender-diversity-data-file-format).

## 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 file. |
| --- | --- |

### 

Here's the format to use. An asterisk (**\***) shows which data is mandatory.

| **Column &gt;** | **A\*** | **B\*** | **C\*** | **D\*** | **E\*** | **F\*** | **G\*** | **H\*** | **I\*** | **J\*** | **K** |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
|  | Employee Code | Employee Title | Employee Surname | Employee Given Names | Preferred Name | Birth Date | Employee Sex | Status Code | Status Date | Country of Origin | Country of Citizenship |
| **Characters &gt;** | 10 | 8 | 40 | 30 | 20 | 9 | 1 | 4 | 9 | 4 | 1 |
|  | Must be zero filled to match the setting under Installation Constants. |  |  |  |  | Format:<br>ddmmyy<br><br>ddMmmyy<br><br>ddmmccyy<br><br>ddMmmccyy |  | Must be **e** for all employees | Format:<br>ddmmyy<br><br>ddMmmyy<br><br>ddmmccyy<br><br>ddMmmccyy |  |  |

| **Column &gt;** | **L** | **M** | **N** | **O** | **P** | **Q** | **R** | **S** | **T\*** | **U** | **V** |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
|  | Nationality | Ethnicity | Indigenous | Disability Category | Honors | Date Comm (prior service) | External Admin Unit | Reference Number | Start Date (Date Commenced Agency) | Date Permanent | Date Confirmed |
| **Characters &gt;** | 4 | 4 | 1 | 4 | 10 |  | 4 | 35 |  |  |  |
|  |  |  |  |  |  | Format:<br>ddmmyy<br><br>ddMmmyy<br><br>ddmmccyy<br><br>ddMmmccyy |  |  | Format:<br>ddmmyy<br><br>ddMmmyy<br><br>ddmmccyy<br><br>ddMmmccyy | Format:<br>ddmmyy<br><br>ddMmmyy<br><br>ddmmccyy<br><br>ddMmmccyy | Format:<br>ddmmyy<br><br>ddMmmyy<br><br>ddmmccyy<br><br>ddMmmccyy |

| **Column &gt;** | **W** | **X** | **Y\*** | **Z** | **AA\*** | **AB\*** | **AC** | **AD** | **AE** | **AF** | **AG** |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
|  | Probation Date | Narrative | Private Address 1 | Private Address 2 | Private Suburb (Private Address 3) | Private Post Code | Private NZ Mailtown/City & Fiji City | Private NZ Post Code | Private Country | Private Phone Number | Work Mobile |
| **Characters &gt;** |  | 40 | 30 | 30 | 30 | 10 | 20 | 10 | 20 | 20 | 20 |
|  | Format:<br>ddmmyy<br><br>ddMmmyy<br><br>ddmmccyy<br><br>ddMmmccyy |  |  |  |  |  |  | Required for NZ, otherwise **n** | Required for NZ, otherwise **n** |  |  |

| **Column &gt;** | **AH** | **AI** | **AJ\*** | **AK** | **AL\*** | **AM\*** | **AN** | **AO** | **AP** | **AQ** | **AR** |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
|  | Private Email Address | Private Mobile | Postal Address 1 | Postal Address 2 | Postal Suburb (Postal Address 3) | Postal Post Code | Postal NZ Mailtown/City & Fiji City | Postal NZ Post Code | Postal Country | Work Email Address | Emergency Contact 1 (EC1) Name |
| **Characters &gt;** | 64 | 20 | 30 | 30 | 30 | 10 | 20 | 10 | 20 | 64 | 30 |
|  |  |  |  |  |  |  |  |  | Required for NZ, otherwise **n** |  |  |

| **Column &gt;** | **AS** | **AT** | **AU** | **AV** | **AW** | **AX** | **AY** | **AZ** | **BA** | **BB** | **BC** |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
|  | EC1 Address 1 | EC1 Address 2 | EC1 Suburb (EC1 Address 3) | EC1 Post Code | EC1 Country | EC1 Phone Number | EC1 Relationship | EC1 Work Number | EC1 Mobile Number | Emergency Contact (EC2) Name | EC2 Relationship |
| **Characters &gt;** | 30 | 30 | 30 | 10 | 10 | 20 | 4 | 20 | 20 | 30 | 4 |

| **Column &gt;** | **BD** | **BE** | **BF** | **BG** | **BH** | **BI** | **BJ** | **BK** | **BL** | **BM** | **BN** |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
|  | EC2 Phone Number | EC2 Work Number | EC2 Mobile Number | EC2 Address 1 | EC2 Address 2 | EC2 Suburb (EC2 Address 3) | EC2 Post Code | EC2 Country | User field 1 | User field 2 | User field 3 |
| **Characters &gt;** | 20 | 20 | 20 | 30 | 30 | 30 | 10 | 10 | 30 | 30 | 30 |

| **Column &gt;** | **BO** | **BP** | **BQ** | **BR** | **BS** | **BT** | **BU** | **BV** | **BW** | **BX** | **BY** |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
|  | User field 4 | User field 7 | User Field 8 | Next of Kin Name (3) | Next of Kin Relationship (3) | Next of Kin Phone No (3) | Next of Kin Work Phone (3) | Next of Kin Mobile (3) | Next of Kin (3) Address 1 | Next of Kin (3) Address 2 | Next of Kin Suburb (3) |
| **Characters &gt;** | 30 | 10 | 15 | 30 | 4 | 20 | 20 | 20 | 30 | 30 | 30 |

| **Column &gt;** | **BZ** | **CA** | **CB** | **CC** | **CD** | **CE** | **CF** | **CG** |
| --- | --- | --- | --- | --- | --- | --- | --- | --- |
|  | Next of Kin Post Code (3) | Next of Kin Country (3) | ESS Access (y/n) | Employee User Name | Alternate ESS Template | Previous BMS id | Previous Emp Code | Gender Information |
| **Characters &gt;** | 10 | 10 | 1 | 30 | 4 | 50 | 50 | 200 |
|  |  |  | Enter **y** or **n**. <br>Will default to **n**. |  |  |  |  |  |

| Next topic<br><br>[Demographics data file format](/articles/ehr-user-guide/demographics-data-file-format) |
| --- |

### 

### 

### 

### 

© 2023 Fusion5. All rights reserved.