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.
|
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* | B | C | D | E | F* | G |
|---|---|---|---|---|---|---|---|
| Classification Code | Classification Level | Classification Abbreviation | Classification Name | Classification Category Code | Effective Date | Classification Salary | |
| Characters > | 8 | 2 | 10 | 30 | 4 | 9 | 11 including decimal point |
| Column > | H | I | J | K | L | 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 | 8 | 2 |
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 | P | Q | R | S | 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 | 4 | 4 | 4 | 4 |
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 |
© 2023 Fusion5. All rights reserved.