|
|
 |
Employers must report member pension data to OPTrust on a biweekly basis
using the prescribed file layout described below. At a minimum, the data that
must be reported includes each member’s biweekly pension contributions and
salary information. Other member pension data may be reported either as they
change or on a predetermined timeline (i.e. every quarter), by arrangement with
OPTrust’s Data Management Group.
In order to update the member’s account, all pension data must be submitted
within 15 days of the extract creation
The data interface file is a standard fixed width, ASCII text file. Each file
can contain up to 9 transaction types for an individual member. The different
data (transaction) types along with a brief description are:
|
Transaction # |
Transaction Type |
Description |
|
Transaction 0 |
Header Information |
Contains file name and period information |
|
Transaction 1 |
Social Insurance Number Change Information |
Tracks all changes in member SINs |
|
Transaction 2 |
Client Basic Information |
Member basic information such name, date
of birth, and marital status. |
|
Transaction 3 |
Address Information |
Address and telephone information |
|
Transaction 4 |
Employment Information |
Employment and job related information
such as ministry code, start/end dates, employment type and standard hours. |
|
Transaction 5 |
Leave Of Absence Information |
Start/end date and type of leave of
absence |
|
Transaction 6 |
Salary Information |
All pensionable salary,
start and end dates |
|
Transaction 7 |
Payroll Contribution Information |
Biweekly payroll contributions, CPP
deductions and the actual Pensionable hours worked by the member |
|
Transaction 8 |
Termination Information |
End date for employment and job records |
|
Transaction 9 |
Trailer Information |
File control counts and dollar values |
|
Transaction A |
Transfer Information |
Transfer information for mandatory
transfers between the PSPB and the OPSEU Pension Plan |
There are two control records for each file:
- The Header is the first row of the employer data file. This record defines the
name of the file and the date information that is to be applied to all
contribution information contained within the file (i.e., Pay Period Start, Pay
Period End, and Pay Date).
- The Trailer is the last row on the data file. This record provides the control
counts and dollar amounts for all of the transactions on the file.
Each employer is assigned a unique employer code that identifies the
organization on the data files and on the Plan database.
The data submitted to OPTrust through the data interface must conform to
specific format and logic rules. OPTrust runs more than 130 different data tests
at both the file and record level before updating our member database. As a
result, not all data submitted will update the member database. In some cases,
such as a members address, the interface program will only accept the initial
address download and will ignore all subsequent address changes.
|
|
|
|
|
|
|
|
|
|
Note! For more information, including a detailed description of each data
element and the corresponding field characteristics and lengths, please see the
Data Interface File Formats in the Forms and Tools section.
|
|
|
|
|
|
|
|
|
|
|
Revised March 31, 2004
|
|
|
