Column Title
|
Name
|
Description
|
Mandatory Field
|
Length
|
Format
|
NAS
|
SIN
|
Social Insurance Number without hyphen
This is a key field and cannot be changed in the data file. If a new SIN is provided for a member that is not in the system, the entire line will be rejected.
|
Yes
|
9
|
123456789
|
Employeur
|
Employer
|
Permit number of the establishment (employer) without hyphen.
This is a key field and cannot be changed in the data file.
|
Yes
|
15
|
12345678
|
DateEmbauche
|
Hire Date
|
Date of hire of the employee.
If your employee has more than one function, you must provide a distinct line of information by function (where the employee is active) in the data file. For example: your employee works in two functions, then the file must contain two separate lines for the employee. The hire date is then based on the first day of the occupation of the function.
This date should be the most recent hire date. When there is a rehired, the hire date must correspond to that date of rehired and not to the original date of first employment.
|
Yes
|
8
|
YYYY-MM-DD
|
Fonction
|
Function
|
Current function of the employee.
This is a key field and cannot be changed in the data file.
|
Yes
|
7
|
Fonctions
|
DateDebutPériode
|
Period Start Date
|
Start date of the pay period for transactions detailed below (first day of the period).
|
Yes
|
8
|
YYYY-MM-DD
|
DateFinPériode
|
Period End Date
|
End date of pay period for transactions detailed below (last day of the period).
|
Yes
|
8
|
YYYY-MM-DD
|
DatePaiement
|
Payment Date
|
Payment Date of the transactions detailed below, i.e. actual payment date of earnings.
|
Yes
|
8
|
YYYY-MM-DD
|
SalaireGagne
|
Earned salary
|
Eligible earnings paid for the pay period defined above.
Please refer to the Administrative Guide for more details on the compensation that is included or excluded in the eligible earnings.
|
Yes
|
19
|
99,99
|
HeuresTravaillees
|
Worked Hours
|
Amount of regular hours worked during the pay period defined above.
|
Yes
|
19
|
37,50
|
HeuresSupplementaires
|
Overtime Hours
|
Amount of supplemental hours worked during the pay period defined above.
|
No
|
19
|
12,00
|
HeuresReconnues
|
Pensionable Hours
|
Pensionable hours during a leave for which the member is providing contributions during the pay period defined above.
|
No
|
19
|
12,00
|
CotisationsEmployee
|
Employee Contributions
|
Regular Employee contributions during the pay period period plus the contributions paid by the member during a leave.
|
Yes
|
19
|
250,00
|
SalaireHeuresSupplementaires
|
Overtime Salary
|
Overtime pensionable earnings during the pay period (i.e. Salary received for Overtime Hours). Includes part-time and full-time overtime salary.
|
Yes
|
19
|
99,99
|
CotisationsHeuresSupplementaires
|
Overtime Contributions
|
Employee contributions pertaining to Salary received for Overtime Hours during the pay period.
|
Yes
|
19
|
10,00
|
SalaireRetroactif
|
Retroactive Salary
|
Retroactive pensionable earnings during the pay period (i.e. Salary received due to Retroactive Salary paid). Includes part-time and full-time retroactive salary.
|
yes
|
19
|
99,99
|
CotisationsRetroactives
|
Retroactive Contributions
|
Employee contributions pertaining to Salary received due to Retraoctive Salary paid during the pay period.
|
yes
|
19
|
10,00
|
SalaireGagneAvantAdhesion
|
Earned salary before the enrolment in the Plan
|
Regular earnings, before the enrolment, during the pay period (i.e. Basic salary). Includes part-time and full-time earned salary.
|
yes
|
19
|
99,99
|
HeuresRemunereesAvantAdhesion
|
Paid hours before the enrolment in the Plan
|
Amount of regular hours worked during the pay period, including supplementary and for leave of absence; before the enrolment in the Plan.
|
yes
|
19
|
12,00
|