All Rights Reserved | Sparkrock © 2025

Search Results for

    Experience years and seniority years calculations for teachers

    When you specify Actual for the Calculation Method while loading lines, depending on your environment setup, Sparkrock may perform different calculations for Experience Years and Seniority Years.

    Experience years calculations

    When the following conditions exist, Sparkrock ERP performs a different calculation to determine the value for Experience Years:

    • The value of Calculation Method is Actual.
    • On the respective HR Position Class page, on the British Columbia Pension FastTab, the Pension Position Class is Teacher. To determine the HR position class, Sparkrock ERP uses the HR position class that is assigned on the HR position that is associated with an HR employee assignment.

    The calculation is as follows:

    Experience Years = The FTE value on the HR employee assignment / Employment Duration Type value on the HR position class

    For example, if the FTE value is 1.00 and the Employment Duration Type value is 10 Months, Sparkrock ERP performs the following calculation:

    Experience Years = 1.00 / 10 = 0.1 years

    After completing the calculation above, Sparkrock ERP performs the following logic:

    • If the assignment calculation start date is greater than the 15th of any month, Sparkrock ERP sets Experience Years to 0.00.
    • If the assignment calculation end date is less than the 15th of any month, Sparkrock ERP sets Experience Years to 0.00.

    Seniority years calculations

    When the following conditions exist, Sparkrock ERP performs a different calculation to determine the value for Seniority Years:

    • The value of Calculation Method is Actual.
    • On the respective HR Position Class page, on the British Columbia Pension FastTab, the Pension Position Class is Teacher. To determine the HR position class, Sparkrock ERP uses the HR position class that is assigned on the HR position that is associated with an HR employee assignment.
    • On the HR employee assignment, the value of HR Position Rank is equal to 1 or 2, Sparkrock ERP uses the following calculation to determine the value for Seniority Years.

    The calculation is as follows:

    Seniority Years = The FTE value on the HR employee assignment / Employment Duration Type value on the HR position class

    For example, if the FTE value is 1.00 and the Employment Duration Type value is 10 Months, Sparkrock ERP performs the following calculation:

    Seniority Years = 1.00 / 10 = 0.1 years

    After completing the calculation above, Sparkrock ERP performs the following logic:

    • If the assignment calculation start date is greater than the 15th of any month, Sparkrock ERP sets Seniority Years to 0.00.
    • If the assignment calculation end date is less than the 15th of any month, Sparkrock ERP sets Seniority Years to 0.00.

    Related information

    Employee experience worksheet
    Employee experience worksheet processing for substitute position assignments

    Feedback

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

    feedback-product-docs@sparkrock.com

    All Rights Reserved | Sparkrock © 2025