Member Defined Contribution Rules

Field Name

Field Size

DEC

ATTR

O/M

Start

End

Description /Value

1

File indicator

4

Char

M

1

4

VOLU

2

Fund Number

7

Char

M

5

11

Scheme code

3

Member Number

20

Char

M

12

31

Member reference number

4

Surname

30

Char

M

32

61

Surname

5

Initials

5

Char

M

62

66

Initials

6

DOB

8

Num

M

67

74

CCYYMMDD - Date of Birth

7

IDnumber

15

Char

O

75

89

ID number

8

Status

15

Char

M

90

104

MEMBER

9

Purchase Amount

11

2

Num

M

105

115

The original amount if history records are being loaded otherwise the current amount.

10

Payment Type

15

Char

M

116

130

MEMBERDEFINED

11

Payment Start Date

8

Num

M

131

138

CCYYMMDD - The original date if history records are being loaded otherwise the same as the effective date.

12

Effective Date

8

Num

M

139

146

CCYYMMDD - the effective date from which the payments must start.

13

Date of last extract

8

Num

M

147

154

CCYYMMDD - the date on which the last contribution was deducted or received

14

Amount of regular payment

11

2

Num

O

155

165

The amount of the payment to be made regularly.

15

C_UDPV_FREQUENCY

15

Char

M

166

180

The frequency of the payment.

ANNUALLY

BI-ANNUAL

MONTHLY

QUARTERLY

16

Filler

23

Num

O

181

203

17

Percentage

7

4

Num

O

204

210

The percentage

18

Filler

22

Num

O

211

231

19

End Date

8

Num

O

232

239

CCYYMMDD - the date on which the contribution will end.

20

Filler

317

Char

M

240

558

spaces

21

Income Type

4

Char

O

559

562

Contribution income type

22

Filler

189

Char

O

563

753

spaces