Bulk upload school increment & formula earnings data

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.

Information

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.   

Information Remember to exclude column headings, and save the file as a tab-delimited (.txt) file.
Column >
A*
B*CDE
F
GH

Employee Code
Employee NumberIncrement Date At Take-OnClassification Code At Take-OnClassification Level At Take-OnDate of Take-OnWorking Days At Take-OnCasual Days At Take-On
Characters >
10
2
8
2
88



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:

  • LWOP days
  • extra days taken on LSL at less than 100%



InformationWhile 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 >
IJ
KLMN


Gross pay dollars
Dollars paid for non term daysCasual pay dollarsLWOP days since start of school yearTerm 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:

  • LWOP > 20 days
  • parental leave > 20 days

Non-term days elapsed since start of school year (or employee start date)

Exclude:

  • LWOP > 20 days
  • parental leave > 20 days



Column >
O
PQ

Normal leave affecting Christmas pay has been taken
FTE change
Acted more than 10 days
Characters >
11
1

Enter:

  • y - if employee has taken normal leave (that affects Christmas pay) since start of school year, or else
  • n

Enter:

  • y - if employee has changed FTE% since start of school year, or else
  • n

Enter:

  • y if employee has acted in promotional position for more than a 10-day period since start of school year, or else
  • n



Next topic

Create your own reports


© 2023 Fusion5. All rights reserved.