Field Name Field
Positions		 Format Data Required
Transaction Code 1-2 Either '94' or '18'
Detail Type 3 Character Either '1', '4', 'A', 'L', 'M', or 'W'
Plan 4-7 Either 'PSPP', 'MEPP', or 'MSRP'
Employer Number 8-10 Character UDF 'PN-EMPLOYER NUMBER' attached to IBPN
Batch Number 11-21 Number System date followed by three unique number.
The system extracts the three unique number
by taking the last three digits of the execution-
ID which is created at the time of execution
TAD Number 22-30 Blank Not applicable
TAD Counter 31-32 Blank Not applicable
Member SIN 33-41 Number Social Insurance Number of Member
Last Name 42-71 Member’s last name
Reg. Flag 72 Blank Not applicable
Employee Num. 73-82 Blank Not applicable
Dept. Number 83-102 Blank Not applicable
Title 103 Blank Not applicable
Stakeholder Last
Name		104-133 Blank Not applicable
Stakeholder Middle
Name		134-163 Blank Not applicable
Stakeholder Sex 184 Blank Not applicable
Marital Status 185 Blank Not applicable
Date of Birth 186-193 Blank Not applicable
Verify DOB flag 194 Blank Not applicable
Date Contribution
Commenced		195-202 Blank Not applicable
Relationship 203 Blank Not applicable
Address-1 204-243 Blank Not applicable
Address-2 244-283 Blank Not applicable
City 284-303 Blank Not applicable
Province/State 304-305 Blank Not applicable
Postal/ZIP 306-315 Blank Not applicable
Country 316-217 Blank Not applicable
Effective Date 318-325 Blank Not applicable
Same as Member 326 Blank Not applicable
E-Mail address 327-386 Blank Not applicable
Phone Type 387 Blank Not applicable
Country Code 388-390 Blank Not applicable
Area Code 391-393 Blank Not applicable
Phone Number 394-400 Blank Not applicable
Extension 401-404 Blank Not applicable
New SIN 405-413 Blank Not applicable
Beneficiary Split 414-419 Blank Not applicable
Employ Status 420 *'F' for Group Type 'Full Time' or 'Temp Full Time'
* 'P' for Group Type 'Part Time' or 'Temp Part Time'.
* If other Group Type is found, then it will be BLANK filled.
Service Year 421-424 YYYY Year for service based on year entered in report
Pen. Salary 425-435 S9999999.99* From IPPE pay element (these Pay
Element names can be modified as long
as the corresponding IDIF definition also
reflects the modified names)
* 'PEN ACT LTD EARN' for Type 18-4
* 'PEN NC EARN' for Type 18-A
* 'PEN NC-PL EARN' for Type 18-M
* 'PEN LVE EARN' for Type 18-L
* 'PEN LVE-PL EARN' for Type 18-W
Service 436-447 S999999.9999 Pay Element / (IEAS Hours per pay * #Pays in year)
These Pay Element names can be modified as
long as the corresponding IDIF definition also
reflects the modified names)
* 'PEN ACT LTD HRS' for Type 18-4
* 'PEN NC HRS' for Type 18-A
* 'PEN NC-PL HRS' for Type 18-M
* 'PEN LVE HRS' for Type 18-L
* 'PEN LVE-PL HRS' for Type 18-W
Member
Contributions		448-460 S999999999.99 From IPPE pay element. (these Pay Element
names can be modified as long as the
corresponding IDIF definition also reflects the
modified names)
* 'PEN PSPP EE' for Type 18-4 for PSPP Plan
* 'PEN MEPP EE' for Type 18-4 for MEPP Plan
* 'PEN MSRP EE' for Type 18-4 for MSRP Plan
* 'PEN PSPP EE-LVE' for Type 18-L for PSPP Plan
* 'PEN MEPP EE-LVE' for Type 18-L for MEPP Plan
* 'PEN MSRP EE-LVE' for Type 18-L for MSRP Plan
* 'PEN PSPP EE-PL' for Type 18-W for PSPP Plan
* 'PEN MEPP EE-PL' for Type 18-W for MEPP Plan
* 'PEN MSRP EE-PL' for Type 18-W for MSRP Plan
* Not applicable for Type 18-A and 18-M,
it will be zero filled.
Employer
Contributions		461-473 S999999999.99 * From IPPE pay element. (these Pay
Element names can be modified as long
as the corresponding IDIF definition also
reflects the modified names)
* 'PEN PSPP ER' for Type 18-4 for PSPP Plan
* 'PEN MEPP ER' for Type 18-4 for MEPP Plan
* 'PEN MSRP ER' for Type 18-4 for MSRP Plan
* 'PEN PSPP ER-LVE' for Type 18-L for PSPP Plan
* 'PEN MEPP ER-LVE' for Type 18-L for MEPP Plan
* 'PEN MSRP ER-LVE' for Type 18-L for MSRP Plan
* 'PEN PSPP ER-PL' for Type 18-W for PSPP Plan
* 'PEN MEPP ER-PL' for Type 18-W for MEPP Plan
* 'PEN MSRP ER-PL' for Type 18-W for MSRP Plan
* Not applicable for Type 18-A and 18-M,
it will be zero filled.
Optional Service 474 Blank Not applicable
From Date 475-482 YYYYMMDD Either the First Pay Period Start Date of the
year or the BEND effective date, whichever is later
To Date 483-490 YYYYMMDD Either the Last Pay Period End Date of the
year or the BEND expiry date, whichever is earlier.
Term. status 491 Blank Not applicable
Withholding Year 492-495 YYYY Withholding year
Withholding Mon. 496-497 Blank Not applicable
Withholding Day 498-499 Blank Not applicable
Number of Details 500-504 Number Only applicable for Transaction Code and Detail Type 94-1.
Application ID 505-507 Blank Not applicable
Pay Frequency 508 Blank Not applicable

Notes #

Click to create a new notes page
This page (revision-2) was last changed on 26-Nov-2021 10:22 by JEscottTop