Member Transfer Values Upload (File Layout)

This file layout enables the upload of member transfer value details.

 

View data uploaded

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 Membership Details > Membership Transfer Detail from the sub-menu on the left. 

 

 

The JU3AL Membership Transfer Details List screen will be displayed. 

 

 

The transfer date shown is the date the data was loaded into the system.

 

To view details of the transfer, select the item and select OPEN.  The JU3AL Membership Transfer Details Maintain screen will display the transfer details that were loaded.

 

 

For more details refer to Membership transfer detail under

Clients

Membership Details

 

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

 

2

Scheme Code

7

 

Char

M

5

11

Scheme code of scheme for which Take-on values are being loaded

3

Member Number

20

 

Char

M

12

31

Member’s membership reference number

4

Transfer Date

8

 

Char

M

32

39

Date of transfer into the Scheme (CCYYMMDD)

5

Type of Transfer

15

 

Char

M

40

54

CNV PENS – PROV

CNV PROV – PENS

CNV PUBL – PENS

CNV PUBL – PROV

CNV PUBL – PUBL

TRN PENS- PENS

TRN PENS – PROV

TRN PENS – PUBL

TRN PROV – PENSS

TRN PROV – PROV

TRN PROV – PUBL

TRN PUBL – PENS

TRN PUBL – PROV

TRN PUBL - PUBL

 

Pensionable Service Date

8

 

Char

M

55

62

Pensionable Service date (CCYYMMDD)

 

Member Contributions

10

2

Num

O

63

72

Member contributions to a previous Provident Fund.  Either the contributions to the fund from which the member is transferring or a previous transfer.

 

Tax-Free Amount

10

2

Num

O

73

82

Used for transfers into a Preservation Fund to indicate the tax free portion of a member’s benefit that was paid to the member when the benefit was transferred to the Preservation Fund.

 

Withdrawal Amount

10

2

Num

O

83

92

The portion of a withdrawal benefit that was paid to the member where the balance is being transferred to a Preservation Fund

 

Transferring Fund

150

 

Char

O

93

242

Transferring Scheme

 

O = Optional field

M = Mandatory