---
title: "Position and pay data file format"
id: "position-and-pay-data-file-format"
project: "EHR User Guide"
url: "https://help.cloud5.com.au/articles/ehr-user-guide/position-and-pay-data-file-format"
updated: 2026-10-19T00:54:15Z
---

# Position and pay data file format

## Check transaction rules

When taking on employee position and pay data, we recommend you check the settings on the following two transaction rules to understand what happens in EmpowerHR.

| ![Information](/resources/Storage/ehr-user-guide/ehr-user-guide/Info.png) | The rules are located at **Administration** &gt; **Screen Management** &gt; **Transaction Rules** &gt; **Rules By Frame/Function**. |
| --- | --- |

| ![Information](/resources/Storage/ehr-user-guide/ehr-user-guide/Info.png) | Cost code shown in the following table is an example. These rules cover other items. |
| --- | --- |

| **When the transaction rules...** | **are set to...** | **this happens...** |
| --- | --- | --- |
| Default from previous movement | n | EmpowerHR expects a cost code in the take-on table<br><br>If the cost code is split, EmpowerHR expects splits in the take-on table |
| Display Only | n |
| Default from previous movement | y | EmpowerHR defaults the cost code and splits from the position, but overrides it if there is a non-blank code in the take-on table |
| Display Only | n |
| Default from previous movement | y | EmpowerHR defaults the cost code and splits from the position and ignores anything in the take-on tables |
| Display Only | y |
| Default from previous movement | n | No cost code is taken on as this is an invalid combination |
| Display Only | y |

## 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** | **H** | **I** |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
|  | Employee Code | Position Number | Date the position was held | Date the position was held up to | Award Code | Cost Centre | Agency/ Location | Program Activity/ Job Number | Section Code |
| **Characters &gt;** | 10 | 10 |  |  | 8 | 16 | 4 | 16 | 4 |
|  |  |  | Format:<br><br>ddmmyy<br><br>ddMmmyy<br><br>ddmmccyy<br><br>ddMmmccyy | Format:<br><br>ddmmyy<br><br>ddMmmyy<br><br>ddmmccyy<br><br>ddMmmccyy |  |  |  |  |  |

| **Column &gt;** | **J** | **K** | **L** | **M** | **N** | **O** | **P\*** | **Q\*** | **R** |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
|  | Duty Code | Location Code | Authorising Officer | Employment Type | Employment Condition | Probation Period | Work Pattern Code | Public Holiday Code | Contract Reason |
| **Characters &gt;** | 4 | 4 | 4 | 4 | 4 | 12 | 6 | 4 | 4 |

| **Column &gt;** | **S** | **T** | **U** | **V** | **W** | **X\*** | **Y\*** | **Z\*** | **AA\*** |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
|  | Contract Expiry Date | Contract Signed | User Field 4 | User Field 5 | User Narrative | Award Level | Pay Basis | Hours Per Period | Hours Per Week |
| **Characters &gt;** |  | 1 | 8 | 8 | 180 | 2 | 1 | 10 including 2 decimal places | 10 including 2 decimal places |
|  | Format:<br><br>ddmmyy<br><br>ddMmmyy<br><br>ddmmccyy<br><br>ddMmmccyy |  |  |  |  | If hourly paid position, enter level.<br><br>Otherwise, leave blank. | **h** = hourly<br><br>**s** = salary |  |  |

| **Column &gt;** | **AB\*** | **AC** | **AD** | **AE** | **AF** | **AG** | **AH** | **AI** | **AJ\*** |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
|  | FTE % | Base Salary | Hourly Rate | Variation % | Variation Amount | Salary Maintain | Salary Barrier Level | Increment Date | Auto Increment |
| **Characters &gt;** | 10 including 2 decimal places | 10 | 12 including 6 decimal places | 10 | 10 | 1 | 2 |  | 1 |
|  |  | If salary paid position, enter salary.<br><br>Otherwise, leave blank. |  |  |  |  |  | Format:<br><br>ddmmyy<br><br>ddMmmyy<br><br>ddmmccyy<br><br>ddMmmccyy | **y** = yes<br><br>**n** = no<br><br>**d** = schools functionality |

| **Column &gt;** | **AK\*** | **AL\*** | **AM\*** | **AN** | **AO** |
| --- | --- | --- | --- | --- | --- |
|  | Pay By Exception | Pay | Pay Start Date | Employee Remuneration Narrative | Deleted Flag |
| **Characters &gt;** | 1 | 1 |  | 100 | 1 |
|  | **y** = yes<br><br>**n** = no<br><br>**d** = schools functionality | **y** = yes<br><br>**n** = no | Format:<br><br>ddmmyy<br><br>ddMmmyy<br><br>ddmmccyy<br><br>ddMmmccyy |  | Must be blank. |

### Employee cost code splits

| **Column &gt;** | **A\*** | **B\*** | **C\*** |
| --- | --- | --- | --- |
|  | Employee Code | Cost Code | Split Percentage |
| **Characters &gt;** | 10 | 16 | 2 |

| Next topic<br><br>[Payment instructions data file format](/articles/ehr-user-guide/payment-instructions-data-file-format) |
| --- |

© 2023 Fusion5. All rights reserved.