Ability to Retrieve Interest Rate

This feature allows for the storage and retrieval of the interest rate for display and use in calculations:

  • Ability to retrieve the interest rates within the activity math with a valuation object.
  • Ability to retrieve the interest rates within the function math that performs a valuation.
  • Ability to retrieve the interest rates within the PolicyValues business rule.
  • Ability to retrieve the interest rates available within the valuation XML.
  • Ability to store the interest rates used for a valuation

Prerequisites

Fixed Fund fund type (01) that utilizes InterestRateCalculation business rules.

New Items

  • StoreFundValuationInterestRate business rule

Changes to Existing Items

  • ValuesScreen business rule

Configuration Details

PolicyValues- Dynamic Prototype Plan

  • Added two math variables; one to define Fixed Fund GUID and one to retrieve Interest Rate
<MathVariable VARIABLENAME="FundGUIDMV" TYPE="SQL" DATATYPE="Text">SELECT FundGUID FROM AsFund WHERE FundName='Dynamic Calc Fund 1'</MathVariable>
<MathVariable VARIABLENAME="InterestRate" TYPE="FIELD" DATATYPE="DECIMAL">Valuation:Fund:FundGUIDMV:CurrentInterestRate</MathVariable>

ValuesScreen - Dynamic Prototype Plan

  • Added a field to display Interest Rate
<Field>
<Name>InterestRate</Name>
<Display>Interest Rate</Display>
<DataType>Decimal</DataType>
<Disabled>Yes</Disabled>
</Field>

StoreFundValuationInterestRates - Dynamic Prototype Plan

  • Added Global override (empty tags)
  • Configured rule to record interest rates in AsValuationInterestRate table when valuation of a Dynamic Prototype Plan policy using a Fixed Fund fund type (Dynamic Calc Fund 1) is performed.
<StoreFundValuationInterestRates>
<FundType TYPECODE="01"></FundType>
</StoreFundValuationInterestRates>