VALUATIONVALUE

Use the VALUATIONVALUE type to retrieve a value from the math valuation object created by a MathValuation MathStatement.  This should only be used in transaction math, and not attached rules or screen math.

VALUATIONVALUE Elements/Attributes
TYPE=VALUE
Element Element Value Attributes Attribute Value

<MathVariable>

Valuation data element (e.g. Units, CashValue). Predefined list of values based on ValuationType

 

 

 

VARIABLENAME

Literal text string.

Required. Name of the math variable.

 

TYPE

VALUATIONVALUE

Required.

 

VALUATIONTYPE

Literal text string, one of the following: POLICY, POLICYVALUE, FUND, DEPOSIT, BUCKET

Required. Defines the type of valuation data to return.

POLICY:Indicates that the value to return is from the policy valuation (as done in activity valuation using Valuation:Policy:…).

POLICYVALUE: Indicates that the value to return is from the PolicyValues rule (as done in activity valuation using Valuation:PolicyValues:…).

FUND: Indicates that the value to return is related to a specific fund GUID (as done in activity valuation using Valuation:Fund:…).

DEPOSIT: Indicates that the value to return is related to a specific valuation GUID. (as done in activity valuation using Valuation:Deposit:…).

BUCKET: Indicates that the value to return is related to a specific fund GUID and bucket (as done in activity valuation using Valuation:Fund:[FundGUID]:Bucket:…).

 

 

CONTEXT

MATH

Required. Defines the valuation object to retrieve the data from.

 

FUNDGUID

Named math variable that is a Text data type containing a FundGUID.

Required if the valuation type is FUND or BUCKET. Defines the GUID of the Fund in the math valuation object.

 

VALUATIONGUID

Named math variable that is a Text data type containing a ValuationGUID.

Required if the valuation type is DEPOSIT. Defines the GUID of the Deposit in the math valuation object.

 

BUCKETNUMBER

A math variable containing an integer value

Required if valuation type is BUCKET. Defines the bucket number to retrieve the data from. Ignored by other valuation types.

 

DEFAULT

A literal value.

Optional. Sets a default value in case the returned valuation is null

 

DATATYPE

Required. Defines the math variable data type. Must equal that of the data being retrieved from the valuation source.


XML Examples

<MathVariable VARIABLENAME="PolicyValueX" TYPE="VALUATIONVALUE" CONTEXT="MATH"   
VALUATIONTYPE="POLICY" DATATYPE="DECIMAL">CashValue</MathVariable>
 
<MathVariable VARIABLENAME="MyFundGUID" TYPE="SQL" DATATYPE="TEXT">SELECT FundGUID FROM…</MathVariable>
<MathVariable VARIABLENAME="FundGUIDUnitsX" TYPE="VALUATIONVALUE" CONTEXT="MATH"   
VALUATIONTYPE="FUND" FUNDGUID="MyFundGUID" DATATYPE="DECIMAL"">Units</MathVariable>
 
<MathVariable VARIABLENAME="MyBucketNumber" TYPE="SQL" DATATYPE="INTEGER">SELECT Bucket FROM…</MathVariable>
<MathVariable VARIABLENAME="FundGUIDUnitsX" TYPE="VALUATIONVALUE" CONTEXT="MATH" VALUATIONTYPE="BUCKET" 
FUNDGUID="MyFundGUID" BUCKETNUMBER="MyBucketNumber" DATATYPE="DECIMAL"">Units</MathVariable>
 
<MathVariable VARIABLENAME="MyDepositGUID" TYPE="SQL" DATATYPE="TEXT">SELECT ValuationGUID FROM…</MathVariable>
<MathVariable VARIABLENAME="DepositValueX" TYPE="VALUATIONVALUE" CONTEXT="MATH"   
VALUATIONTYPE="DEPOSIT" VALUATIONGUID="MyDepositGUID" DATATYPE="DECIMAL"">Amount</MathVariable>

 

 

 

 

Oracle Insurance Logo Copyright © 2017, Oracle and/or its affiliates. All rights reserved. About Oracle Insurance | Contact Us