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

Remember to exclude column headings from the files.

Here's the format to use.  An asterisk (*) shows which data is mandatory. 

Column >
A*
BCDE
F
G

Code for:

Org Level, or

Division, or

Branch, or

Section

Description

Abbreviation

Gene Flag

Manager Position

Admin Position

Contact Name

Characters >

4

40

10

1

10

10

40


Column >
H
IJKL

Contact Address Line 1
Contact Address Line 2
Contact Suburb
Contact State
Contact Postcode

Characters >

30

30

​30

3

10


Column >
M
NOPQRS

Contact Country
Postal Address Line 1
Postal Address Line 2
Postal Suburb
Postal State 
Postal Postcode
Postal Country

Characters >

20

30

30

30

3

10

20


Column >
T
U
V
WXY
Z

Phone Number
Fax Number
Email Address
Sort Code 1
Sort Code 2
Sort Code 3
Sort Code 4

Characters >

20

20

50

4

4

4

4


Column >
AA
AB
AC
AD

Sort Code 5
Sort Code 6
Information
Website

Characters >

4

4

1200

200




Org Levels 1 & 2 only

Org Levels 1 & 2 only




Next topic

Work patterns file format



© 2023 Fusion5. All rights reserved.