Saskatchewan MEPP Report

The Saskatchewan MEPP (Municipal Employee Pension Plan) Report lists the employee's pensionable earnings, MEPP deduction values for a range of pay periods. This report includes the employee's hours paid. The MEPP report generates a pension work file containing all the regular pension and when applicable, retro pension information. The pension values may then be adjusted through the MEPP Adjustments and the changed values re-reported through this option. The process includes the option to generate the electronic comma separated export file for submission to MEPP'S Employer Remittance System (ERS). The MEPP board requires submission of an Excel formatted CSV file. Only the Excel program can generate an Excel format file. The CSV file created from this process must be opened in Excel and saved to generate an actual Excel file for submission to the board. The export file is named MEPP_YYYYMMDD.CSV and is generated at the location SRB$OPSWRK for the current payroll. This export file is available for emailing under E = Payroll Email File Process on the main menu and D = Payroll Download File Process.

The starting pay period date taken from the Starting Pay period defines the default for the Contribution Begin Date, while the ending pay period date taken from the Ending Pay period defined the default for the Contribution End Date for each employee based on the employee's pay cycle code from the master function line. The employee's hire date (current or original, whichever is newer) will replace the default Begin Date when the hire date is newer. The employee's Termination date, when applicable, will replace the default End Date when the Termination date is later than the default End Date.

The hours paid are the accumulated hours for the range of pay periods defined with the option to excluded specific pay code from this accumulation, such as overtime. The pay code setting Hours Pensionable can be used to affect the hours paid total.

When an employee's master function line pay cycle indicates the employee is Daily, the unit of time from the salary grid and history is converted based on the number of hours per day defined on the pay cycle database. For history pay codes the override EI hours per days is also used.

The report includes the option to report retroactive pay. When retro was paid in the pay period range defined for this report, define the pay codes that represent the retro earnings as well as the range of pay periods the retro was calculated for. The main report pensionable salary and combined MEPP contribution are reported reduced by the retro amounts.

This process will total the employee's retro earnings based on the retro pay codes entered, for the first set of pay periods defined. The total employee's MEPP deduction amount for those retro earnings is calculated from the percentage defined on the MEPP deduction code database. The employer portion of MEPP is calculated from the employee's amount using the employer rate from the MEPP deduction.

The retro earnings, employee and employer MEPP retroactive deduction amounts are reported prorated over the range of retro pay periods with a separate report generated for each retro pay period. The retro reporting does not include the percentage of full time, potential hours nor hours paid.

Prorating of retro values is accomplished by accumulating the employee's MEPP deduction amount per retro pay period. The retro earnings and retro MEPP deduction amount are then distributed over these pay periods based on the percentage taken for each retro pay period.

Note: In 2019, the new changes do not require the Salary to be reported to MEPP in the CSV file although it will still appear on the report generated. Also, the MEPP contributions have been split into the respective Employer and Employee portions.

Create or Report Pension Record File

A separate pension file is created based on the pension deduction code entered to allow multiple pension deductions to be reported separately. You can also generate the report for multiple pension deductions combined.

• Enter 'C' to produce a new or fresh pension report/file during the report run. This option would be used if modification of the pension records has not been done or is not necessary.

• Enter 'R' to produce this report taking the values from an existing pension file. You would 'R'eport the pension file when this month's pension information has already been created and adjusted through the MEPP Adjustments.

Enter Main Pension Deduction Code

• Enter the main MEPP deduction code to be reported. The pension file will be named based on this pension deduction code entered. The pension file is named SRB$OPSDAT0:PENS##.DAT, where ## is the pension deduction code.

Enter Additional Pension Deduction Codes

• Enter one or up to 5 addition pension deduction codes to be included on the pension report and within the pension file.

Enter the Starting Pay Period to Report

• Enter the first pay period for a range of periods to be reported. The starting pay date from this payroll calendar will determine the default Contribution Begin Date.

Enter the Ending Pay Period to Report 

• Enter the last pay period for a range of periods to be reported. The ending pay date from this payroll calendar will determine the default Contribution End Date.

Sort by Employee Number or Employee Name

• Enter 'N' to report in employee name order.

• Enter 'E' to report in employee number order.

When Create pension file has been entered:

Pay Codes to BE Exclude D from Hours Paid

• Enter pay codes one at a time. These pay codes will be excluded from the accumulation of hours to be reported for Hours Paid.

Report All or Selected Employees

Report Employees Terminated / On Leave / Both

Retro Pay Codes to BE Reported

Accept the default, when no retro is to be reported. Enter one or more pay codes that represent the retroactive earnings paid for the range of pay periods previously defined for this report.

When Retroactive pay codes have been entered:

Enter Retro Starting Pay Period 

• Enter the starting pay period which represents the range of pay periods the retro was calculated for.

Enter Retro Ending Pay Period 

• Enter the ending pay period which represents the range of pay periods the retro was calculated for.

Include Generation of ERS Export File

• Enter 'Y' to generate the electronic export file for submission to MEPP through the Employer Remittance System (ERS). See below for file format details.

• Enter 'N' when no electronic export file is required.

The following is listed on the MEPP report:

• Employee SIN

• Employee name + (Employee number)

• Contribution type, default N.

• Begin and End Date

• Service type, default NP

• Employee pensionable earnings

• Employee MEPP deduction amount

• Employer MEPP deduction amount

• Hours paid

• Total employees reported

• Total pensionable salary, total employee MEPP, total employer MEPP and hours paid

The Retroactive report, per pay period lists the following:

• Employee SIN

• Employee name + (Employee Number) 

• Employee retro earnings

• Employee and employer retro MEPP deduction amounts

• Total employees reported

• Total retro earnings, retro MEPP

The ASCII comma delimited electronic export file SRB$OPSWRK:MEPP_YYYYMMDD.CSV file contains the following, where YYYYMMDD is the current date, and SRB$OPSWRK is the logical which pointed to the work directory for the current payroll: