Load lines into the employee experience worksheet
Sparkrock ERP 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 ERP 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 ERP 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 ERP to calculate employee experience.
When Sparkrock ERP loads the lines into the Employee Experience Worksheet page, Sparkrock ERP 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 ERP 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 positions, turn on Load Substitutes.
When Load Substitutes is turned on, Sparkrock ERP loads eligible substitute position assignment lines into the Employee Experience Worksheet page. Alternatively, when turned off, Sparkrock ERP does not load substitute position assignment lines. To learn more, go to Employee experience worksheet processing for substitute position 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:
