You are here: Configuration > Valuation > Valuation Configuration > Configure the Plan's Funds

Configure the Plan’s Funds

Funds must be set-up prior to configuring valuation calculations specific to the company’s business requirements. See the Funds section for details on entering funds into OIPA. There are different sets of steps according to what type of funds you are configuring.

Fixed Funds

If using fixed funds, complete the following steps.

Configure the interest rate via the InterestRateCalculation rule.
Make sure the interest rate is added to the system if it will be looked-up by the InterestRateCalculation rule.

Interest Rate Logic

The InterestRateCalculation rule supports interest calculation. It supports guaranteed interest calculations, bonus interest calculations, current interest calculations, compound interest, simple interest, leap year methods, numerator calculation methods and previous day valuation.

Steps to Configure Interest Rate Calculation

Navigate to the Global Rules Explorer.
Expand the Business Rule folder.
Expand the System folder.
Right-click on InterestRateCalculation.
Select New InterestRateCalculation Override. The Override Wizard opens.
Select the Next button for step one.
Select the company, plan and fund where this override should be used.
Select Finish.
Configure your interest logic in the XML Source Pane of the override of the InterestRateCalculation that was created. View the V9 XML Configuration topic in this help system for additional information. View Business Rules | System Rules | InterestRateCalculation.

Interest Rate Calculation

InterestRateCalculation Rule in Main Explorer

Interest Rate to be used with the Fund

In addition to configuring the logic for the interest rate calculation you must also ensure there is an interest rate for the fund to use. In the InterestRateCalculation rule you can enter it OR you can retrieve it from AsRate via the AsRateGroup name. If you decide to retrieve the rate from the rate tables, please see the Rates section for details on uploading rates via RateGroups in the Admin Explorer.

Variable Funds

If using variable funds, complete the following steps.

Verify that the AsNetAssetValue table has unit values for funds to use.
Configure the UnitValuePrecision rule.

Step 1: Verify the AsNetAssetValue Table

A very important part of this is the price of a fund unit at a specific point in time. The AsNetAssetValue table stores the unit values for the various funds. If you configured funds whose value varies due to market conditions, then those values must be stored in the AsNetAsset table according to dates.

To update the database manually use an INSERT statement.

Example of a Manual SQL Statement
INSERT INTO AsNetAssetValue (NetAssetValueGUID,FundGUID,EffectiveDate,NetAssetValue,UnitValue,Dividend,MortalityandExpense) VALUES (newid(),'054BD142-1AD5-7074-5E67-68EA40C405FD', '7/23/2030',11,11,0,0)

The Files administration functionality allows you to select, transform and upload incoming data and insert it directly into the OIPA database. Please see the Files section for additional information on how to configure.

You can review the Funds data model to see how the NetUnitValues are associated.

As Fund and AsNetAssetValue tables

Step 2: Configure the UnitValuePrecision Rule

The UnitValuePrecision rule is used to determine the number of digits allowed after the decimal point of a unit. This allows you to display the proper unit value to the OIPA user. This rule can also be used to calculate the unit’s precision at accumulation and benefit level by attaching this rule to the transactions that affect benefit. These values are ultimately stored as units in the AsValuation table. If this rule is not configured then the system will revert to a default setting of ten decimal places.

Note: If you want to use the same unit precision, then you can configure the global rule.

Steps to Configure Unit Value Precision

Navigate to the Global Rules Explorer.
Expand the Business Rule folder.
Expand the System folder.
Right-click UnitValuePrecision.
Select New UnitValuePrecision override. The Override Wizard will open.
Select Next for step one.
Select the level you want the unit precision to apply to.
Select Finish.
Configure the unit precision value in the XML Source Pane of the override of the UnitValuePrecision that was created. View the V9 XML Configuration topic in this help system for additional information. View Business Rules | System Rules | UnitValuePrecision.

Unit Value Precision business rule in Global Rules Explorer

UnitValuePrecision Rule in Global Rules Explorer