Classification codes and elements file formats

When uploading classification control codes and classification element codes in bulk to EmpowerHR, you use the option called Classification Codes Data Load from the Data Take-On Initiation screen.  Here are the file formats to use. 

What files do I need to prepare?

You need to create a tab-delimited (.txt) file for each type of required data.

Information

Remember to exclude column headings from the files.

Classification codes

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

Column >
A*
BCDE
F*
G

Classification Code
Classification Level
Classification Abbreviation
Classification Name
Classification Category Code
Effective Date
Classification Salary
Characters >
8
2
10
30
4
911 including decimal point


Column >
H
IJKL
M
N

%age to convert to hourly rate
Hourly Rate
Broad band Max salary
Broad band Min salary
Standard hours per period
Next classification to progress to 
Level of next classification
Characters >
11 including decimal point
11 including decimal point
11 including decimal point
11 including decimal point
11 including decimal point
82

This is not mandatory if salary is not entered.


This is mandatory if no level is entered.

This is mandatory if no level is entered.





Column >
O
PQRS
T
U
V

Maximum overtime group code
Max leave loading group code 
User Sort Code 1
User Sort Code 2
User Sort Code 3
User Sort Code 4
User Sort Code 5
User Sort Code 6
Characters >
4
4
4
4
4444


Classification element codes

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

Column >
A*
B*C*D*

Classification Code
Classification Level
Payment Code
%age to be applied to the normal pay rate
Characters >
8
2
4
11 including decimal point



Next topic

Super funds file format



© 2023 Fusion5. All rights reserved.