This is a flexible format administration report which provides a generic report catering for all schemes.
The content of the administration reports per scheme should be set up using the flexible document structures to tailor the appearance and content of the reports per scheme or to bring in certain elements from a global perspective to create a uniform look across either the company or per operating area.
A separate document template should be set up for each section of the report and individual PDF documents generated for each section when the administration report is extracted. These separate documents can then be included in the administration report pack as required.
This report is extracted when the administration report batch job is run.
Select ADMIN from the top menu.
The following menu will be displayed on the left.
Click 
alongside Admin Report Extract. Additional options will be displayed.
Note:
If the fund selected is a Beneficiary Fund then additional fields will be displayed for capture. Refer to New (Beneficiary Funds) below.
To create a new report, select New from the sub-menu on the left. The Admin Report screen will be displayed.
Capture data as follows:
|
From Date |
The start date of the reporting period.
The completion of this field is mandatory. |
|
To Date |
The date up to which reporting must take place.
The completion of this field is mandatory. |
|
Template |
Select a Template from the drop-down list.
The selection of a Template is mandatory. |
|
|
The e-mail address of the person who must be notified that the extract is available. |
Click GENERATE REPORT.
The following message will display to confirm that the report has been scheduled:
Admin Report has been scheduled.
Please click on the View Queue menu on the left to view the progress
Click OK to remove the message and select View Queue from the sub-menu on the left. Refer to the View Queue section below.
Processing
When GENERATE REPORT is selected, the system will read the Document Template with a PDF Process Type of ADMIN REPORT and a Template Type of REPORT CONTENT linked to the Scheme and extract the information depending on the Document Templates linked to the ADMIN REPORT Document Template.
The system will extract the information separately for each Document Template linked to the ADMIN REPORT Document Template and create separate reports for each Document Template as per the table below:
|
PDF Process Type |
Report |
Report Name |
|
ADMREP COVER |
Cover page |
ADMIN REP COVER PAGE |
|
ADMREP MEMSTATS |
Membership Statistics |
ADMIN REP MEMBER STATS |
|
ADMREP EMPSTATS |
Employer Statistics |
ADMIN REP EMPLOYER STATS |
|
ADMREP INVSTATS |
Investment Statistics |
ADMIN REP INV STATS |
|
ADMREP CLAIMS |
Claims Summary |
ADMIN REP CLAIMS SUMMARY |
|
ADMREP CONTRIBS |
Contribution Summary |
ADMIN REP CONTRIBUTIONS |
|
ADMREP EXPENSES |
Expense Summary |
ADMIN REP EXPENSES |
|
ADMREP ORDERS |
Divorce/Maintenance Orders |
ADMIN REP DIV/MAINT ORDERS |
|
ADMREPTRUSTEES |
Trustee Details |
ADMIN REP TRUSTEE DETAILS |
For the Document Templates with a Process Type of ADMREP ANNEXURE, the system will create a separate report for each Document Template as per the table below:
|
PDF Process Type |
Report |
Report Name |
|
ANNEX SCHEDULES |
Schedules and Deposits |
ADMIN REP SCHEDULES |
|
ANNEX SECT 13A |
Section 13A |
ADMIN REP SECTION 13A |
|
ANNEX OS RECONS |
Outstanding Reconciliations |
ADMIN REP O/S RECONS |
|
ANNEX |
Reconciliations Updated |
ADMIN REP RECONS UPDATED |
|
ANNEX CONT/INV |
Contributions/Investments |
ADMIN REP CONTRIBS & INV |
|
ANNEX NEW ERS |
New Employers |
ADMIN REP NEW EMPLOYERS |
|
ANNEX NEW MEMS |
New Members |
ADMIN REP NEW MEMBERS |
|
ANNEX PFA DET |
PFA Determinations |
ADMIN REP PFA DETERMINATIONS |
|
ANNEX PFA COMP |
PFA Complaints |
ADMIN REP PFA COMPLAINTS |
|
ANNEX DIVORCE |
Divorce Court Orders |
ADMIN REP DIVORCE ORDERS |
|
ANNEX MNTNANCE |
Maintenance Orders |
ADMIN REP MAINTENANCE ORDERS |
|
ANNEX CLAIMS |
Claims Details |
ADMIN REP CLAIMS DETAILS |
|
ANNEX DISABILITY |
Disability Claims |
ADMIN REP DISABILITY CLAIMS |
|
ANNEX CASHFLOW |
Cash Flow |
ADMIN REP CASHFLOW |
|
ANNEX TRUST EXP |
Trustee Expenses |
ADMIN REP TRUSTEE EXPENSES |
For information on the Tags set up for each section refer to
Supplements
Tags
Admin Report
Note:
If the Pooling Status of the Scheme selected is MAIN UMBRELLA, the system will extract the information per Scheme with a Pooling Status of SUB UMBRELLA linked to the MAIN UMBRELLA Scheme selected and create separate reports per SUB UMBRELLA Scheme.
If the fund selected is a Beneficiary Fund, select New from the sub-menu on the left to create a new report. The Admin Report screen will be displayed.
Capture data as follows:
|
From Date |
The start date of the reporting period.
The completion of this field is mandatory. |
|
To Date |
The date up to which reporting must take place.
The completion of this field is mandatory. |
|
Template |
Select a Template from the drop-down list.
The selection of a Template is mandatory. |
|
Previous Fund |
Select a from the drop-down list of Participating Employers linked to the Scheme. |
|
Participating Employer |
Select from the drop-down list of Pay Centres linked to the Scheme.
Note: The drop-down list will only be enabled for selections if a Previous Fund has been selected. |
|
|
The e-mail address of the person who must be notified that the extract is available. |
Click GENERATE REPORT.
The following message will display to confirm that the report has been scheduled:
Admin Report has been scheduled.
Please click on the View Queue menu on the left to view the progress
Click OK to remove the message and select View Queue from the sub-menu on the left. Refer to the View Queue section below.
An email will be sent to the email address captured in the Email field.
Example:
Processing
When GENERATE REPORT is selected, the system will read the Document Template for the Document Template selected and extract the information based on the Document Template.
For each of the Field Tags linked to the Template Elements linked to the Document Template, the system will extract the data as per the details in the table below:
|
Field Tag |
System Value |
|
SCHEME NAME |
The Scheme Name (If the Scheme selected is a MAIN UMBRELLA Scheme or a SUB UMBRELLA Scheme). |
|
PREVFUND NAME |
The Name of the Participating Employer record for the Previous Fund selected for the report. |
|
PART ER NAME |
The Name of the Pay Centre for the Participating Employer selected for the report. |
|
REPORT PERIOD |
The From Date and the To Date captured for the report. |
|
ACCS AT START |
Number of Memberships for which the Membership Status is DECEASED and the Date of Commencement is less than the report From Date. |
|
BENS AT START |
Number of Memberships for which the Membership Status is BENEFICIARY and the Date of Commencement is less than the report From Date. |
|
NEW ACCOUNTS |
Number of Memberships for which the Membership Status is DECEASED and the Date of Commencement is greater than or equal to the report From Date and less than or equal to the report To Date. |
|
NEW BENES |
Number of Memberships for which the Membership Status is BENEFICIARY and the Date of Commencement is greater than or equal to the report From Date and less than or equal to the report To Date. |
|
ACCS ACTIVE |
Number of Memberships for which the Membership Status is DECEASED and the Date of Commencement is less than or equal to the report To Date. |
|
BENES ACTIVE |
Number of Memberships for which the Membership Status is not DECEASED, EXIT IN PROCESS or EXIT FINALISED and the Date of Commencement is less than or equal to the report To Date. |
|
ACCS TERMINATED |
The number of Memberships for which the Membership Status is DECEASED and for which the Membership Status of all of Memberships linked to the DECEASED Membership have a Membership Status of EXIT IN PROCESS or EXIT FINALISED and for which the Effective Date of the latest Membership Status for all of the lied Memberships is greater than or equal to the report From Date and less than or equal to the report To Date. |
|
BENESTERMINATED |
Number of Memberships for which the Membership Status is EXIT IN PROCESS or EXIT FINALISED and the Effective Date of the Membership Status is greater than or equal to the Report Start Date and less than or Equal to the Report To Date. |
|
ACCOUNTS AT END |
Number of Memberships for which the Membership Status is DECEASED and the Date of Commencement is less than the report To Date. |
|
BENES AT END |
Number of Memberships for which the Membership Status is BENEFICIARY and the Date of Commencement is less than the report To Date. |
|
AVE MV ACCOUNTS |
Calculate the market value of all of the investments for the Memberships with a Membership Status of BENEFICIARY as the report To Date. Calculate the market value based on the unit balance on the Member’s INVSTMEMUNIT account per Portfolio as at the report To Date and the unit price as at the report To Date. Sum the market values calculated and the monetary balance on the Member’s INVESTMEMB account. Sum the market values for all of the Memberships and divide the total by the number of active Memberships with a Membership Status of DECEASED as at the Report To Date (see ACCOUNTS AT END) |
|
AVE MV BENES |
Calculate the market value of all of the investments for the Memberships with a Membership Status of BENEFICIARY as the report To Date. Calculate the market value based on the unit balance on the Member’s INVSTMEMUNIT account per Portfolio as at the report To Date and the unit price as at the report To Date. Sum the market values calculated and the monetary balance on the Member’s INVESTMEMB account. Sum the market values for all of the Memberships and divide the total by the number of active Beneficiaries as at the Report To Date (see BENES AT END) |
|
CAP ADVANCES |
Find all of the Memberships for which there is one or more Business Transactions (BT) with an Accounting Activity of ADHOCPAYMENT in the Member’s MEM DEPOSIT account with a Transaction Date greater than or equal to the report From Date and less than or equal to the report To Date and count the number of Memberships. |
|
PORTFOLIO |
Portfolio Name of each of the Investment Portfolios for the Scheme for which there is Monetary balance in the INVESTMEMB account or the INVSTMEMUNIT account. |
|
MARKET VALUE |
Calculate the market value of all of the investments for the Memberships with a Membership Status of BENEFICIARY as the report To Date. Calculate the market value based on the unit balance on the Member’s INVSTMEMUNIT account per Portfolio as at the report To Date and the unit price as at the report To Date. Sum the market values calculated and the monetary balance on the Member’s INVESTMEMB account. Sum the market values per Portfolio for all of the Memberships. Display the value in the table next to the Tag with the Portfolio name. |
|
% OF TOTAL MV |
For each Portfolio calculate the market value as a percentage of the sum of the market values for all of the Portfolios. |
|
TERM ACC REF NO |
Membership Reference Number of the Membership with a Membership Status of DECEASED to which the Membership with a Membership Status of EXIT IN PROCESS or EXIT FINALISED and for which the Effective Date of the Membership Status is greater than or equal to the report Start Date and less than or equal to the report To Date is linked |
|
TERM ACC NAME |
First Names and surname of the Membership with a Membership Status of DECEASED to which the Membership with a Membership Status of EXIT IN PROCESS or EXIT FINALISED and for which the Effective Date of the Membership Status is greater than or equal to the report Start Date and less than or equal to the report To Date is linked |
|
TERM BENE REFNO |
Membership Reference Number of the Membership with a Membership Status of EXIT IN PROCESS or EXIT FINALISED and for which the Effective Date of the Membership Status is greater than or equal to the report Start Date and less than or equal to the report To Date |
|
TERM BENE NAME |
First Names and Surname of the Membership with a Membership Status of EXIT IN PROCESS or EXIT FINALISED and for which the Effective Date of the Membership Status is greater than or equal to the report Start Date and less than or equal to the report To Date |
|
TERMINATION DATE |
Effective Date of the Membership Status of EXIT IN PROCESS or EXIT FINALISED for the Membership with a Membership Status of EXIT IN PROCESS or EXIT FINALISED and for which the Effective Date of the Membership Status is greater than or equal to the report Start Date and less than or equal to the report To Date |
|
TERMINATION AMT |
Sum of the MEMBENRLINV and MEMBENRLUNT BT’s in the Member’s BENPAYABLE account for the Membership with a Membership Status of EXIT IN PROCESS or EXIT FINALISED and for which the Effective Date of the Membership Status is greater than or equal to the report Start Date and less than or equal to the report To Date |
|
NEW ACCOUNT NO |
Membership Reference Number of the Membership with a Membership Status of DECEASED with a Date of Commencement greater than or equal to the report From Date and less than or equal to the report To Date. |
|
NEW ACC NAME |
First Names and Surname of the Membership with a Membership Status of DECEASED with a Date of Commencement greater than or equal to the report From Date and less than or equal to the report To Date. |
|
NEW BENE NO |
Membership Reference Number of the Membership with a Membership Status of BENEFICIARY with a Date of Commencement greater than or equal to the report From Date and less than or equal to the report To Date. |
|
NEW BENE NAME |
First Names and Surname of the Membership with a Membership Status of BENEFICIARY with a Date of Commencement greater than or equal to the report From Date and less than or equal to the report To Date. |
|
BENE START DATE |
Date of Commencement of the Membership with a Membership Status of BENEFICIARY with a Date of Commencement greater than or equal to the report From Date and less than or equal to the report To Date. |
|
BENE INIT CAP |
Balance on the Member’s CONTRIBUTION account for the Membership with a Membership Status of BENEFICIARY with a Date of Commencement greater than or equal to the report From Date and less than or equal to the report To Date. |
|
0 – 5 |
The number of Memberships for which the Membership with a Membership Status of BENEFICIARY and for which the Age based on the Member’s Date of Birth and the Report To Date is less than or equal to 5, and for which the Date of Commencement is less than the report To Date and the End Date is null or greater than the report To Date. |
|
6 – 10 |
The number of Memberships for which the Membership with a Membership Status of BENEFICIARY and for which the Age based on the Member’s Date of Birth and the Report To Date is greater than 5 and less than or equal to 10, and for which the Date of Commencement is less than the report To Date and the End Date is null or greater than the report To Date. |
|
11 – 15 |
The number of Memberships for which the Membership with a Membership Status of BENEFICIARY and for which the Age based on the Member’s Date of Birth and the Report To Date is greater than 10 and less than or equal to 15, and for which the Date of Commencement is less than the report To Date and the End Date is null or greater than the report To Date. |
|
16 – 17 |
The number of Memberships for which the Membership with a Membership Status of BENEFICIARY and for which the Age based on the Member’s Date of Birth and the Report To Date is greater than 15 and less than or equal to 17, and for which the Date of Commencement is less than the report To Date and the End Date is null or greater than the report To Date. |
|
18 – 20 |
The number of Memberships for which the Membership with a Membership Status of BENEFICIARY and for which the Age based on the Member’s Date of Birth and the Report To Date is greater than 17 and less than or equal to 20, and for which the Date of Commencement is less than the report To Date and the End Date is null or greater than the report To Date. |
|
21 – 25 |
The number of Memberships for which the Membership with a Membership Status of BENEFICIARY and for which the Age based on the Member’s Date of Birth and the Report To Date is greater than 20 and less than or equal to 25, and for which the Date of Commencement is less than the report To Date and the End Date is null or greater than the report To Date. |
|
26 AND OVER |
The number of Memberships for which the Membership with a Membership Status of BENEFICIARY and for which the Age based on the Member’s Date of Birth and the Report To Date is greater than 25, and for which the Date of Commencement is less than the report To Date and the End Date is null or greater than the report To Date. |
|
NEW CAPITAL |
Sum of the BT’s in the CINTRIBFUND with an Accounting Activity of MEM CONTRIB with a Transaction Date greater than or equal to the report Start Date and Less than or Equal to the report To Date. |
|
UNALLOC DEPS |
Balance of the UNALLOC DEP account as at the report To Date. |
|
AD HOC PMTS |
Sum of the BT’s in the Member’s MEM DEPOSIT account with an Accounting Activity of ADHOCPAYMENT with a Transaction Date greater than or equal to the report Start Date and Less than or Equal to the report To Date. |
|
TERMINATION<1OK |
Sum of the BT’s in the Member’s BENPAYABLE account with an Accounting Activity of BENPAYAMNT with a Transaction Date greater than or equal to the report Start Date and Less than or Equal to the report To Date and for which the value is less than 10 00.00. |
|
TERMINATION>1OK |
Sum of the BT’s in the Member’s BENPAYABLE account with an Accounting Activity of BENPAYAMNT with a Transaction Date greater than or equal to the report Start Date and Less than or Equal to the report To Date and for which the value is greater than or equal to 10 00.00. |
|
BENEDEACTIVATED |
Number of Member’s with a Membership Status of DEACTIVIATED and for which the Effective Date of the Membership Status is greater than or equal to the report From Date and less than or equal to the report To Date. |
|
FUND START DATE |
Read the value for Commencement Date for the Fund |
|
MV PER FUND |
Sum of the Market Value of the Investments for the Beneficiaries linked to the Previous Fund (Participating Employer) as at the report To Date. |
|
CAP INTRO LASTM |
The sum of the MEMBERCONTRIB BT’s in the Member’s CONTRIBUTION account with a Transaction Date greater than or equal to the first day of the last month in the reporting period and less than or equal to the Report To Date linked to the Previous Fund (Participating Employer) |
|
CAPINTROLASTM% |
The sum of the MEMBERCONTRIB BT’s in the Member’s CONTRIBUTION account with a Transaction Date greater than or equal to the first day of the last month in the reporting period and less than or equal to the Report To Date linked to the Previous Fund (Participating Employer) as a percentage of the sum of the MEMBERCONTRIB BT’s for the same period for all of the Previous Funds. |
|
CAP INTRO YTD |
The sum of the MEMBERCONTRIB BT’s in the Member’s CONTRIBUTION account with a Transaction Date greater than or equal to the report From Date and less than or equal to the Report To Date linked to the Previous Fund (Participating Employer) |
|
CAP INTRO YTD % |
The sum of the MEMBERCONTRIB BT’s in the Member’s CONTRIBUTION account with a Transaction Date greater than or equal to the report From Date and less than or equal to the Report To Date linked to the Previous Fund (Participating Employer) as a percentage of the sum of the MEMBERCONTRIB BT’s for the same period for all of the Previous Funds. |
|
TOTAL MV |
Sum of the Market Value of the Investments for all of the Beneficiaries as at the report To Date. |
|
TOTCAPINTROLM |
The sum of the MEMBERCONTRIB BT’s in the Member’s CONTRIBUTION account with a Transaction Date greater than or equal to the first day of the last month in the reporting period and less than or equal to the Report To Date for all Members. |
|
TOTCAPINTROYTD |
The sum of the MEMBERCONTRIB BT’s in the Member’s CONTRIBUTION account with a Transaction Date greater than or equal to the report From Date and less than or equal to the Report To Date for all Members. |
|
LAST MONTH YEAR |
Month and Year in words of the last month on the reporting period |
|
ACTIVE BENES |
Number of Member’s with a Membership Status of BENEFICIARY as at the report run date linked to the Previous Fund (Participating Employer). |
|
TOT ACTIVE BENES |
Total number of Member’s with a Membership Status of BENEFICIARY as at the report run date. |
|
LASTNEWBUSDATE |
The latest Transaction Date of the MEMBERCONTRIB BT in the Members’ CONTRIBUTION account less than the report To Date for the Members linked to the Previous Fund (Participating Employer). |
For information on the Tags set up for each section refer to
Supplements
Tags
Admin Report
Beneficiary Funds
Note:
If the Pooling Status of the Scheme selected is MAIN UMBRELLA, the system will extract the information per Scheme with a Pooling Status of SUB UMBRELLA linked to the MAIN UMBRELLA Scheme selected and create separate reports per SUB UMBRELLA Scheme.
If a Previous Fund is selected, the system will extract the data for the Memberships linked to the Previous Fund (Participating Employer) selected.
If a Participating Employer is selected, the system will extract the data for the Memberships linked to the Participating Employer (Pay Centre) selected.
Select View to view a list of all of the reports that have been created.
The Admin Report View screen will be displayed.
Select a Template from the drop-down list and click SEARCH.
The system will flow to the Admin Report View screen and display a list of all of the reports created and provide pdf and display hyperlinks in the Action column.
The following columns are displayed:
- Template
- Date Submitted
- Sequence
- Scheme
- Action
The reports will be displayed in descending timestamp order and therefore the full set of reports created for a single admin report will always be displayed together.
When the PDF hyperlink is selected, the system will read the applicable Document Template and display the PDF document as per the Template(s).
For an example refer to
Reports
Admin
Extract Examples
PDF Example
Display
When the Display hyperlink is selected, the system will list the individual PDF documents set up for each section of the report that have been extracted. The information for the extracted Templates will be enabled for export in MS Excel.
The Admin Report View Detail screen will be displayed.
To view an individual PDF document, click the hyperlinked pdf in the Action column.
For an example refer to
Reports
Admin
Extract Examples
Display Example
Select View Queue to view a list of all Reports that are in the queue for processing. The Admin Report Queue screen will be displayed.
The following columns are displayed:
- Queue #
- Date Submitted
- User ID
- Report Date From
- Report Date To
- Status
- Action
To cancel a report, click the hyperlinked Cancel in the Action column.