Where your organisation needs to take on both increment data and term/non term earnings data in bulk, your Fusion5 consultant organises this for you. It involves collecting the necessary data and running scripts to complete the upload.
Fusion5 provides a spreadsheet template for you to complete with the necessary data and this topic shows how to complete the spreadsheet.
![]() |
If you need further assistance, contact us by logging an iHelp request. |
Here's the format to use. An asterisk (*) shows which data is mandatory.
|
Remember to exclude column headings, and save the file as a tab-delimited (.txt) file. |
| Column > | A* | B* | C | D | E | F | G | H |
| Employee Code | Employee Number | Increment Date At Take-On | Classification Code At Take-On | Classification Level At Take-On | Date of Take-On | Working Days At Take-On | Casual Days At Take-On | |
| Characters > | 10 | 2 | 8 | 2 | 8 | 8 | ||
0 = single employment 1 = second employment ...and so on | Format: ddmmyy ddMmmyy ddmmccyy ddMmmccyy | Format: ddmmyy ddMmmyy ddmmccyy ddMmmccyy |
Part time employees - provide FTE days Exclude:
|
![]() | While columns C to H are not mandatory, we recommend at least one of these columns contains data. If they are all blank, the data will not upload into the school take-on table. |
| Column > | I | J | K | L | M | N |
|---|---|---|---|---|---|---|
| Gross pay dollars | Dollars paid for non term days | Casual pay dollars | LWOP days since start of school year | Term days balance since start of school year | Non term days balance since start of school year | |
| Characters > | 8 | 8 | 8 | 8 | 8 | 8 |
| Gross pay accumulated since start of school year | Non-term pay accumulated since start of school year | Casual pay accumulated since start of school year | Where an employee has a break in service before employment position start date is uploaded to EmpowerHR, include break in service term days in this value | Work days elapsed since start of school year (or employee start date) Exclude:
| Non-term days elapsed since start of school year (or employee start date) Exclude:
|
| Column > | O | P | Q |
|---|---|---|---|
| Normal leave affecting Christmas pay has been taken | FTE change | Acted more than 10 days | |
| Characters > | 1 | 1 | 1 |
Enter:
| Enter:
| Enter:
|
© 2023 Fusion5. All rights reserved.
