The BC MPP Bargaining Unit Export process allows you to generate the bargaining unit export file for submission to the BC Superannuation Branch. This process is designed to allow you to include multiple payrolls or to define the same payroll multiple times when multiple bargaining units apply to a single payroll. This feature allows you to load information for multiple municipal payrolls together or create a separate submission per payroll. When multiple payrolls are combined, each employee will only be reported once.
Note: If you are submitting multiple exports, a different submission date per export must be used. At this time, it is the pension corporation's requirement that you cannot submit multiple export files with the same submission date.
These export files meet the IPAS fixed field format requirements, as defined by BC Pension. The employee's address and bargaining unit information must be reported separately. The bargaining unit export file is MPP_B_OrG###.EXP, where ### is your pension employer ID number.
The export file is created where the logical SRB$OPSWRK is pointed to. The exact export file name and location is included on the header of the report. After generating the applicable export file, you would transfer the export file to your PC for submission to the BC Pension using the pension corporations transfer requirements.
Please refer to Instructions for Reporting of Bargaining Units Electronically in IPAS format, supplied by the BC Pension Corporation.
This process includes the option to maintain multiple sets of stored prompts.
Name the prompt sets by defining a title up to 10 characters, with a 30-character description.
On the first prompt click the Report Defaults icon to select an existing set of prompt values. You can delete prompt sets or change the description from the Report Default icon.
Enter Pension Employer ID Number
-
Enter your employer number as specified in Section 1 of the Pension Plan Instructions Manual supplied by the Superannuation Commission. This number will be used on the report header and as part of the export file name.
Reporting PER Payroll ID
-
Enter one or multiple payroll ID's along with the pension deductions per payroll for employee selection. Only employees with at least one of the pension deductions on the deduction master will be included.
-
Enter the applicable Bargaining Unit per payroll or payroll selection. When a whole payroll is all one Bargaining Unit, the Additional Optional Selection would not be required. The Additional Optional Selection allows you to define additional selections based on Pay Code, Employee Type Code, Pay Cycle or Deduction code base on the employee's master function line. With additional selection by function line you can define multiple Bargaining Units per payroll.
The BC Pension Corporation has included examples of how to define the Bargaining Unit on the last few pages of the Employer Instruction manual, section 7, reports to the corporation.
Report Employees Terminated / On Leave / Both
Exclude Employees Terminated Prior To
-
Enter the date that prior terminated employees are to be excluded from the export process.
-
Enter File Submission Date
-
Enter the file submission date. The export header requires the submission date plus 5 days. When submitting multiple exports on the same day, the pension corporation requires a different submission date.
By default, the current date is supplied.
The report lists the following:
-
Employee number
-
Payroll Id
-
Employee SIN
-
Employee Last name
-
Bargaining Unit