Beneficiary Fund Membership Details (File Layout)

This bulk upload file layout is used for loading deceased and beneficiary members of a Beneficiary Fund.

Navigate the system as follows:

From the Main Functionality menu select Process > File Transfer > File Transfer

Select Batch File Upload from the sub-menu on the left.

The Batch File Upload screen will be displayed.

Select BENEFICIARY MEMBER LOAD from the Batch Processes drop-down list.

Use BROWSE (refer to File upload above) to find the document to be uploaded, then click SUBMIT. A message will confirm that the file has been successfully

Once the file has been loaded, the relevant batch job can be submitted.

For information about submitting batch jobs refer to

Reports

Batch Runs

Locate the required batch job from the list.

To initiate the batch job, click Submit in the action column.

The progress of the batch job can be monitored in the error log.

After the batch job has completed, the error log must be checked for any errors.

For more information refer to

Reports

General

Error Log Report

For details of the file layout, refer to

Processes

File Transfer

File Layouts

Batch Files

For more details on uploading a file received from Home Affairs refer to

Supplements

Processes

Processing the Home Affairs File

Input file layout

Header record

None required

Detail record

	Field Name	Field Size	DEC	ATTR	O/M	Start	End	Description /Value
1	File indicator	4		Char	M	1	4	JUH5
2	MemberNumber	20		Char	M	5	24	Member reference number
3	Organisation Code	6		Char	M	25	30	Participating Employer Code
4	COREF	8		Char	O	31	38	Company Reference Number
5	Surname	30		Char	M	39	68	Surname
6	Title	15		Char	O	69	83	Member's Title
7	Initials	5		Char	M	84	88	Member's Initials
8	First Name	20		Char	O	89	108	Member's First Name
9	ID	15		Char	M	109	123	ID Number
10	DOB	8		Char	M	124	131	YYYYMMDD
11	Gender	15		Char	O	132	146	Male or Female
12	Marital Status	15		Char	O	147	161	Marital Status
13	Filler 1	1		Char	M	162	162	Space
14	Employment start	8		Char	M	163	170	YYYYMMDD
15	Date Joining Fund	8		Char	M	171	178	YYYYMMDD
16	Membership Group 1	15		Char	M	179	193	Contribution Membership Group
17	Membership Group 2	15		Char	M	194	208	Benefit Membership Group
18	Membership Group 3	15		Char	O	209	223	Investment Membership Group
19	Transfer Value	15	2	Num	O	224	238
20	Date leaving Fund	8		Char	O	239	246	YYYYMMDD
21	Paycentre Code	8		Char	M	247	254	Paycentre Code
22	Cycle Month	8		Char	M	255	262	YYYYMMDD
23	FundNumber	7		Char	M	263	269	Scheme code
24	Membership Group 4	15		Char	O	270	284	Medical Aid Membership Group
25	Membership Group 5	15		Char	O	285	299	Annuity Membership Group (used for selection criteria for annuity increase)
26	Membership Group 6	15		Char	O	300	314	Payment Day Membership Group (used for selection criteria for annuity monthly run)
27	Status	15		Char	O	315	329	Membership status: LIVE (default), DEFERRED, DEF ANNUITANT, DECEASED, EXITFINALISED, ANNUITANT, LIVING ANNUITNT, UNCLAIMED BEN, PHI, DECEASEDANNUITY, BENEFICIARY.
28	Tax Reference Number	20		Char	O	330	349	Tax reference number of the person
29	Membership Group 7	15		Char	O	350	364	SCHEMELIFECYCLE Membership group
30	Intermediary Code	15		Char	O	365	379	Intermediary Code
31	Language	15		Char	O	380	394	ENGLISH or AFRIKAANS.
32	Salary Amount	11	2	Num	O	395	405	Amount of Salary
33	Filler	1		Char	M	406	406	Space
34	External Code	20		Char	O	407	426	Client code on administrator’s other systems.
35	Tax Status	15		Char	O	427	441	Tax status: TAX EXEMPT
36	Annual Fee %	7	2	Num	O	442	448	Annual broker fee percentage
37	Identity Type	15		Char	O	449	463	ID Type : SA ID OTHER NATIONAL ID PASSPORT
38	Date of Death	8		Char	O	464	471	Date of death of deceased
39	Deceased Surname	30			O	472	501	If the Membership being loaded is the Beneficiary then the Surname of the deceased person to which the Membership being loaded is linked.
40	Deceased ID Number	15		Char	O	502	516	If the Membership being loaded is the beneficiary then the ID Number of the deceased person to which the Membership being loaded is linked.
41	Relationship to Deceased	15		Char	O	517	531	Relationship of the Beneficiary to the Deceased: DAUGHTER SON Etc.
42	Guardian Surname	30		Char	O	532	561	If the Membership being loaded is the beneficiary then the Surname of the beneficiary’s guardian.
43	Guardian ID Number	15		Char	O	562	576	If the Membership being loaded is the beneficiary then the ID Number of the beneficiary’s guardian.
44	Relationship to Beneficiary	15		Char	O	577	591	Relationship of the Beneficiary to the Guardian
45	Allocation Percentage	7	2	Num	O	592	598	Percentage of the death benefit granted to the Beneficiary
46	Allocation Amount	11	2	Num	O	599	609	Amount of the death benefit granted to the Beneficiary
47	Education Level	15		Char	O	610	624	School grade or year of tertiary education for which the Beneficiary is enrolled
48	Education Institution	6		Char	O	625	630	Education institution to which the Beneficiary is enrolled
49	Grade From Date	8		Char	O	631	638	Date from which the Beneficiary is enrolled for a grade or year of tertiary education
50	Grade To Date	8		Char	O	639	646	Date to which the Beneficiary is enrolled for a grade or year of tertiary education
51	Employee Number	20		Char	O	647	666	If the Membership Status is DECEASED the Member’s employee number
52	Filler	1		Char	M	667	667	Space

O = Optional field

M = Mandatory

If there is a value for Intermediary Code, the system will create a Client Relationship record linking the Membership to the Intermediary Client with a Code equal to the Intermediary Code in the file. If no Intermediary Client record is found with a Code equal to the value in the file, an error message will be written to the error log.

Note:

All optional text fields must be padded with trailing spaces.

All numeric fields must be padded with leading zeroes.

Trailer record

None required

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