File Layout Summary

AB22

Member Financial

This file is for members invested in a unitized portfolio and will contain the latest unitized position or monetary position.

It applies to live members and living annuitants.

This is loaded via the Conversion Tool.

AB33

Bank Accounts

This file is for loading individual person bank details.

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

AB34

Organisation Unit Bank Account

This file is for loading the Bank Account details for an Organisation Unit.

AB44

Notes

This file is for loading all member note information. 

This is loaded using Batch BJU3EG and then processed by BJU5AA.

AB45

Payroll

The payroll file is used to upload membership data.

AB55

Liabilities

This file is for loading liability settlement values as provided by the lending institution.

This is loaded via the Conversion Tool.

AB60

Pensionable Service Dates

This file is for loading member pensionable service dates.

Pensionable service dates can also be taken on using the transfer and service details file.

This is loaded via the Conversion Tool.

AB66

Beneficiaries

This file is for the bulk load of nominated beneficiaries for “live” members (expression of wish”.  These details may be stored for purposes of future benefit claims. 

AB77

Annuity Payment

This file upload is for loading the beneficiary membership record as well as the regular payment details for the beneficiary.

AB78

Annuity Payment Detail Upload

This file is for loading payment detail update for ad-hoc payment / ad-hoc increases

AB88

Addresses

This file is for the loading of address details.

A record is required for each person receiving an annuity, i.e. the principal member OR each dependant (for whom you want to record addresses).

AB89

Organisation Unit Address

This file is for loading the Address details for an Organisation Unit.

AB91

Member Status Upload

This file is for uploading bulk changes in members’ status to unclaimed.

AB92

Membership Relationships

This file is for the bulk upload of Client Relationship Types of FORM RECEIVED.

This should only be used when uploading expression of wish of members in a file.

This is required in order to load the EOW data which must be extracted in the Benefit Statement files.

AB93

Tracing Agent File

This file is for loading of notifications of pending exit that are received in a csv file from a Tracing Agent as part of the pre-claim process.

BA01

Medical Aid Rates

This file is for loading of Medical Aid Rates.

BA02

Membership Group Allocation

This file is for loading Membership Group Allocations for Main Annuitants and Living Annuitants only.

BENV

Member Values

This file is for the loading of Member Values for Flexible Benefit schemes 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.

BNK001

Bank Branches

This file is for loading bank branches for members.

BROKER

Broker

This file is for loading Broker details using Batch BJU3EB.

CONH

Contribution History

This file is for loading member contributions history using Batch BJU3RN.

CONH

Contribution Updates

This file layout enables the bulk updating of contributions for existing members using Batch BJU3RN.

CONH

Retirement Annuity Fund Contributions

This file layout is for the bulk upload of individual Retirement Annuity Fund member contribution amounts using Batch BJU3RN.

CORP

Organisation Unit

This file layout is for loading Corporate Client details using Batch BJU3EB.

DOCU

Bulk Document Upload

This file layout is for the bulk upload of documents into the document management table.

JUH0

Individual Retirement Annuity Members

This file layout enables the processing of Individual Retirement Annuity Members.

Batch BJU3EA loads all Memberships
Batch BJU3RN loads Memberships for Debit Order schemes.

This layout is also used for the loading of initial member data for annuity-only schemes or the bulk updating of details for existing members, via the JUH0 layout. 

JUH0

Membership Details

This bulk upload file layout is for loading initial member data for all types of funds.

Note:

This layout must be used for loading the deceased member details.  The Beneficiary Member details will be loaded using the Annuity Payment file layout.

JUH5

Beneficiary Fund Membership Details

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

MINV

Member Investment Splits

This file is for loading a member's investments where the investments are split across multiple portfolios. 

Applicable to live members and living annuitants.  (Investment Allocations).

PAYCEN

Pay Centre

This file is for loading Pay Centres using Batch BJU3EB.

PD

FinSwitch Unit Price Upload

The FinSwitch Price Distribution (PD) file is used for the upload of a file of unit prices received in a csv file from an Asset Manager, using the FinSwitch Interface.

PERS

Person Load

This file layout is for loading Natural Person records.

PRINER
or
PARTER

Employer

This file is for loading either Principle Employer or Participating Employer details using Batch BJU3EB.

SALD

Salary

This file is for loading the salary information for members of Debit Order Umbrella Funds.

This is loaded using Batch BJU3EG and then processed by BJU5AA.

SALH

Hours History

This file is for loading the hour’s history for members. 

This is loaded using BJU3EG and then processed by BJU5AA. (Salary Type = HOURS only). 

SALH

Monthly Earnings History

This file is for loading the monthly earnings history for members. 

This is loaded using Batch BJU3EG and then processed by BJU5AA.

SALH

Salary History

This file is for loading the salary information for members. 

This is loaded using Batch BJU3EG and then processed by BJU5AA.

SALH

Shift History

This file is for loading the shift history for members. 

This is loaded using Batch BJU3EG and then processed by BJU5AA. (Salary Type = SHIFT only). 

TRFR

Member Transfer Values Upload

This file is for loading of member transfer value details.

VOLU

Member Defined Contribution Rules

This file is for loading of member defined contribution rules as per the file upload menu items by scheme.

When the file is uploaded, the member additional contributions will be created as per the current process on the JU4DD Member Additional Contributions.

Age Related Rebate

The first layout is used to load members’ National Insurance Contribution Office (NICO) earnings and the rebate rates using Batch BJU3EP.

The second layout is used to load the data on the global percentage table.

Batch File Upload

This file is for loading External Portfolio Values using Batch BJU3CG.

Unit Prices Upload

This file is for loading Unit Prices using Batch BJU3EJ.

Upload Bulk Journal File

This file is for loading Journals using Batch BJU3AN.

Upload Bulk Switch File

This file is for loading Bulk Switches using Batch BJU3BG.

Bulk Journal Take-on Layout

This file is the BJU3ANBTLOAD layout, which is used for the bulk journal take-on for annuity migration.