Load lines into the employee experience worksheet
Sparkrock 365 provides the capability to load employee experience data into the the Employee Experience Worksheet page. You can then review the experience calculations, and then create respective HR requests to credit the experience to employees.
To load lines into the employee experience worksheet
Choose
, enter employee experience worksheet, and then choose the related link.The Employee Experience Worksheet page opens.
On the action bar, choose Load Lines.
The Load Employee Experience Worksheet page opens.
In Calculation Method, choose one of the following options:
Elapsed Time: Looks at the active assignments that are between the one or more specified pay periods and reports the number of working days. Even though an employee may not have worked all the working days, Sparkrock 365 counts all working days that fall between the one or more specified pay periods.
Actual: Counts the actual number of days an employee has been paid for based on the compensation ledger entries between the one or more specified pay periods. For example, if an employee takes an unpaid week off, this week may be excluded from their experience calculation depending on how the cause of inactivity is set up.
When you choose Actual, depending on your environment setup, Sparkrock 365 may perform different calculations for Experience Years and Seniority Years for teachers. To learn more, see Experience years and seniority years calculations for teachers.
In Pay Periods, specify the one or more pay periods for which you want Sparkrock 365 to calculate employee experience.
When Sparkrock 365 loads the lines into the Employee Experience Worksheet page, Sparkrock 365 sets the Start Date for lines to be equal to the Starting Date of the first pay period that was specified. In a similar manner, Sparkrock 365 sets the End Date for lines to be equal to the Ending Date of the last pay period that was specified.
To clear previous lines in the spreadsheet, turn on Clear Batch.
To load lines for substitute teachers, turn on Load Substitutes.
When Load Substitutes is turned on, Sparkrock 365 loads eligible substitute teacher assignment lines into the Employee Experience Worksheet page. Alternatively, when turned off, Sparkrock 365 does not load substitute teacher assignment lines. To learn more, go to Employee experience worksheet processing for substitute teacher assignments.
To limit the number of rows in the worksheet, specify filters as required.
Choose OK.
Lines are loaded into the worksheet.
Related information
Feedback
To send feedback about this page, select the following link: