Member Values (File Layout)

This file is for the loading of Member Values for Flexible Benefit Products using Batch BJU3CF.

Data such as service, transfers in, deferred take-on values, voluntary contribution percentages, temporary absence information and offshore service details will be stored. This file contains the member transfer details, service details and pensionable service dates.

Note:

This only applies to schemes where the PENSION STATUS on the JU1BK Nature of Scheme screen is either CONTRACTED IN or CONTRACTED OUT.

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 MEMBER VALUES 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 Batch Runs under

Scheme Reports

Overview

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.

Refer to Error Log Report (General) under

Scheme Reports

General

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

Take-on file layout

Upload Field	Type	Size	Dec	Start	End	Description
File Indicator	Char	4		1	4	BENV
Scheme Code	Char	7		5	11	Scheme code of scheme for which Take-on values are being loaded
Member Number	Char	20		12	31	Member’s membership reference number
Date Effective	Char/Date	8		32	39	Effective date of record (CCYYMMDD)
Type	Char	15		40	54	Type= one of TRANSFER, TEMP ABSENCE, MATERNITY, OFFSHORE SERV, NORMAL SERV, BOUGHT SERVICE, BACKDATE, GMP, BENEFICIARY FUND: TERMINATION RF PENSION AMT EDUCATION ALLOW plus others possibly.
Subtype	Char	15		55	69	Subtype= one of CNV PUBL PROV, PRESERVATION, MATERNITY, AJP, AJM, AVC, BKB, BULK, LUMPSUM, INSTALMENT, AJK, SECTION, FIXED. If the Type is Beneficiary Fund: TERMINATION RF PENSION AMT INC UTILISATION If Type is Education: REASON
Subtype Detail	Char	15		70	84	Classification of membership details (e.g. NAMIBIA, section 148, Fixed Rate) If Subtype is TERMINATION: TERMINATION AGE TERMINATION DTE If Subtype is REASON: MULT BEN ACCS TRUST ACCOUNT If Subtype is INC UTILISATION: DISCRETIONARY FIXED INCOME REINVESTED MAX OF INTEREST
Period Start Date	Char/Date	8		85	92	Pensionable Service date, Start Date of Temporary Absence or Offshore Service, or Service Date for backdated service (CCYYMMDD)
Period End Date	Char/Date	8		93	100	End Date of service for Temporary Absence or Offshore Service (CCYYMMDD) If Subtype is TERMINATION and Subtype Detail is TERMINATION DTE then Beneficiary’s termination date.
Amount	Num	10	2	101	110	Money used for Preservation fund If Subtype is RF PENSION AMT and the Membership Status is DECEASED then the spouse’s pension amount received from the transferor retirement fund. If the Subtype is RF PENSION AMT and the Membership Status is BENEFICIARY then the child’s pension amount received from the transferor retirement fund.
Member Contributions	Num	10	2	111	120	Member contributions transferred
Tax-Free Amount	Num	10	2	121	130	The portion of employee contributions that should not be taxed in future.
Withdrawal Amount	Num	10	2	131	140	The portion of a withdrawal benefit that was paid where the balance was transferred to a preservation fund
Percentage	Num	7	4	141	147	Percentage of salary (to purchase service, if applicable), percentage of LTA If Subtype is TERMINATION and Subtype Detail is TERMINATION AGE then Beneficiary’s termination age.
Period Type	Char	15		148	162	To define, for example, how a period is measured (e.g. MONTHS or YEARS to purchase additional service).
Number of Periods	Num	4		163	166	e.g. the number of Months in the period (to purchase additional service)
Income Type	Char	4		167	170	Income type to be used to classify the amount fields
Discontinue Contributions?	Char	1		171	171	Whether contributions cease during temporary absence or offshore service (Y/N)
Factor	Num	11	8	172	182	For protected benefits
Date Accounting Confirmed	Char/Date	8		183	190	Date accounting records were confirmed. (CCYYMMDD)
Description	Char	150		191	340	Transferring Scheme

The end of file indicator is EOF.

When the file is uploaded the Member Values record will be created linked to the Membership with the relevant Type, Subtype and Subtype Detail (if applicable) and the relevant field value (Period Start Date, Period End Date, Amount, etc.) if applicable.