Enhancements to Allocation Screens
OIPAnow supports the ability to filter the funds available on the Allocation screen using SQL queries. Criteria that must be satisfied for the funds to be available on the Allocation screen can be grouped with logical "and" and "or" relationships.
The 'TransactionAllocationScreen' BR and 'PolicyAllocationScreen' BR supports section-wise Remove /Show or Enable/Disable of either 'Funds' or 'Models' section as desired. Also, the Models' section in the BR support filtering of Models.
Prototype Prerequisites
- The policy must belong to a plan with the Plan Allocation Method set to “Model Supported.”
- The funds in the table below must be attached to the plan.
- The policy must be in pending status in the Model Prototype Plan.
- The default "Dollar Cost Averaging Program" should exist for the policy in order to process all the transactions.
Fund Name | Fund Code | Redemption Factor | Redemption Fee | Redemption Duration |
---|---|---|---|---|
BigPlus Equity Income |
320 |
8 | ||
Finlux Diversified Bond | 230 | 3 | Yes | 4 |
GS Dynamic Equity | 800 | 5 | No | 6 |
BigPlus China Fund | 100 | 1 | Yes | 2 |
Money Market Fund | 900 | 7 | No | 8 |
GS Midcap Value | 700 |
Prototype Explanation
The following business rules and transactions were configured in the Model Prototype Plan, located within the Prototype Company, to demonstrate this new functionality.
Business Rules
PolicyAllocationScreen: This business rule controls the available allocation types on the policy-level Allocation screen. To view the prototype configuration, navigate in the Main Explorer to Main Explorer to, Companies | Prototype Company | Subsidiary Companies | Prototype individual Child Company | Products |Individual Prototype Product|Plans | Standard Allocation Prototype| Plan Rules | PolicyAllocationScreen and click on the XMLSource pane. The key configuration for this transaction is explained below.
The following allocation types and their supporting configuration are made available by this rule:
- AIPFrom Fund (Allocation TypeCode = 13)
- An ONLOAD event is configured to show or hide the "From" section of the Allocation screen based on the value of the PlanDate policy fixed field. If PlanDate's value is before SystemDate's value, the "From" section will display.
- Systematic Withdrawal Program (Allocation TypeCode = 11)
- Both the "From" and "To" sections of the Allocation screen are available for user entry.
- ASQLquery (configured in the <Query> element) is configured to return a single fund for both the "From" and "To" sections. The fund that has the following fund dynamic field values will display:
- FundCode with value of "100"
- RedemptionFactor with value of "1"
- RedemptionFee with value of "Yes"
- Dollar Cost Averaging Program (Allocation TypeCode = 14)
- Both the "From" and "To" sections of the Allocation screen are available for user entry.
- For the "From" allocation, the list of funds is filtered based on the fund fields and their values listed below. The individual criteria are joined together using an <And> element.
- FundName with a value of "BigPlus ChinaFund," "Finlux Diversified Bond," "GSDynamic Equity" or "Money Market Fund"
- FundCode with a value of "100"
- RedemptionFee with a value of "No"
- RedemptionDuration with a value of "4"
- For the "To" allocation, the list of funds is first filtered based on the criteria in the <FundFields> element, then on the criteria in the <FundStatuses> element. Funds that satisfy the following criteria will be returned:
- FundName with a value of "BigPlus China Fund," "Finlux Diversified Bond," "GSDynamic Equity" or "Money Market Fund"
- Active funds
- Automatic Investment Plan (Allocation TypeCode = 16)
- Both the "From" and "To" sections of the Allocation screen are available for user entry.
- For the "From" allocation, the list of funds is filtered based on the fund fields and their values listed below. The individual criteria are joined together using an <Or> element.
- FundName with a value of "Finlux Emerging Market Fund"
- TypeCode with a value of "01"
- Redemption Factor with a value of "3"
- Redemption Fee with a value of "Yes"
- Redemption Duration with a value of "8"
- For the "To" allocation, the list of funds is first filtered based on the criteria in the <FundFields> element (which contains a combination of <And> and <Or> elements), then on the criteria in the <FundStatuses> element. Funds that satisfy the following criteria will be returned:
- Within the <And> element of configuration, FundName with a value of "BigPlus China Fund," "Finlux Diversified Bond," "GSDynamic Equity" or "Money Market Fund"
- Within the <Or> element of configuration, FundName with a value of "GSMidCapValue" or "GSLarge Value"
- FundCode with a value of "700"
- Active funds
- Standard Allocation Prototype override includes:
- A new AllocationType TypeCode=51, Original Benefit, to showcase Action Type="Show" and "Remove" on Allocation ID.
- A new AllocationType TypeCode=100, Conversion Premium, to showcase Action Type="Show" and "Remove" on Fund ID, the <Models> tag has been configured with element <Or> as a child to <ModelFields>.
- A new AllocationType TypeCode=102, Conversion Interest, has been configured, to showcase Action Type="Show" and "Remove" on Model ID.
- Existing EligibleTransactionsByPolicyStatus BR override for Standard Allocation Prototype plan has been updated to include transaction AllocationFundsModelIDSupport.
TransactionAllocationScreen: This business rule drives the Allocation tab for activity allocations to capture the functionality for allocation models and funds. An override of TransactionAllocationScreen BR has been created for this transaction and configured with Action Type="Remove", "Show", "Enable" and "Disable".
To view the prototype configuration, navigate in the Main Explorer to Global Rules Explorer | Business Rules | Screen | TransactionAllocationScreen | Transaction Overrides and click on the XMLSource pane. This business rule is attached to the following transactions for the purposes of this prototype:
- AllocationsTransferPrototype
- AllocationSqlFilterPrototype
- AllocationsFieldFilterAndPrototype
- AllocationsFieldFilterOrPrototype
Transactions
- AllocationsTransferPrototype: This transaction will display either both allocation sections ("From" and "To") on the Allocation tab of the activity, or the "To" section only depending on the value of the SourceAllocationType activity field, and is configured to return multiple funds for both "From" and "To" allocations. To view the prototype configuration, navigate in the Main Explorer to Companies | Prototype Company | Subsidiary Companies | Prototype ChildCompany | Plans | Model Prototype Plan | Transactions | AllocationsTransferPrototype. The key configuration for this transaction is described below.
- The SourceAllocationType combo box field is configured to have the values "Auto Transfer" and "Manual Transfer" available for selection.
- The TransactionAllocationScreen business rule is attached, and is configured to perform the following functions:
- Populate the details of the default policy-level Dollar Cost Averaging allocation to the Allocation tab of the activity.
- Display or hide the "From" allocation section on the Allocation tab based on the value of the SourceAllocationType field. If the field has a value of "AutoTransfer," only the "To" allocation section will display; if the field has a value of "Manual Transfer," both the "From" and "To" sections will display.
- Retrieve multiple funds for both the "From" and "To" allocations' fund lists.
- The ReassignAllocations business rule is attached, and is configured to provide the data for the "From" allocation section of an activity.The rule is additionally configured as follows:
- The rule is only invoked when the SourceAllocationType activity field is set to "Auto Transfer" using the TransactionBusinessRulePacket business rule.
- The <From> section of configuration is configured to retrieve the default allocation (i.e. Dollar Cost Averaging) details that exist at the policy level.
- The <To> section of configuration is configured to retrieve the fund details that exist at the activity level.
- AllocationsSqlFilterPrototype: This transaction is configured to filter its lists of available funds based on a SQLquery defined in the attached TransactionAllocationScreen business rule. To view the prototype configuration, navigate in the Main Explorer to Companies | Prototype Company | Subsidiary Companies | Prototype ChildCompany | Plans | Model Prototype Plan | Transactions | AllocationsSqlFilterPrototype. The key configuration for this transaction is described below.
- Both the "From" and "To" allocation sections on the Allocation tab of the activity will be populated according the <Query> element of the attached TransactionAllocationScreen business rule.
- The TransactionAllocationScreen business rule is attached, and is configured to perform the following functions:
- Populate the details of the default policy-level Dollar Cost Averaging allocation to the Allocation tab of the activity.
- Filter the list of funds for both the "From" and "To" allocations available to the activity. Only funds that satisfy the following criteria will be available:
- FundCode with a value of "100"
- RedemptionFactor with a value of "1"
- RedemptionFee with a value of "Yes"
- AllocationsFieldFilterAndPrototype: This transaction is configured as described below. To view the prototype configuration, navigate in the Main Explorer to Companies | Prototype Company | Subsidiary Companies | Prototype ChildCompany | Plans | Model Prototype Plan | Transactions | AllocationsFieldFilterAndPrototype.
- The "From" allocation fund list is populated according to the criteria configured in the <FundFields> element of the attached TransactionAllocationScreen business rule.
- The "To" allocation fund list is populated according to the <Query>, <FundFields> and <FundStatuses> elements of the attached TransactionAllocationScreen business rule.
- Only one fund will be retrieved for both the "From" and "To" allocations' fund lists.
- The TransactionAllocationScreen business rule is attached, and is configured to perform the following functions:
- Populate the details of the default policy-level Dollar Cost Averaging allocation to the Allocation tab of the activity.
- Add/modify the funds available within the "From" and "To" allocation sections, and filter them as described below:
- "From" allocation:
- Fund filtering will be performed based on the fund field values listed below. These criteria are configured in the <FundFields> element, and are combined by an <And> element.
- FundName with a value of "Big Plus China Fund," "Finlux Diversified Bond," "GS Dynamic Equity" or "Money Market Fund"
- FundCode with a value of "100"
- RedemptionFee with a value of "No"
- RedemptionDuration with a value of "4"
- Fund filtering will be performed based on the fund field values listed below. These criteria are configured in the <FundFields> element, and are combined by an <And> element.
- "To"allocation:
- The fund list is first filtered based on the criteria configured in the <FundFields> element—only funds with a Fund Name of "Big Plus China Fund," "Finlux Diversified Bond," "GS Dynamic Equity" or "Money Market Fund" will be available.
- The fund list is then filtered again based on the <FundStatuses> element—only active funds will be available.
- "From" allocation:
- AllocationsFieldFilterOrPrototype: This transaction is configured as described below. To view the prototype configuration, navigate in the Main Explorer to Companies | Prototype Company | Subsidiary Companies | Prototype ChildCompany | Plans | Model Prototype Plan | Transactions | AllocationsFieldFilterOrPrototype.
The "From" allocation fund list is populated according to the criteria configured in the <FundFields> element of the attached TransactionAllocationScreen business rule.
- The "To" allocation fund list is populated according to the <Query>, <FundFields> and <FundStatuses> elements of the attached TransactionAllocationScreen business rule.
- Multiple funds will be retrieved for both the "From" and "To" allocations' fund lists.
- The TransactionAllocationScreen business rule is attached, and is configured to perform the following functions:
- Populate the details of the default policy-level Dollar Cost Averaging allocation to the Allocation tab of the activity.
- Add/modify the funds available within the "From" and "To" allocation sections, and filter them as described below:
- "From" allocation:
- Fund filtering will be performed based on the fund field values listed below. These criteria are configured in the <FundFields> element, and are combined by an <Or> element.
- FundName with a value of "Finlux Emerging Market Fund"
- TypeCode with a value of "01"
- RedemptionFactor with a value of "3"
- RedemptionFee with a value of "Yes"
- RedemptionDuration with a value of "8"
- Fund filtering will be performed based on the fund field values listed below. These criteria are configured in the <FundFields> element, and are combined by an <Or> element.
- "To"allocation:
- The fund list is first filtered based on the criteria configured in the <FundFields> element as described below.
- The following fund field criteria are configured in the <And> element:
- FundName with a value of "BigPlus China Fund"/"Finlux Diversified Bond"/"GSDynamic Equity"/"Money Market Fund"
- The following fund field criteria are configured in the <Or> element:
- FundName with a value of "GSLarge Value"/"GSMidCap Value"
- FundCode with a value of "700"
The fund list is then filtered again based on the <FundStatuses> element—only active funds will be available.
- The following fund field criteria are configured in the <And> element:
- The fund list is first filtered based on the criteria configured in the <FundFields> element as described below.
- "From" allocation:
- AllocationFundsModelIDSupport: This is a Policy-Financial transaction 'AllocationFundsModelIDSupport' that has been configured under Standard Allocation Prototype plan. A check field has been added to the transaction 'RemoveToAllocation', with default value being unchecked. OnChange Event has been configured on this field. ActionType CallExternalEvent has been configured.
- An override of TransactionAllocationScreen BR has been created for this transaction and configured such that on checking the activity field, in Allocations tab, From Allocations section, Funds become disabled and ToAllocations section is removed since Funds and Models are removed. On unchecking the field, these changes are reverted, Enable and Show ActionType being performed and the user can select the desired values.
- Existing EligibleTransactionsByPolicyStatus BR override for Standard Allocation Prototype plan has been updated to include transaction AllocationFundsModelIDSupport.
Details of change and description of impact: Security has been granted to transaction 'AllocationFundsModelIDSupport' under Prototype Super Security Group.
View Prototype in OIPA
- Log in to OIPA using the Prototype Company user ID and password.
- Open a policy in "Pending" status or create a new policy. The policy should belong to a plan that uses the Model Supported Plan allocation type. If creating a new policy, the PremiumWithAllocation activity can be used to apply the premium to multiple funds.
- View the functionality configured for the above types of fund allocation types in two sets of screens, i.e. Policy Allocation Screen & Transaction Allocation Screen.