alongside Switches Report. Additional menu options will be displayed.This report provides an extract of all investment switches in order to ascertain the volume of investment switches processed. This report is summarized according to specific report criteria and extracted across all schemes.
Note:
This report is only available as a MI Monthly report. The report criteria allow for the definition of any reporting period.
Click alongside Switches Report. Additional menu options will be displayed.
To create a new report, select New from the sub-menu on the left. The Switch Report screen will be displayed.
This screen provides for the specification of report criteria. Capture data as follows:
|
Team |
The code identifying a Team.
Select a value from the drop-down list.
The capture of a value for this field is mandatory. |
|
From Date |
The date from which the data must be extracted.
The capture of a value for this field is mandatory.
Note: The From Date must not be greater than the To Date minus 12 months or, if no To Date is captured, greater than the current date minus 12 months. |
|
To Date |
The date to which the data must be extracted.
The capture of a value for this field is optional.
Note: The From Date must not be greater than the To Date minus 12 months or, if no To Date is captured, greater than the current date minus 12 months. |
|
Scheme |
Code that identifies the scheme. e.g. 1962, Afterwork, etc.
Click the LIST button to display the Scheme Selection page at the bottom of the screen, and select a scheme.
The capture of a value for this field is mandatory. |
|
Sell Portfolio |
The identifier of the Sell Portfolio.
Click the LIST button to display the Investment Portfolio's page at the bottom of the screen, and select a Portfolio.
The capture of a value for this field is optional. |
|
Buy Portfolio |
The identifier of the Buy Portfolio.
Click the LIST button to display the Investment Portfolio's page at the bottom of the screen, and select a Portfolio.
The capture of a value for this field is optional. |
|
Request Method |
The Media Type that the switch was requested by. Select one of the following values from the drop-down list: BULK LIFECYCLE MEMBER WEB
The capture of a value for this field is optional. |
|
Gender |
Select one of the following Gender values from the drop-down list: BOTH MALE FEMALE
The capture of a value for this field is optional. |
|
From Age |
Define an age band by capturing a From Age and a To Age.
Any age band 'from' and 'to' can be selected e.g. 18-20, 18-65, etc.
The capture of a value for this field is optional. |
|
To Age |
Define an age band by capturing a From Age and a To Age.
Any age band 'from' and 'to' can be selected e.g. 18-20, 18-65, etc.
The capture of a value for this field is mandatory. |
|
Post Code |
The postal code applicable. |
|
|
The email address to which notification of the availability of the Report must be sent.
The capture of a value for this field is optional. |
Once all of the necessary report criteria have been captured, click GENERATE REPORT. Switching details will be extracted as per the criteria selected.
The following table sets out what is extracted per the criteria specified:
|
Criteria Selected |
Switching details extracted |
|
Team |
All of the switches will be extracted for the Schemes linked to the Team selected and matching all of the other criteria captured or selected. |
|
To Date |
If a To Date is captured, the system will find all of the switches for which the Transaction Date is greater than or equal to the From Date captured and less than or equal to the To Date and matching all of the other criteria.
If a To Date is not captured, then the system will find all of the switches for which the Transaction Date is greater than or equal to the From Date captured and less than or equal to current date and matching all of the other criteria. |
|
Scheme
|
If a Scheme is selected, the system will find the switches for the Scheme selected and matching all of the other criteria.
If a Scheme is not selected, the system will find all switches matching all of the other criteria. |
|
Sell Portfolio
|
If a Sell Portfolio is selected, the system will find all of the switches for which the Portfolio on the Switching Detail are equal to the Portfolio selected and matching all of the other criteria.
If a Sell Portfolio is not selected, the system will find all of the switches matching all of the other criteria. |
|
Buy Portfolio
|
If a Buy Portfolio is selected, the system will find all of the switches for which the Portfolio on the Buy Switching Detail is equal to the Portfolio selected and matching all of the other criteria.
If a Buy Portfolio is not selected, the system will find all of the switches matching all of the other criteria. |
|
Request Method
|
If a Request Method is selected, the system will find all of the switches for which the Request Method on the Switching Detail is equal to the Request Method on the Switching Detail and matching all of the other criteria.
If a Request Method is not selected, the system will find all of the switches matching all of the other criteria. |
|
Gender
|
If a Gender is selected, the system will find all of the switches for which the Gender of the Member is equal to the Gender selected and matching all of the other criteria.
If a Gender is not selected, the system will find all of the switches matching all of the other criteria. |
|
From Age
To Age |
If a From Age and a To Age is captured, the system will find all of the switches for which the age of the Member is greater than or equal to the From Age and less than or equal to the To Age and matching all of the other criteria.
If no From Age and To Age is captured, the system will find all of the switches matching all of the other criteria. |
|
Postcode
|
If a Postcode is captured, the system will find all of the switches for the Members for which the Postal Code on their Residential Address is equal to the Postcode captured and matching all of the other criteria.
If a Postcode is not captured, the system will find all of the switches matching all of the other criteria. |
When GENERATE REPORT is selected, the following will be displayed at the bottom of the screen.
A message will confirm that the report job has been submitted successfully.
When the investment switches report has completed, an e-mail will be sent to the person whose e-mail address has been captured, notifying them that the report has completed.
To view the completed investment switches report, select View from the sub-menu on the left.
The Report Selection screen will be displayed.
The following columns will be displayed:
- Scheme Code
- Date Captured
- Report Type
- Sequence Number
- Action
To view an investment switches report, click the display hyperlink in the Action column alongside the required report.
The Report Selection screen will display the investment switches summary report.
The following columns will be displayed:
- Scheme Code
- Sell Portfolio
- No of Switches
- Value
- Buy Portfolio
- No of Switches
- Value
- Request Method
- No of Switches
- Value
- Gender
- No of Switches
- Value