Generally, when doing a bulk take-on of new employees, you first load your data file using Employee personal data load.
The Employee personal data 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 and 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.
![]() |
Remember to exclude column headings from the file. |
Here's the format to use. An asterisk (*) shows which data is mandatory.
| Column > | 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 > | 10 | 8 | 40 | 30 | 20 | 9 | 1 | 4 | 9 | 4 | 1 |
| Must be zero filled to match the setting under Installation Constants. | Format: ddmmyy ddMmmyy ddmmccyy ddMmmccyy | Must be e for all employees | Format: ddmmyy ddMmmyy ddmmccyy ddMmmccyy |
| Column > | 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 > | 4 | 4 | 1 | 4 | 10 | 4 | 35 | ||||
| Format: ddmmyy ddMmmyy ddmmccyy ddMmmccyy | Format: ddmmyy ddMmmyy ddmmccyy ddMmmccyy | Format: ddmmyy ddMmmyy ddmmccyy ddMmmccyy | Format: ddmmyy ddMmmyy ddmmccyy ddMmmccyy |
| Column > | 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 > | 40 | 30 | 30 | 30 | 10 | 20 | 10 | 20 | 20 | 20 | |
| Format: ddmmyy ddMmmyy ddmmccyy ddMmmccyy | Required for NZ, otherwise n | Required for NZ, otherwise n |
| Column > | 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 > | 64 | 20 | 30 | 30 | 30 | 10 | 20 | 10 | 20 | 64 | 30 |
| Required for NZ, otherwise n |
| Column > | 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 > | 30 | 30 | 30 | 10 | 10 | 20 | 4 | 20 | 20 | 30 | 4 |
| Column > | 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 > | 20 | 20 | 20 | 30 | 30 | 30 | 10 | 10 | 30 | 30 | 30 |
| Column > | 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 > | 30 | 10 | 15 | 30 | 4 | 20 | 20 | 20 | 30 | 30 | 30 |
| Column > | 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 > | 10 | 10 | 1 | 30 | 4 | 50 | 50 | 200 |
| Enter y or n. Will default to n. |
© 2023 Fusion5. All rights reserved.
