Load Lines into the BC Pension Report Worksheet
School boards can load the BC pension data that is stored in Sparkrock 365 into the BC pension report worksheet, and then view the data. From the worksheet, school boards can verify the data, and then print reports. Also, school boards can use the worksheet as a register for audit purposes.
To load lines into the BC pension report worksheet
Choose
, enter bc pension report worksheet, and then choose the related link.The BC Pension Report Worksheet page opens.
On the action bar, choose Load Lines.
If there is existing data on the BC Pension Report Worksheet page, a dialog box appears that displays the following text:
Already existing data from worksheet will be deleted. Do you want to continue?
To continue, choose Yes.
The BC Pension Reporting Load Lines page opens.
In Pay Periods, specify the one or more HR pay cycle periods for which you want data to appear in the worksheet.
In BC Pension Plan, specify MPP - Municipal Pension Plan or TPP - Teachers Pension Plan.
(Optional) To only show pension data in the worksheet for a specific employee, in Employee No., specify the number that represents the employee.
Choose OK.
Municipal Pension Plan (MPP) records
When determining which records to load into the BC Pension Report Worksheet page for Municipal Pension Plan (MPP), Sparkrock 365 uses the following criteria:
- Identifies employees with HR assignments that have HR an position where the respective HR position class on the BC Pension FastTab, has in Pension Employee Group, a value of 04GENERL.
- The Assignment Start Date and Assignment End Date match or overlap the values that you specify for Pay Periods on the BC Pension Reporting Load Lines page.
Sparkrock 365 groups worksheet records and calculations by HR Emp. Assignment Entry No.. For example, when there are 2 HR employee assignments for an employee that fall within the pay periods, Sparkrock 365 displays 2 lines in the worksheet with separate calculations for each assignment.
Teachers Pension Plan (TPP) records
When determining which records to load into the BC Pension Report Worksheet page for Teachers Pension Plan (MPP), Sparkrock 365 uses the following criteria:
- Identifies employees with HR assignments that have HR an position where the respective HR position class on the BC Pension FastTab, has in Pension Employee Group, a value of 05GE10MO or 05GE12MO.
- The Assignment Start Date and Assignment End Date match or overlap the values that you specify for Pay Periods on the BC Pension Reporting Load Lines page.
Sparkrock 365 groups worksheet records and calculations by HR Emp. Assignment Entry No.. For example, when there are 2 HR employee assignments for an employee that fall within the pay periods, Sparkrock 365 displays 2 lines in the worksheet with separate calculations for each assignment.
Retro pay records
On the BC Pension Reporting Load Lines page, when you choose MPP - Municipal Pension Plan, Sparkrock 365 includes lines for retro pay in the worksheet where all the following criteria is met:
The employee has an assignment with an HR position that has an HR position class where the value for Pension Employee Group is 04GENERL.
The employee has received retro pay during the Pay Periods that were specified on the BC Pension Reporting Load Lines page.
Alternatively, on the BC Pension Reporting Load Lines page, when you choose TPP - Teachers Pension Plan, Sparkrock 365 includes lines for retro pay in the worksheet where all the following criteria is met:
The employee has an assignment with an HR position that has an HR position class where the value for Pension Employee Group is 05GE10MO or 05GE12MO.
The employee has received retro pay during the Pay Periods that were specified on the BC Pension Reporting Load Lines page.
To determine the retro pay payroll ledger entries to use in the worksheet calculations, Sparkrock 365 uses the one or more values that are set up on the Advanced HR Setup page, on the BC Pension Setup FastTab, in the Retro Pay Codes field.
Rehab payment records
On the BC Pension Reporting Load Lines page, when you choose MPP - Municipal Pension Plan, Sparkrock 365 includes lines for rehab payments in the worksheet where all the following criteria is met:
The employee has an assignment with an HR position that has an HR position class where the value for Pension Employee Group is 04GENERL.
The employee has received rehab payments during the Pay Periods that were specified on the BC Pension Reporting Load Lines page.
Alternatively, on the BC Pension Reporting Load Lines page, when you choose TPP - Teachers Pension Plan, Sparkrock 365 includes lines for rehab payments in the worksheet where all the following criteria is met:
The employee has an assignment with an HR position that has an HR position class where the value for Pension Employee Group is 05GE10MO or 05GE12MO.
The employee has received rehab payments during the Pay Periods that were specified on the BC Pension Reporting Load Lines page.
To determine the rehab payment payroll ledger entries to use in the worksheet calculations, Sparkrock 365 uses the one or more values that are set up on the Advanced HR Setup page, on the BC Pension Setup FastTab, in the Rehab Pay Codes field.
See also
Feedback
To send feedback about this page, select the following link: