| 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 pageScreen captures are meant to be indicative of the concept being presented and may not reflect the current screen design.
If you have any comments or questions please email the Wiki Editor
All content © High Line Corporation