||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|Edit:Internal.UBEF+APA+INTERFACE+FILE+LAYOUT] [{InsertPage page='Internal.UBEF+APA+INTERFACE+FILE+LAYOUT' default='Click to create a new notes page'}]