| |
NPF Schemes
General
To talk to someone about your scheme, phone
0800 628 776
|
|
I.P.A.R
Technical Specifications
Following are the technical specifications for setting up IPAR.
-
Media specifications
File to be created in ASCII text format and be attached to Email
-
Record types
Each file sent will always comprise seven different record types but may contain four different record types if Salary Sacrifice contributions are payable:
- One header record per scheme and per Employer identity number batch
- One detail record per employee payment
- One additional detail record per employee ONLY if the member has a salary sacrifice contribution
- One trailer record per scheme and per Employer identity number batch
-
Amount fields
Please ensure that all amount fields are in the following format:
Unsigned Right justified Zero filled No currency sign or punctuation Amounts in cents.
Example: $1,000.00 shown as 00000100000
-
Employer Identity and Member Contract Number fields
Please ensure that these fields are in the following format:
Right justified Zero filled
Example: 141867 would be shown as 000141867
The Employer Identity Number and the Member Contract Numbers will be supplied by Datacom.
-
Field specifications
| Description of field |
Length |
Field End |
Contents & comments |
| Header record |
| Record type |
2 |
2 |
00 is used to indicate a header. That is, the start of a batch. |
| Employer identity number |
9 |
11 |
The Employer identity number will be supplied by Datacom, right justified. |
| Employer name |
30 |
41 |
The employer's full name, left justified. |
| Filler |
67 |
108 |
Spaces. |
| Last pay date |
8 |
116 |
DDMMCCYY - The end date of the pay period last reported to Datacom. |
| Filler |
4 |
120 |
Spaces. |
| Pay date |
8 |
128 |
DDMMCCYY - The end date of the pay period(s) currently being reported to Datacom. This will be the "last pay date" on the next tape or diskette. |
| Filler |
14 |
142 |
Spaces. |
| SCWT indicator |
1 |
143 |
Must be N = nett payments. |
| Filler |
19 |
162 |
Spaces. |
|
|
|
|
| Detail record |
| Record type |
2 |
2 |
01 is used to indicate information within a batch. Each 01 record should contain information about a particular employee's superannuation deduction. |
| Contract number |
9 |
11 |
A Contract Number is supplied by Datacom for each employee, right justified. |
| Member name |
30 |
41 |
The employee's name, left justified, formatted as: Surname First name Middle names Please don't include titles, or insert commas between names. |
| Filler |
9 |
50 |
Spaces. |
| Scheme number |
3 |
53 |
Used to identify scheme types. Your Scheme uses code ‘999’ |
| Employee contributions |
11 |
64 |
The total regular contributions paid by the employee (for the pay periods reported). That is, from Period last pay date to Pay date. |
| Employer contributions |
11 |
75 |
The total contributions paid by the employer (for the pay periods reported). That is, from Period last pay date to Pay date. |
| Employee arrears |
11 |
86 |
This field should be zero. |
| Employer arrears |
11 |
97 |
This field should be zero. |
| Superable annual salary |
11 |
108 |
Optional. To be supplied for Defined Benefit Products and for Defined Contribution Products where Salary is needed for Insurance premium calculation. Zero if field not required. |
| Salary change date |
8 |
116 |
Enter date if Superable annual salary is supplied. Else the field should be zero. |
| Filler |
27 |
143 |
Spaces. |
| Pay period salary |
11 |
154 |
The field should be zero. |
|
|
|
|
| Detail record 2 |
Employee Voluntary and Salary Sacrifice |
| Record type |
2 |
2 |
04 is used to indicate information within a batch. Each 04 record should contain information about a particular employee's voluntary and or salary sacrifice deduction. If no Voluntary or Salary Sacrifice deduction has been made then do NOT write a 04 record |
| Contract number |
9 |
11 |
A Contract Number is supplied by Datacom for each employee, right justified. |
| Member name |
30 |
41 |
The employee's name, left justified, formatted as: Surname First name Middle names Please don't include titles, or insert commas between names. |
| Filler |
9 |
50 |
Spaces. |
| Scheme number |
3 |
53 |
Used to identify scheme types. Your Scheme uses code ‘999’ |
| Voluntary contributions |
11 |
64 |
The total Voluntary contributions paid by the employee (for the pay periods reported). That is, from Period last pay date to Pay date. |
| Salary Sacrifice contributions |
11 |
75 |
The total Salary Sacrifice contributions paid by the employer on behalf of this particular employee (for the pay periods reported). That is, from Period last pay date to Pay date. |
| Employee arrears |
11 |
86 |
This field should be zero |
| Employer arrears |
11 |
97 |
This field should be zero |
| Superable annual salary |
11 |
108 |
This field should be zero. |
| Salary change date |
8 |
116 |
This field should be zero. |
| Filler |
27 |
143 |
Spaces. |
| Pay period salary |
11 |
154 |
This field should be zero. |
|
|
|
|
| Trailer |
| Record type |
2 |
2 |
99 is used to indicate a trailer. That is, the final (summary) record in a batch. |
| Employer identity number |
9 |
11 |
This will be the same as the Employer identity number in the header. |
| Employer name |
30 |
41 |
This will be the same as the Employer name in the header. |
| Filler |
56 |
97 |
Spaces. |
| Total |
11 |
108 |
Sum of all contributions for this batch. (Employee + Employer + Voluntary + Salary Sacrifice??) |
| Filler |
54 |
162 |
Spaces. |
|
|
| |
|
|
|