Administering Canada Payroll Savings Programs

Page Name

Definition Name

Usage

Create General Deductions Page

GENL_DED_DATA

(CAN) Enroll employees in the CPS program, specify the calculation method, and set up each employee's contributions.

See Setting Up Employee General Deductions.

Canada Payroll Savings File Page

RUNCTL_PAY132CN

(CAN) Run the PAY132CN report to create a CPS electronic data transmission file and a transmission summary report for your reference.

The system produces the transmission file in accordance with the format that is provided by the Bank of Canada.

Payroll for North America provides functionality to support the Canada Payroll Savings program and helps you effectively manage the activities as a participating organization.

After the CPS plan is set up, the employee specifies a contribution amount, the employer automatically deducts that amount from the employee's paycheque on a regular basis, and the contribution details are transmitted electronically to the Bank of Canada for credit to the employee's savings plan account.

Canada Payroll Savings Transmittal File and Report

The Payroll Savings Create File Structured Query Report (SQR) Report process (PAY132CN) produces the CPS transmittal file that includes detailed employee contribution information (by pay run ID) for transmission to the Bank of Canada. At the same time, the system produces a transmission summary report for your reference. The detailed employee deduction information to support this summary report is available on the corresponding Deduction Register (SQR program PAY001CN).

Create this file once per pay period, and only after the corresponding Pay Confirmation COBOL SQL process (PSPCNFRM) is complete. The system automatically maintains a record of the pay run IDs that have been processed to prevent duplication of the file.

The system also uses the Last CPS Transmission ID # (last Canada Payroll Savings transmission ID number) field in the Installation table to ensure that each transmission ID number that it generates is unique.

Note: See the Canada Payroll Savings Program Technical Specifications booklet for further information regarding the technical aspects of creating or transmitting files to the Bank of Canada.

Canada Payroll Savings Transmittal File Output Location

The Payroll Savings Create File process creates the CPS transmittal file in the PeopleSoft report output directory. The following list identifies the naming convention of the output files for each platform:

  • DB2/AS400: File Name is CPSCN(D0001)

  • MVS: File Name is CPSC0001

  • Others: File Name is CPS_0001

    Here, 0001 is a uniquely generated CPS transmission ID number.

Before you can administer employees' contribution amounts, you must perform the following setup steps:

  1. Define a CPS organization ID.

  2. Specify CPS campaign information.

  3. Define CPS deductions.

(CAN) Use the Canada Payroll Savings File page (RUNCTL_PAY132CN) to run the PAY132CN report to create a CPS electronic data transmission file and a transmission summary report for your reference.

The system produces the transmission file in accordance with the format that is provided by the Bank of Canada.

Navigation:

Payroll for North America > Payroll Processing CAN > Pay Period Reports > Canada Payroll Savings File > Canada Payroll Savings File

Field or Control

Description

Pay Run ID

Enter the pay run ID for the data that you're transmitting.

Reference ID

Enter optional reference information that you require to recognize the transmission.