The SASKATCHEWAN MEPP (Municipal Employee Pension Plan) Merge Process allows you to merge the MEPP report results from multiple pensions or multiple payrolls into one report for a single submission to MEPP. This merge process will amalgamate multiple pension records for a single employee, using the potential hours as defined on the first or main payroll defined. This merge should always be run from the main or Support payroll, merging in the Casuals. Adjustments and Retro records are not compressed.
The process includes the automatic generation of 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 merged export file is named MMEPP_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.
Enter Main Payroll ID Code
-
Enter the payroll ID code for the main payroll. The main payroll should always by the existing payroll. The initial default is the payroll ID for the payroll you are currently in. Use look-up for a list of valid payroll ID codes.
Enter Pension Deduction Code
-
Enter the main MEPP deduction code for this payroll id code. This pension deduction code was defined as the main pension deduction during the pension report creation.
Enter the Ending Reporting Period
-
Enter the last pay period of the reporting period. This payroll calendar defines the report month and year.
The Next Two Prompts Repeat Allowing Up To 10 Pension Files to be Merged:
Enter Payroll ID Code to Merge
-
Enter the payroll ID code to be merged with the main payroll defined. Use look-up for a list of valid payroll ID codes.
Enter Pension Deduction Code
-
Enter the main MEPP deduction code for this payroll id code. This pension deduction code was defined as the main pension deduction during the pension report creation.
Sort by Employee Number or Employee Name
-
Enter 'N' to report in employee name order.
-
Enter 'E' to report in employee number order
The following is listed on the MEPP report:
-
Employee SIN
-
Employee number
-
Employee name
-
Contribution type, default N.
-
Begin and End Date
-
Service type, default NP
-
Employee pensionable earnings
-
Employee and employer MEPP deduction amounts
-
Hours paid
-
Total employees reported
-
Total pensionable salary, employee MEPP amount, employer MEPP amount and hours paid
The Retroactive report, per pay period lists the following:
-
Employee SIN
-
Employee name
-
Employee retro earnings
-
Employee contribution
-
Employer retro MEPP deduction amounts
-
Total employees reported
-
Total retro earnings, employee and employer retro MEPP
The ASCII comma delimited electronic export file SRB$OPSWRK:MMEPP_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:
|
Item |
Format |
|
Social Insurance Number |
9 Numbers |
|
Employee Number |
9 Characters |
|
Employee's Last Name |
40 Characters |
|
Employee's First Name |
40 Characters |
|
Contribution Type Valid Values:
|
1 Character |
|
Contribution Begin date |
Date DD-MON-YYYY |
|
Contribution End date |
Date DD-MON-YYYY |
|
Service Type Valid Values:
|
3 Characters |
|
Employer's Contribution |
9 Characters (999999.99) |
|
Employee's Contribution |
9 Characters (999999.99) |
|
Employee's Actual Hours worked |
7 Characters (9999.99) |