alongside New under Member Register on the sub-menu on the left. Additional options will be displayed.This report is per Broker, previous scheme or member for a specified period.
From the Beneficiary Fund menu, click alongside New under Member Register on the sub-menu on the left. Additional options will be displayed.
Click New below Member Register. The Member Register screen will be displayed.
Capture or select the relevant details as follows:
|
Effective Date |
The effective date of the report. The system defaults to the current date as being the effective date. Capture a new date if required. |
|
Broker |
The system defaults to ALL brokers. If a single Broker is required, then select a Broker from the drop-down list of Intermediaries linked to the scheme. |
|
Previous Fund (the retirement fund from which the benefit was paid). |
The system defaults to ALL previous funds. If a single fund is required, then select a fund from the drop-down list of Pay Centres linked to the scheme. |
|
Reference Number |
Capture the trust number for a specific member, or leave blank to display all members that fit the criteria specified. |
|
|
The email address to which the extract must be sent. |
Click GENERATE REPORT.
The current report detail will be displayed on the lower portion of the screen.
A message will indicate once the job has been successfully submitted (and an e-mail will be sent to the e-mail address provided).
Click View below Member Register. The Report Selection screen will be displayed.
The following columns are displayed:
- Timestamp
- Date Captured
- Report Type
- Sequence Number
- Action
To select a report, click on the hyperlinked display in the Action column alongside the appropriate report.
Per Broker
The Member Register Details screen will be displayed per Broker, Previous Fund and Member (Beneficiary).
The following columns are displayed:
|
Report Item |
Details |
|
Broker |
The Intermediary |
|
Previous Fund |
The Paycentre |
|
Trust Number |
The Membership Reference Number of the Member for which the Membership Status is DECEASED |
|
Trust Name |
The Name and initials of the Member for which the Membership Status is DECEASED.
The system reads the Intermediary and Paycentre (Previous Fund) linked to the Membership and group by first Intermediary and then Paycentre. |
|
Beneficiary Reference Number |
The Membership Reference Number of the Member for which the Membership Status is BENEFICIARY.
The system finds the Members linked to the Deceased Member and display these in sequence immediately below the Deceased Member. |
|
Beneficiary Name |
The Name and Initials of the Member for which the Membership Status is BENEFICIARY. |
|
Start Date |
The start date of the Membership Client Agreement Role (CAR). |
|
Termination Date |
The End Date on the Membership Payment record for the Beneficiary. |
|
Status |
The Annuitant Status on the Membership Payment Detail record. |
|
Suspension Reason |
The Amendment Type on the Membership Payment Detail record where the Annuitant Status is SUSPENDED. |
|
Capital Received |
The Original Amount on the Membership Payment record for the Beneficiary. |
|
Total Market Value |
The sum of the Market Value of the Member’s investments per Portfolio. |
|
Monthly Payment |
The Regular Payment Amount on the Membership Payment Detail record. |
|
Monthly Payment Year to Date |
The sum of the Business Transaction on the Member’s BENEFITS account with the Accounting Activity REGULAR PMT (and the Accounting Activities associated to it via the Accounting Activity Association with a Purpose Type MEM REGISTER), and a Due Date less than or equal to the report Effective Date and greater than the Scheme’s last Financial Year-End. |
|
Ad-Hoc Payments Year to Date |
The sum of the Business Transaction on the Member’s BENEFITS account with the Accounting Activity ADHOCPAYMENT (and the Accounting Activities associated to it via the Accounting Activity Association with a Purpose Type MEM REGISTER), and a Due Date less than or equal to the report Effective Date and greater than the Scheme’s last Financial Year-End. |
|
Fees Year to Date |
The sum of the Business Transaction on the Member’s MEM DEPOSIT account with the Accounting Activity MEMINVADMFEE (and the Accounting Activities associated to it via the Accounting Activity Association with a Purpose Type MEM DETAILS), and a Due Date less than or equal to the report Effective Date and greater than the Scheme’s last Financial Year-End |
|
Total Current Market Value |
The sum of the Market Value of the Member’s investments per Portfolio as at the report Effective Date. |
|
Item |
The Fund and Beneficiary name. |
|
Cash |
The effective date of the unit price used per each Portfolio. |
|
Fixed |
The effective date of the unit price used per each Portfolio. |
Per Employer
The Member Register Details screen will be displayed per Employer and Member (Beneficiary).
The following columns are displayed:
- EMPLOYER
- DECEASED REFERENCE NUMBER
- DECEASED NAME
- DECEASED DATE OF BIRTH
- BENEFICIARY REFERENCE NUMBER
- BENEFICIARY NAME
- BENEFICIARY DATE OF BIRTH
- START DATE
- TERMINATION DATE
- STATUS
- SUSPENSION REASON
- CAPITAL RECEIVED
- MONTHLY PAYMENT
- MONTHLY PAYMENT YEAR TO DATE
- ADHOC PAYMENTS YEAR TO DATE
- FEES YEAR TO DATE
- ITEM
- BANKER
- INV1
- NED01
- NED03
- PERFORM
- REALRET