This is the layout for the bulk upload of Client Relationship Types of FORM RECEIVED.
This should only be used when uploading expression of wish of members in a file. This is required in order to load the EOW data which must be extracted in the Benefit Statement files.
Detail record
|
|
Field Name |
Field Size |
DEC |
ATTR |
O/M |
Start |
End |
Description /Value |
|
1 |
Type |
4 |
|
Char |
M |
1 |
4 |
AB92 |
|
2 |
Fund Code |
7 |
|
|
M |
5 |
11 |
Scheme Code |
|
3 |
Member Ref No |
20 |
|
Char |
M |
12 |
31 |
Member reference number |
|
4 |
Company Ref No |
20 |
|
Char |
O |
32 |
51 |
Company Reference Number |
|
5 |
Client Rel Start Date |
8 |
|
Char |
M |
52 |
59 |
Client Relationship Start Date |
|
6 |
Relationship Type |
15 |
|
Char |
M |
60 |
74 |
Form Received |
O = Optional field
M = Mandatory
Note:
All optional text fields must be padded with trailing spaces.
All numeric fields must be padded with leading zeroes.