Header record
|
|
Field Name |
Field Size |
ATTR |
O/M |
Start |
End |
|
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 |
PRINER – Principal Employer PARTER – Participating Employer PAYCEN – Pay Centre BROKER – Broker SCHEME – External Scheme |
|
|
2 |
D_effective |
8 |
Char |
M |
7 |
14 |
Ccyymmdd |
|
|
3 |
T_name |
150 |
Char |
M |
15 |
164 |
Organisation Name |
|
|
4 |
C_code_1 |
15 |
Char |
M |
165 |
179 |
Organisation Code |
|
|
5 |
C_code_2 |
8 |
Char |
O |
180 |
187 |
Related Organisation Code |
|
|
6 |
Link_type |
15 |
Char |
O |
188 |
202 |
Relation Type: PAY CENTRE BROKER |
|
|
7 |
D_fin_year_end |
4 |
Char |
O |
203 |
206 |
Organisation year-end |
|
|
8 |
F_language |
15 |
Char |
O |
207 |
221 |
Organisation Language. Validate to Language UDPV values. |
|
|
9 |
C_ext_org_type |
15 |
Char |
O |
222 |
236 |
ASSET MANAGER ASSURER COMPANY INSURANCE CO INTERMEDIARY INTERMEDIARY GP MEDICAL AID REASSURER UNDERWRITER SCHEME |
|
|
10 |
T_payment_method |
15 |
Char |
O |
237 |
251 |
CHEQUE or EFT |
|
|
11 |
T_status |
15 |
Char |
O |
252 |
266 |
ACTIVE or SUSPENDED |
|
|
12 |
D_collection_eff |
8 |
Char |
O |
267 |
274 |
ccyymmdd |
|
|
13 |
D_collection_end |
8 |
Char |
O |
275 |
282 |
ccyymmdd |
|
|
14 |
D_collection_lpd |
8 |
Char |
O |
283 |
290 |
ccyymmdd |
|
|
15 |
F_invioce |
6 |
Char |
O |
291 |
296 |
Y or N |
|
|
16 |
C_title |
15 |
Char |
O |
297 |
311 |
Broker title |
|
|
17 |
T_surname |
30 |
Char |
O |
312 |
341 |
Broker Name |
|
|
18 |
T_initials |
5 |
Char |
O |
342 |
346 |
Broker Initials |
|
|
19 |
T_first_name |
20 |
Char |
O |
347 |
366 |
Broker first name |
|
|
20 |
R_identity |
15 |
Char |
O |
367 |
381 |
Broker ID |
|
|
21 |
D_dob |
8 |
Char |
O |
382 |
389 |
ccyymmdd |
|
|
22 |
R_reg_number |
25 |
Char |
O |
390 |
414 |
|
|
|
23 |
C_code_3 |
8 |
Char |
O |
415 |
422 |
INTERMEDIARY / INTERMEDIARY GP |
|
|
24 |
C_code_4 |
8 |
Char |
O |
423 |
430 |
COMM MEMBERSHIP GROUP |
|
|
25 |
C_code_5 |
8 |
Char |
O |
431 |
438 |
INCOME TYPE |
|
|
26 |
C_contract_out_no
|
25 |
Char |
O |
439 |
463 |
Scheme contracted out number |
|
|
27 |
C_appr_sch_cont_out_no
|
25 |
Char |
O |
464 |
488 |
Appropriate scheme contracted out number |
|
|
28 |
Status |
15 |
Char |
O |
489 |
503 |
Status: APPROVED BLACKLISTED |
|
|
29 |
Industry_classification |
15 |
Char |
O |
504 |
518 |
OTHER ENGINEERING EDUCATION MOTOR IND DOMESTIC TEXTILES CHEM OIL IND WHOLESALE SMALL BUSINESS ADVERTISE HEALTH TOURISM AGRICULTURE FINANCIAL INST GOVERNMENT IT AND TELECOM ALCOHOLIC BEV UNION |
|
Note:
Fields 10 – 15 are required for Debit Order funds.
Positions 1-3 of the last row must contain EOF, followed by a return character.
When the file is loaded, the system will check that the Organisation Unit Code is unique. If not, the Organisation Unit details will not be loaded and an error message will be written to the error log.
For more details refer to Organisation Unit Upload under
Processes
File Transfer
Conversion
Uploading Files and Documents