Bank Accounts

This file is for loading individual person bank details.

 

The banking details must be for the member and not a 3rd party, otherwise it will reject. 

 

Note:

A record is required for each person receiving an annuity, i.e. the principal member OR each dependant, for whom bank account details are required.

 

Validations

-          The date format must be correct (e.g. a date of 19521560 will reject because the month and day are invalid).

-          The member must exist on the system.

-          Where fields require specific values, these values have been indicated in the Description / Value column of the detail record below.

 

View data uploaded

To view Bank Account data loaded for a beneficiary member for an Annuity:

 

Log in to the system from the Logon page.

 

Click clients

 

The Welcome screen will be displayed.

 

 

From the main menu on top, click Members.  The JU3AO List of Members for a Scheme/Pay Centre screen will be displayed.

 

Once the required member has been selected, the JU3AO List of Members for a Scheme/Pay Centre screen will be displayed.  Highlight the required member and select Annuity Details from the Sub-menu on the left. 

 

 

The JU4DB Annuitant Process screen will be displayed.

 

 

Select Banks Accounts from the sub-menu on the left.

 

 

The JU1CN Member Bank Account screen will be displayed.

 

 

The bank account details that were loaded via the conversion tool will be shown.

 

To view Bank Account data loaded for a beneficiary member of a Beneficiary Fund:

Select the Scheme Code for the Beneficiary Fund of the member and select Member List from the menu on the left. 

 

 

Click on a Member with a Status of one of the following:

SPOUSE

DEPENDANT

DISABLED DEPDNT

ANNUITANT

LIVING ANNUITNT

BENEFICIARY

 

 

Click on the beneficiary.

 

Select Bank Account from the sub-menu on the left.

 

 

The JU1CN Bank Account Details screen will be displayed.

 

 

To view data loaded for a beneficiary member of any other Fund:

 

Click

 

The Welcome screen will be displayed.

 

 

From the main menu on top, click Members.  The JU3AO List of Members for a Scheme/Pay Centre screen will be displayed.

 

Once the required member has been selected, the JU3AO List of Members for a Scheme/Pay Centre screen will be displayed.  Highlight the required member and select Membership Details > Bank Accounts from the sub-menu on the left. 

 

 

The JU1CN Member Bank Account screen will be displayed.

 

 

To view bank account details, highlight the required line then click OPEN.  The JU1CN Bank Account Details screen will be displayed.

 

 

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

AB33

2

FundNumber

7

 

Char

M

5

11

Scheme code

3

MemberNumber

20

 

Char

M

12

31

Member reference number

Beneficiary 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

M

75

89

Member ID number

8

Status

15

 

Char

O

90

104

SPOUSE

DEPENDANT

DISABLED DEPDNT

ANNUITANT

LIVING ANNUITNT

BENEFICIARY

9

Start_date

8

 

Num

M

105

112

CCYYMMDD - date from which the bank account is effective.

10

R_DTI_ACCOUNT

16

 

Char

O

113

128

The bank account number.

11

T_NAME

50

 

Char

O

129

178

The name of the bank account holder.

12

C_UDPV_BANK_

ACC_TP

15

 

Char

M

179

193

The type of bank account.

CURRENT

SAVINGS

13

F_MANDATE

1

 

Char

M

194

194

Value must be N

14

R_LINE

8

 

Num

M

195

202

Only required if BANK INTERFACE = NEDINFORM.

15

Organization Code

6

 

Char

M

203

208

The organization (e.g. bank) code.

Note:

This will become unique in the system.

16

Branch Code

6

 

Char

M

209

214

Bank branch code.

17

C_UDPV_BANK_

INTERFACE

 

 

 

 

15

 

Char

M

215

229

The bank interface service that must be used for this bank account.

CASHFOCUS

NEDINFORM

FNB ONLINE

LDC

 

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.

 

Refer to

Supplements

Processes

Data Take On Process For Pensioners

 

For information on the order of loading, refer to

Processes

Regular Payments

New Business

Loading Data for Annuitants