Individual Member Extract (Reports for Member)

Member Reference

The referenced number identifying the member.

The completion of this field is mandatory.

From Date

The date from which the extract must take place.

The completion of this field is optional.

To Date

The date up to which the extract must take place.

The completion of this field is optional.

Email

The e-mail address of the person who must be notified that the extract is available.

SCHEME CODE

Scheme Code

SCHEME NAME

Scheme Name

MEMBER NUMBER

Membership Reference Number

MEMBER NAME

Initials and Surname of the Natural Person to which the Membership is linked

CALCULATIONDATE

Extract To Date

EXTRACTFROMDATE

Extract From Date. If no From Date is captured set the From Date to the Membership CAR Start Date (Date of Joining Scheme)

MEMBER GENDER

Gender of the Natural Person to which the Membership is linked

MEMBER DOB

Date of birth of the Natural Person to which the Membership is linked

PENSERVICEDATE

Pensionable Service Date on Transfer Detail record or if not found, CAR Start Date (date of joining fund)

DATE JOINED

CAR Start Date

NRD

Normal Retirement Date derived from the Member’s date of birth and the Normal Retirement Age for the Member’s Benefit Membership Group as at the report To Date.

CONTRIB GROUP

Description of Member’s Contribution Membership Group as at the report To Date

BENEFIT GROUP

Description of Member’s Benefit Membership Group as at the report To Date

INVESTMNT GROUP

Description of Member’s Investment Membership Group as at the report To Date

SPOUSE DOB

Date of Birth on Beneficiary record with a Type of SPOUSE

DIVORCE ORDER

Set to Y if a Membership Liability record is found for the Member with a Type of DIVORCE and for which the Liability End Date is null

DIVORCEAMTPAID

Read the Benefit Request records for the Membership and if a Benefit Request is found with a Benefit Event of DIVORCE ORDER sum the Amounts on the Disposal Instructions records linked to the Benefit Request.

DIVORCE DATE

Read the Benefit Request records for the Membership and if a Benefit Request is found with a Benefit Event of DIVORCE ORDER extract the Calculation Effective Date on the Benefit Request

DIVORCEPMTDATE

Read the Benefit Request records for the Membership and if a Benefit Request is found with a Benefit Event of DIVORCE ORDER extract the Disposal Effective Date on the Disposal Instruction with a Disposal Type of CASH or TRSFR TO FUND.

SALARY DATE

Find each Actual Earning record with an Effective Date greater than or equal to the extract Start Due Date and less than or equal to the extract To Due Date for the Membership with a Member Salary Component Type of BASIC and extract the Effective Date.

If a record is not found with an Effective Date equal to the extract Start Due Date find the Actual Earning record with the latest Effective Date less than the extract Start Due Date. Set the value for this record to the extract Start Due Date.

SALARY

For each Actual Earning record found for SALARY DATE extract the Amount for the Actual Earning record for which the Member Salary Component Type is BASIC.

RISK SALARY

For each Actual Earning record found for SALARY DATE extract the Amount for the Actual Earning record for which the Member Salary Component Type is RISK SALARY.

DATEOFOPENBL

Extract Start Due Date

DATEOFCLOSEBAL

Extract End Due Date

CONTOPENDDBAL

Extract the balance on the Member’s CONTRIBUTION account as at the extract Start Due Date per Income Type.

CONTCLOSEDDBAL

Extract the balance on the Member’s CONTRIBUTION account as at the extract End Due Date per Income Type.

INVOPENDDBAL

Extract the Monetary Effective Date balance on the Member’s INVESTMEMB account as at the extract Start Due Date per Income Type and Portfolio.

INVCLOSEDDBAL

Extract the Monetary Effective Date balance on the Member’s INVESTMEMB account as at the extract End Due Date per Income Type and Portfolio.

INVUNITOPENBAL

Extract the Unit Effective Date balance on the Member’s CONTRIBUTION account as at the extract Start Due Date per Income Type and Portfolio.

INVUNITCLOSEBAL

Extract the Unit Effective Date balance on the Member’s CONTRIBUTION account as at the extract End Due Date per Income Type and Portfolio.

OPENBALINCTYPE

The Income Type for the balance extracted for CONTOPENDDBAL, INVOPENDDBAL or INVUNITOPENBAL

CLOSEBALINCTYPE

The Income Type for the balance extracted for CONTCLOSEDDBAL, INVCLOSEDDBAL or INVUNITCLOSEBAL

OPENBALPORTF

The Portfolio for the balance extracted for CONTOPENDDBAL, INVOPENDDBAL or INVUNITOPENBAL

CLOSEBALPORTF

The Portfolio for the balance extracted for CONTCLOSEDDBAL, INVCLOSEDDBAL or INVUNITCLOSEBAL

DATE OF TRAN

Extract all of the Business Transactions (BT’s) in the Member’s CONTRIBUTION, INVESTMEMB and INVSTMEMUNIT accounts with a Due Date greater than or equal to the extract Start Due Date and less than or equal to the extract To Due Date. Extract the dates of the BT’s found.

TRAN PROCESS

The Process Occurrence ID for each BT extracted for DATE OF TRAN above.

TRAN INCOMETYPE

The Income Type for each BT extracted for DATE OF TRAN above.

TRAN PORTFOLIO

The Portfolio for each BT extracted for DATE OF TRAN above from the Member’s INVESTMEMB or INVSTMEMUNIT account

CONTRIB AMOUNT

The Monetary Amount for each BT extracted for DATE OF TRAN above from the Member’s CONTRIBUTION account.

INVESTAMOUNT

The Monetary Amount for each BT extracted for DATE OF TRAN above from the Member’s INVESTMEMB account.

NUMBEROFUNITS

The Unit Value for each BT extracted for DATE OF TRAN above from the Member’s INVSTMEMUNIT account.

NOTE HEADER

Extract the Notation records linked to the Membership with a Notation Type of MEMBER and extract the Header

NOTE TEXT

The Text value for the Notation record extracted for NOTE HEADER above.

LIABILITY TYPE

Find the Membership Liability records for the Membership and extract the Liability Type

LIABILITY AMT

For each of the Membership Liability records found for LIABILITY TYPE extract the Settlement Amount or if no Settlement Amount is found the Amount Liable

LIABILITYPMTDTE

For each of the Membership Liability records found for LIABILITY TYPE extract the Settlement Date.