BC Pension Location Export

The BC Pension Location Export process allows you to generate the location export file for submission to the BC Superannuation Branch. This export will allow you to refresh the employee's location code before the pension board generates the members benefit statements for your distribution. Suspended pension deductions are omitted from this process. Employees that are Terminated or On Leave may be included or excluded from this process, although all Terminated employees are reported with a location of 'T000' and On Leave and On Leave with Benefit employees are reported with a location of 'LEAV'.

This process is designed to allow you to include multiple payrolls or to define the same payroll multiple times when multiple Employee Group codes apply to a single payroll. This feature allows you to load information for multiple 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 location export file is called MPP_LOC_OrG###.EXP for municipal and the Teachers payroll export file is TPP_LOC_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(s) you would transfer the export file to your PC for submission to the BC Pension using the pension corporations transfer requirements.

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.

Process for Teachers or Municipal Pension

• Enter 'T' to generate an export for Teacher pension.
• Enter 'M' to generate an export for Municipal pension.

Enter one or multiple payroll ID's along with Employee Group and 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.

The IPAS Location/Sublocation document defines the Employee Groups as 04GENERL for MPP and 05GE10MO or 05GE12MO for TPP.

Enter the applicable Employee Group per payroll or payroll selection. When a whole payroll is all one Employee Group, 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 Employee Groups per payroll.

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.

Include Only Employees IN Global Pension Files

• Enter 'N' to report all selected employees.
• Enter 'Y' to only report the selected employees that are also in the Global Pension file for the selected pension year. This option allows you to omit employees that were not reported under the last pension report year and may not yet be setup on the pension system.

When Yes Omit Employees Not in the Global Pension File was Selected:

Enter Pension Reporting Year

• Enter the pension reporting year which will define the global pension file to be used for employee selection.

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.

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
• Employee Group
• Location and description
• Employee status, if applicable