Calculate or Add Employee Experience

Sparkrock 365 provides the capability to calculate or add employee experience, and then credit the experience to employees.

Employee Experience Worksheet

To periodically perform a mass calculation of employee experience, and then create respective HR requests to credit the experience to employees, you can use the Employee Experience Worksheet page.

Load lines into the Employee Experience Worksheet

Instead of manually entering information into the worksheet, you can load lines to populate the worksheet.

To load lines into the Employee Experience Worksheet

1. Choose , enter employee experience worksheet, and then choose the related link.

   The Employee Experience Worksheet page opens.

2. On the action bar, choose Load Lines.

   The Load Employee Experience Worksheet page opens.

3. In Calculation Method, choose one of the following options:

   • Elapsed Time: Looks at the active assignments that are between the start and end date and reports the number of working days. Even though an employee may not have worked all the working days, all working days that fall between the start and end date are counted.

   • Actual: Counts the actual number of days an employee has been paid for based on the compensation ledger entries between the specified start and end date. 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.

4. In Start Date, specify the start date of the period for which you want to calculate experience.

5. In End Date, specify the end date of the period for which you want to calculate experience.

6. To clear previous lines in the spreadsheet, turn on Clear Batch

7. To limit the number of rows in the worksheet, specify filters as required.

8. Choose OK.

   Lines are loaded into the worksheet.

Edit values in the Employee Experience Worksheet

Some fields on the Employee Experience Worksheet page are editable, for example, Days Worked, Experience FTE, HR Position Days/Year, and Seniority Years. Some fields cannot be changed, for example, Seniority Days. To change the value of a calculated field, you must update the respective input field for the calculation, for example, the value for Seniority Days changes when you update the Experience FTE field.

Delete records from the Employee Experience Worksheet

If required, you can delete records from the Employee Experience Worksheet page.

To delete records from the Employee Experience Worksheet

1. Choose , enter employee experience worksheet, and then choose the related link.

   The Employee Experience Worksheet page opens.

2. Select the one or more records that you want to delete, and then on the action bar, choose Manage > Delete.

   A dialog box appears that displays the following text:

   Go ahead and delete?

3. Choose Yes.

Add employee experience manually in the Employee Experience Worksheet

If required, you can add employee experience manually. For example, you may want to add employee experience for an employee who worked someplace else before joining your organization.

To add employee experience manually

1. Choose , enter employee experience worksheet, and then choose the related link.

   The Employee Experience Worksheet page opens.

2. On an empty line, specify values for fields as required.

Post employee experience

After you have reviewed and validated the data in the worksheet, you can post the lines to the employee experience ledger. Posting the lines credits the experience to employees, after which the experience can be used for progression and seniority reporting.

Note

Note:
You cannot post lines that have a blank value for Seniority Group Code.

To post experience worksheet lines to the employee experience ledger

1. Choose , enter employee experience worksheet, and then choose the related link.

   The Employee Experience Worksheet page opens.

2. On the action bar, choose Post.

   A dialog box appears that displays the following question:

   Do you want to post Employee Experience Worksheet Lines?

3. Choose Yes.

   Posted lines are deleted from the Employee Experience Worksheet page.

Add employee experience directly on an HR request

Employee experience can be added directly on an HR request.

To add employee experience directly on an HR request

1. Choose , enter hr requests, and then choose the related link.

   The HR Requests page opens.

2. Select the HR request to which you want to add employee experience, and then on the action bar, choose Home > Details.

   The respective HR request details page opens.

3. On the Employee Experience FastTab, perform the following steps:

   1. In Seniority Group Code, specify a code that represents the seniority group of this employee.
   2. In Start Date, specify the start date of the experience.
   3. In End Date, specify the end date of the experience.
   4. In Days Worked, specify the number of days worked.
   5. In Experience FTE, specify the FTE value.
   6. In HR Position Days/Year, specify the number of days per year for this position.
      After you specify a value in HR Position Days/Year, Sparkrock 365 calculates and automatically populates values for Experience Days, Experience Years, Seniority Days, and Seniority Years.

See also

Set Up Seniority Types
Set Up Seniority Groups
View Employee Experience
Regular Progression
Process Salary Progression
Calculate Salary

Feedback

To send feedback about this page, select the following link:

feedback-product-docs@sparkrock.com