This is a report of all changes to any of the policy details.
From the Audit menu, select Policy Changes from the sub-menu on the left.
Additional options will be displayed.
Click New below Policy Changes. A screen will be displayed, allowing for the capture of report criteria.
Capture data as follows in order to specify the Policy Changes Report:
|
From Date |
The date from which all policy changes must be included in the report.
Mandatory |
|
To Date |
The date to which all policy changes must be included in the report. The system defaults to the current date. |
|
Administrator |
Select an Administrator from the drop-down list.
Mandatory |
|
Administrator Branch |
Select an Administrator Branch from the drop-down list.
Note: An Administrator must be selected first.
Optional |
|
Country |
Select a Country from the drop-down list.
Optional |
|
|
Capture the Email address to which notification of the availability of the completed report must be sent. |
ClickGENERATE 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 you.
When the Generate Report button is selected, the system will find the records for the items in the table below with a Timestamp date greater than or equal to the From Date captured and less than or equal to the To Date captured and for which the Scheme to which the Membership is associated is linked to the Administrator to which the Scheme is linked via the Administrator Branch. If an Administrator Branch is selected, the system will find the records for the Schemes linked to the Administrator Branch selected.
If a Country has been selected, the system will find only the records for which the Country for the Scheme to which the Membership is linked is equal to the Country selected.
|
Item |
Source |
|
Client Full Name |
Find the Audit records for which the Natural Person Surname, Initials or First Names have changed for a Natural Person linked to a Membership for which the Scheme is linked to the Administrator or Administrator Branch selected and for which the Timestamp is greater than or equal to the From Date captured and less than or equal to the To Date captured.
Extract the following: · Timestamp · Previous Surname, Initials and First Names · New Surname, Initials and First Names · User ID |
|
Client ID |
Find the Audit records for which the ID Number has changed for a Natural Person linked to a Membership for which the Scheme is linked to the Administrator or Administrator Branch selected and for which the Timestamp is greater than or equal to the From Date captured and less than or equal to the To Date captured. Extract the following: · Timestamp · Previous Surname, Initials and First Names · New Surname, Initials and First Names · User ID |
|
New Beneficiary Full Name |
Find the Benefit Beneficiary records linked to a Membership for which the Scheme is linked to the Administrator or Administrator Branch selected and for which the End Date is not null. If a record is found find the Benefit Beneficiary record for the same Membership and with a Timestamp after the Timestamp of the record with an End Date and for which the Timestamp is greater than or equal to the From Date captured and less than or equal to the To Date captured. Extract the following for the new record: · New Beneficiary Surname, Initials and First Names · Timestamp · User ID |
|
New Beneficiary ID |
For the new Benefit Beneficiary records found for New Beneficiary Full Name above extract the ID Number for the new record. |
|
Account Holder |
Find the DTI Accounts linked to a Membership for which the Scheme is linked to the Administrator or Administrator Branch selected and for which there is a previous record and for which the Timestamp of the new record is greater than or equal to the From Date captured and less than or equal to the To Date captured. Compare the records and if the value for Name is different extract the Name on the latest record. |
|
Bank Name |
Find the DTI Accounts linked to a Membership for which the Scheme is linked to the Administrator or Administrator Branch selected and for which there is a previous record and for which the Timestamp of the new record is greater than or equal to the From Date captured and less than or equal to the To Date captured. Compare the records and if the Bank to which the record is linked is different extract the Name of the Bank linked to the latest record. |
|
Bank Account Number |
Find the DTI Accounts linked to a Membership for which the Scheme is linked to the Administrator or Administrator Branch selected and for which there is a previous record and for which the Timestamp of the new record is greater than or equal to the From Date captured and less than or equal to the To Date captured. Compare the records and if the value for DTI Account Number is different extract the DTI Account Number on the latest record. |
If a value is extracted for Account Holder, Bank Name or Account Number, the system will retrieve the Business Transactions (BT’s) in the Fund’s accounts for which the value for DTI Account is equal to the Account Number of the new DTI Account record and for which the Membership to which the BT is linked is equal to the Membership to which the DTI Account record is linked.
The information in the table below will be extracted for each of the changed records found for each Membership.
|
Item |
Value/Source |
|
Client Full Name |
Surname and First Name of Member prior to the change |
|
Changed Client Full Name |
Surname and First Name of Member after the change |
|
ID |
ID Number of Member prior to the change |
|
Changed Client ID |
ID Number of Member after the change |
|
Policy number |
Membership Reference Number of Member |
|
Name of the Sales Agent |
Name of the Intermediary to which the Membership is linked |
|
Sales Agent Code |
Code of the Intermediary to which the Membership is linked |
|
Product name |
Scheme Name |
|
Change in Beneficiary (Y/N) |
If a value is extracted for New Beneficiary Full Name set this to Y else N |
|
New Beneficiary Full Name |
Surname and First Name of the Natural Person to which the Benefit Beneficiary record is linked |
|
New Beneficiary ID |
ID Number of the Natural Person to which the Benefit Beneficiary record is linked |
|
Name of the account holder |
Name on the previous DTI Account |
|
Changed Account Holder Name |
Name on the new DTI Account |
|
Old Bank Name |
Name of Bank to which the previous DTI Account is linked |
|
Old Bank Account Number |
DTI Account Number on the previous DTI Account |
|
New Bank Name |
Name of Bank to which the new DTI Account is linked |
|
New Bank Account Number |
DTI Account Number on the new DTI Account |
|
Date of change |
Timestamp of change or new record |
|
User ID |
User ID of the user that made the change. |
The information in the table below will be extracted for each of the BT’s retrieved from the Fund’s BANK account.
|
Item |
Value/Source |
|
Date of transaction |
Transaction Date on the Business Transaction (BT) |
|
Amount |
Amount on the BT |
|
Type of Payment |
If the Process is BENEFIT PAYMENT extract the Event on the BT else, extract the Process. |
The changes will be grouped per Membership and the report will be created with one line per Membership unless there are multiple changes of the same item for the Membership, in which case a new row will be created with all of the Membership details but just the displaying the changed item. (This is most likely in cases where there are multiple payments for the Membership).
Click View below Policy Changes. The Report Selection screen will be displayed.
Note:
The report will only be enabled for viewing if the user has access to the Administrator Branch for which the report was extracted. The system will check whether the user is linked to a Team that is linked to a Scheme linked to the Administrator Branch.
The following columns are displayed:
- Timestamp
- Period Start Date
- Period End Date
- Report Type
- Report Sequence Number
- Action
To select a report, click on the hyperlinked display in the Action column alongside the appropriate report.
The Report Selection will be displayed.
The following columns are displayed:
|
Item |
Value/Source |
|
Client Full Name |
Surname and First Name of Member prior to the change |
|
Changed Client Full Name |
Surname and First Name of Member after the change |
|
ID |
ID Number of Member prior to the change |
|
Changed Client ID |
ID Number of Member after the change |
|
Sales Agent |
Code of the Intermediary to which the Membership is linked |
|
Product name |
Scheme Name |
|
Change in Beneficiary (Y/N) |
If a value is extracted for New Beneficiary Full Name, this will be set to Y, otherwise it will be set to N |
|
New Beneficiary Full Name |
Surname and First Name of the Natural Person to which the Benefit Beneficiary record is linked |
|
New Beneficiary ID |
ID Number of the Natural Person to which the Benefit Beneficiary record is linked |
|
Beneficiary Fund |
Fund Code of the Natural Person to which the Benefit Beneficiary record is linked. |
|
Beneficiary Member Ref |
Membership Reference Number of the Member |
|
Current Bank Account Holder |
Name on the previous DTI Account |
|
Bank Upd Type |
The type of update performed. E.g. Create. |
|
Old Bank Name |
Name of Bank to which the previous DTI Account is linked |
|
Old Bank Account Number |
DTI Account Number on the previous DTI Account |
|
New Bank Name |
Name of Bank to which the new DTI Account is linked |
|
New Bank Account Number |
DTI Account Number on the new DTI Account |
|
Date of change |
Timestamp of the change or new record |
|
User ID |
User ID of the user that made the change. |
|
Date of transaction |
Transaction Date on the Business Transaction (BT) |
|
Accounting Transaction Date |
Accounting Transaction Date on the Business Transaction (BT) |
|
Amount |
Amount on the BT |
|
Type of Payment |
If the Process is BENEFIT PAYMENT, the Event on the BT will be extracted; otherwise the Process will be extracted. |