Valuation Tables
Valuation records for unit linked funds are slightly different than other types of funds. When processing an activity that deals with unit linked funds the PriceDate and Gain/Loss Price Date columns are populated with the date derived from the NuvOffSet rule configuration. There are also other columns that can be used to calculate gain/loss, bare spread and currency conversions. See the table below, which describes the AsValuation table with unit linked funds valuing
|
Column |
Type |
Description |
|---|---|---|
|
ValuationGUID |
UniqueIdentifier |
Key |
|
FundGUID |
UniqueIdentifier |
Fund link |
|
PolicyGUID |
UniqueIdentifier |
Policy link |
|
ActivityGUID |
UniqueIdentifier |
Activity link |
|
EffectiveDate |
Date |
Activity that creates the unit deal effective date |
|
ActiveFromDate |
Date |
System date of creation |
|
ActiveToDate |
Date |
If reversed, system date of reversal |
|
ValuationAmount |
Number (19,4) |
Amount dealt: blank if units are known and unit deal is incomplete or NUV not known. |
|
ValuationUnits |
Number (18,10) |
Units dealt: blank if amount is known and unit deal is incomplete or NUV not known. Calculated from the funds currency amount divided by the unit value. |
|
ValuationGainLoss |
Number (19,4) |
Gain loss if unit deal date date and guarantee date are different. |
|
GainLossShadow |
Number (19,4) |
Gain loss on reversal |
|
PriceDate |
Date |
Guarantee date is the date used for calculating valuation units or amount. |
|
GainLossPriceDate |
Date |
Unit deal date which is used for calculating valuation gain or loss for the company. |
|
ShadowGainLossPriceDate |
Date |
Reversal unit deal date |
|
BareSpreadAmount |
Number (19,4) |
Amount that is a difference |
|
FundCurrencyAmount |
Number (19,10) |
If different from default, currency amount for the unit deal. It is the valuation amount in the funds currency and it uses the PriceDate. |
|
CurrencyConversionCost |
Number (19,10) |
For buys, the ”r;leak” that is paid to the market maker. It is the difference of the valuation amount and the valuation amount in the plan’s currency. Using the bare unit value from the net asset unit value record it calculates an exchanged bare value from the valuation units. |
