Membership Group (File Layout)

The Membership Group file is used for the upload of a file of Main Annuitants and Living Annuitants.  

 

It can be loaded via the Processes > Annuities > New Business > Annuity Details File Upload and Annuity Details Load path (i.e. BJU3EG & BJU5AA).

 

 

For information refer to

Processes

Annuities

New Business

Annuity Details

Annuity Details File Upload

Annuity Details Load

 

Note:

This was created for Membership updates.  The business uses the payment schedule as reference, which contains the beneficiaries’ (spouses and dependants) personal details.  The business can use this for Annuitants, but will need the assistance of the Vendor to update spouses’ and dependants’ membership numbers.

 

Input file example

 

Input file layout

Detail record

 

 

Field Name 

Field Size 

DEC 

ATTR 

O/M 

Start 

End 

Description /Value 

1

File indicator

4

 

Char

M

1

4

BA02

2

Fund Number

7

 

Char

M

5

11

Fund Code

3

Member Number

20

 

Char

M

12

31

Member Reference Number

4

Member Surname

30

 

Char

M

32

61

Member Surname

5

Initials

5

 

Char

M

62

66

Initials

6

Date of Birth

8

 

Char

M

67

74

Date of Birth

7

ID Number

15

 

Char

M

75

89

ID Number

8

Membership Group Code

15

 

Char

M

90

104

Membership Group Code

9

Membership Group Type

15

 

Char

M

105

119

Membership Group Type

10

Membership Group Start Date

8

 

Char

M

120

127

CCYYMMDD

11

Membership Group End Date

8

 

Char

O

128

135

CCYYMMDD (Leave Blank)

 

O = Optional field

M = Mandatory field

 

Refer to

Supplements

Processes

Data Take On Process for Pensioners

 

For information on the order of loading, refer to

Processes

Annuities

New Business

Loading Data for Annuitants