Header record
|
|
Field Name |
Field Size |
ATTR |
Start |
End |
Description / Value |
|
1 |
Rec_type |
6 |
Char |
1 |
6 |
HEADER |
|
2 |
C_fund |
7 |
Char |
7 |
13 |
Fund Code |
Detail record
|
|
Field Name |
Field Size |
ATTR |
O/M |
Start |
End |
Description / Value |
|
1 |
Rec_type |
6 |
Char |
M |
1 |
6 |
PRINER1 – Principle Employer PARTER1 – Participating Employer PAYCEN1 – Pay Centre BROKER1 - Broker |
|
2 |
D_effective |
8 |
Char |
M |
7 |
14 |
Effective date of record Ccyymmdd |
|
3 |
T_name |
150 |
Char |
M |
15 |
164 |
Organisation Name |
|
4 |
C_code_1 |
8 |
Char |
M |
165 |
172 |
Organisation Code |
|
5 |
C_code_2 |
8 |
Char |
O |
173 |
180 |
Related Organisation Code |
|
6 |
Link_type |
15 |
Char |
O |
181 |
195 |
Relation Type PAY CENTRE HAS BRANCH BROKER |
|
7 |
D_fin_year_end |
4 |
Char |
O |
196 |
199 |
Organisation year-end |
|
8 |
F_language |
1 |
Char |
O |
200 |
200 |
Organisation Language E/A |
|
9 |
C_ext_org_type |
15 |
Char |
O |
201 |
215 |
Organisation Type ASSET MANAGER ASSURER COMPANY INSURANCE CO INTERMEDIARY INTERMEDIARY GP REASSURER UNDERWRITER |
|
10 |
T_payment_method |
15 |
Char |
O |
216 |
230 |
CHEQUE or EFT |
|
11 |
T_status |
15 |
Char |
O |
231 |
245 |
ACTIVE or SUSPENDED |
|
12 |
D_collection_eff |
8 |
Char |
O |
246 |
253 |
ccyymmdd |
|
13 |
D_collection_end |
8 |
Char |
O |
254 |
261 |
ccyymmdd |
|
14 |
D_collection_lpd |
8 |
Char |
O |
262 |
269 |
ccyymmdd |
|
15 |
F_invioce |
6 |
Char |
O |
270 |
270 |
Y or N |
|
16 |
C_title |
15 |
Char |
O |
271 |
285 |
Broker title |
|
17 |
T_surname |
30 |
Char |
O |
286 |
315 |
Broker Name |
|
18 |
T_initials |
5 |
Char |
O |
316 |
320 |
Broker Initials |
|
19 |
T_first_name |
20 |
Char |
O |
321 |
340 |
Broker first name |
|
20 |
R_identity |
15 |
Char |
O |
341 |
355 |
Broker ID |
|
21 |
D_dob |
8 |
Char |
O |
356 |
363 |
ccyymmdd |
|
22 |
R_reg_number |
25 |
Char |
O |
364 |
388 |
|
|
23 |
C_code_3 |
8 |
Char |
O |
389 |
396 |
INTERMEDIARY / INTERMEDIARY GP |
|
24 |
C_code_4 |
8 |
Char |
O |
397 |
404 |
COMM MEMBERSHIP GROUP |
|
25 |
C_code_5 |
8 |
Char |
O |
405 |
412 |
INCOME TYPE |
O = Optional field
M = Mandatory
Notes
T_NAME
If the REC_TYPE is PAYCEN, this field can only be 50 characters but must be space filled to 150.
C_CODE_1
If the REC_TYPE is PRINER1, PARTER1 or BROKER1, this field can only be 6 characters but must be space filled to 8.
Additional info
The following fields are required if a collection instruction is to be loaded for the organisation:
- T_PAYMENT_METHOD (EFT or CHEQUE)
- T_STATUS (ACTIVE or SUSPENDED)
- D_COLLECTION_EFF (ccyymmdd)
- D_COLLECTION_END (ccyymmdd)
- D_COLLECTION_LPD (ccyymmdd)
- F_INVOICE
The following fields are required if the broker is a person.
- C_TITLE
- T_SURNAME
- T_INITIALS
- T_FIRST_NAME
- R_IDENTITY
- D_DOB
In order to set up a benefit category per participating employer, set C_code_3 equal to BENEFITC. If this facility is used then use the first 4 characters of field 25 C_code_5 to populate the MINIMUM AGE and YEARS TO NRF.
In order to automatically generate a pay centre per participating employer, set C-code_4 equal to PAYCEN.
Note:
Positions 1-3 of the last row must contain EOF, followed by a return character.