The BC Global Pension Plan Report allows you the reporting and extraction of the merged Global pension information for submission to the BC Pension Corporation. All Teachers and Municipal pension information can be merged for one large Teacher pension submission and one large Municipal pension submission. Use of this report requires the completion of the global pension directory options in the user specific parameters profile (field 38) and the use of the global reporting option in the pension plan report for BC. Once pension records have been loaded into the Global pension file, modification to global pension records can be done through BC Global Pension Report Changes. The Payroll Numbers per Payroll Location Changes must be defined to use the Global Pension reporting.
All BC Global Pension Report values can be adjusted as necessary through the BC Global Pension Report Changes.
The extract file for submission to BC Pension Corporation is in IPAS format and the fileSRB$OPSWRK:cPP_GLPEN.Eyy, where c is T for Teach or M for Municipal, and yy is the last two digits of the pension year. When creation of the extract file is selected, the full file name and location is included in the header of the report.
Please refer to Instructions for Employer Data Reporting Requirements Reporting of Service Event Records 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 Reporting Year
-
Enter the year the pension report was generated for. This value is also used in the report heading and electronic file information. All pension files will be created using the pension year in the file name, allowing for unique files per year.
Pension Reporting for Teacher or Municipal
-
Enter 'T' if this report is for a teacher's pension, plan id 05TPP.
-
Enter 'M' if this report is for a municipal pension, plan id 04MPP.
This prompt determines some of the extract header values such as pension plan id, valid values of Employee Group Code and the T/M is used as part of the extract file name.
Create the Global Pension Extract File
-
Enter 'Y' to create the electronic extract file to be submitted to the BC Pension Corporation. The IPAS format file TPP_GLPEN.Eyy for teachers and MPP_GLPEN.Eyy for municipal, where yy is the last two digits of the pension year, would then be transferred to the pension corporation. The extract file is created in the directory pointed to by the current payrolls SRB$OPSWRK: logical. When creation of the extract file is selected, the full file name and location is included in the header of the report.
Please refer to the Pension Corporation for their instructions on Electronic Submission Methods.
Enter the Reporting Period Start Date
-
Enter the reporting start date that will be used as the default Effective Start Date on the report. The report will omit displaying the employee's start date when the start date matches this default date. The employee's start date is included on the Service Event record for electronic submissions.
Enter the Reporting Period End Date
-
Enter the reporting end date that will be used as the default Effective End Date on the report. The report will omit displaying the employee's end date when the end date matches this default date. The employee's end date is included on the Service Event record for electronic submissions.
Enter Pension Employer Number
-
Enter your employer organization id number as a 5-digit number. This number will be used on the report header and in the electronic file format information when the electronic file option was selected.
Sort by Employee SIN or Employee Name
-
Enter 'N' to produce the report in employee name order.
-
Enter 'S' to produce the report in employee SIN order.
Double Space Report
-
Enter 'N' to produce the report with the employees reported single spaced.
-
Enter 'Y' to produce the report with the employees reported with a blank line between each employee. The Pension Corporation prefers a double-spaced annual report be submitted when a pension electronic file is not submitted.
Include Employee's Payroll Number
-
Enter 'N' when the employee's payroll number should not be included on the report.
-
Enter 'Y' to have the employee's payroll number(s) printed on the report.
The report header lists the following:
-
Location and exact name of extract file for electronic submission
-
Employer name (from Employer Constant Database)
-
Employer Organization id
-
Pension year
-
Plan id
-
Reporting Start and End dates
The report lists the following:
|
Employee's number, SIN and Last name |
|
|
Employee Group |
04GENERL for MPP and 05GE10MO or 05GE12MO for TPP. |
|
Event |
Event service type of RG regular, RT retro or RH rehab |
|
Contr Serv |
The number of unique months count during the history collection, based on the pay ending date of the history record |
|
Pen Service |
Total pension credits for range of history periods selected |
|
Contributions |
Employee's pension deduction contribution |
|
Pensionable Salary |
Total eligible earnings for the employee's regular pension, total retro or total rehab earnings |
|
Employee Special |
Employee deduction amount for special agreement pension |
|
Employer Special |
Employer deduction amount for special agreement pension |
|
Start Date |
Employee's Effective Start date – report is blank when date is the same as default Reporting Start Date |
|
End Date |
Employee's Effective End date – report is blank when date is the same as default Reporting End Date |
|
Payroll # |
Payroll number(s) when applicable |
|
Page totals and grand totals are also supplied |
|
Secondary Report:
An additional section at the end of the report lists a cross reference between employees and their source payroll. This report provides information regarding employees whose information comes from more than one payroll or with multiple global pension records.
-
Employee Number
-
Employee Last Name
-
Payroll Number
-
Payroll Id
-
Contributor Months per payroll