MathStatement Element

A MathStatement is a predefined hybrid function that can be used during assignment processing for unit linked funds. The functions can find last known fund prices or the next exchange date fund price, when calculating valuation units and amounts. Existing functions include:

In order to process unit linked funds, assignment will require that one of these functions exist in Math.

ClassMembership

TYPE=ClassMembership
Element Attribute Element/Attribute Value and Description Definition
<MathStatement>     Opening element for math variable
  TYPE ACIVITYFUNCTION Required: Defines the math statement type
  FUNCTIONNAME ClassMembership Required: Defines the function to run
<Parameters>     Required: Opening element of the parameters.
<Parameter>     Required: Defines the parameters for the function
  NAME ClassGroupArray Required: Defines the parameter to assign the value. A math variable holding an array of ClassGroupGUIDs for the Data Intake record.
  TYPE INPUT Required: Defines if the parameter is either input or output for the function.
<Parameter>     Required: Defines the parameters for the function
  NAME ClassGUIDArray Optional: Defines the parameter to assign the value. A math variable holding the an array of ClassGUIDs for the Data Intake record.
  TYPE OUTPUT Optional: Defines if the parameter is either input or output for the function

XML Schema

<MathStatement TYPE="ACTIVITYFUNCTION" FUNCTIONNAME="ClassMembership">
<Parameters>
<Parameter NAME="ClassGroupArray" TYPE="INPUT">[Array of Class GroupGUIDs]</Parameter>
<Parameter NAME="ClassGUIDArray" TYPE="OUTPUT">[MathVariable Array]</Parameter>
</Parameters>
</MathStatement>

FindBillDetail

TYPE=FindBillDetail
Element Attribute Definition Element/Attribute Value and Description
<MathStatement>   Opening element for math variable  
  TYPE Required attribute:Defines the math statement type

"ACTIVITYFUNCTION"

 

FUNCTIONNAME

Required attribute:Defines the function to run value

"FINDBILLDETAIL"

<Parameters>

  Opening element of the parameters  

<Parameter>

 

Required attribute:Defines the parameter of the function

A field or math variable containing a date

NAME

Required attribute:Defined input name.

"StartDate"

TYPE

Required attribute:Defines if the parameter is either input or output for the function

"INPUT"

<Parameter>

 

Defines the parameters for the function

A field or math variable containing a date

NAME

Required attribute:Defines the parameter to assign the value.

"EndDate"

TYPE

Required attribute:Predefined MathVariable Type.

"INPUT"

<Parameter>

 

Defines the parameters for the function.

 

NAME

Required attribute: Defines the parameter to assign the value.

A field or math variable containing a "BillGroupGUID"

TYPE

Required attribute:Defines if the parameter is either input or output for the function.

"INPUT"

<Parameter>

 

Defines the parameters for the function.

A field or math variable containing a currency amount

NAME

Required attribute:Defines the parameter to assign the value

"BillMinimumAmountThreshold"

TYPE

Required attribute:Defines if the parameter is either input or output for the function

"INPUT"

<Parameter>

 

Defines the parameters for the function

A field or math variable containing a currency amount

NAME

Required attribute: Defines the parameter to assign the value.

"BillMaximumAmountThreshold"

TYPE

Required attribute:Defines if the parameter is either input or output for the function.

"INPUT"

<Parameter>

 

Defines the parameters for the function.

A field or math variable containing a string array

NAME

Required attribute: Defines the parameter to assign the value.

"BillDetailArray"

TYPE

Required attribute:Defines if the parameter is either input or output for the function.

"OUTPUT"

<Parameter>

 

Optional: Defines the parameters for the function (output parameters are optional)

A field or math variable containing a string array

NAME

Required attribute:Defines the parameter to assign the value “BillDetailPolicyGUIDArray”

TYPE

Optional attribute: Defines if the parameter is either input or output for the function

“OUTPUT”
<Parameter>  

Optional:Defines the parameters for the function (output parameters are optional).

A field or math variable containing a string array.

 

NAME

Required: Defines the parameter to assign the value.

“BillDetailClientGUIDArray”

 

TYPE

Optional:Defines the parameters for the function (output parameters are optional). “OUTPUT”
<Parameter>  

Optional:Defines the parameters for the function (output parameters are optional).

A field or math variable containing a string array.

 

NAME

Required: Defines the parameter to assign the value.

“BillDetailSegmentGUIDArray”

 

TYPE

Optional:Defines the parameters for the function (output parameters are optional). “OUTPUT”

XML Schema

<MathStatement TYPE="ACTIVITYFUNCTION" FUNCTIONNAME="FindBillDetail">
<Parameters>
<Parameter NAME="StartDate" TYPE="INPUT">[Date Field or MathVariable]</Parameter>
<Parameter NAME="EndDate" TYPE="INPUT">[Date Field or MathVariable]</Parameter>
<Parameter NAME="BillGroupGUID" TYPE="INPUT">[Text Field or MathVariable]</Parameter>
<Parameter NAME="BillMinimumAmountThreshhold" TYPE="INPUT">[Amount Field or MathVariable]</Parameter>
<Parameter NAME="BillMaximumAmountThreshhold" TYPE="INPUT">[Amount Field or MathVariable]</Parameter>
<Parameter NAME="BillDetailArray" TYPE="OUTPUT">[Array MathVariable]</Parameter>
<Parameter NAME="BillDetailPolicyGUIDArray" TYPE="OUTPUT">[Array MathVariable]</Parameter>
<Parameter NAME="BillDetailClientGUIDArray" TYPE="OUTPUT">[Array MathVariable]</Parameter>
<Parameter NAME="BillDetailSegmentGUIDArray" TYPE="OUTPUT">[Array MathVariable]</Parameter>
</Parameters>
</MathStatement>

XML Example

<MathStatement TYPE="ACTIVITYFUNCTION" FUNCTIONNAME="FindBillDetail">
<Parameters>
<Parameter NAME="StartDate" TYPE="INPUT">Activity:BillingStartDate</Parameter>
<Parameter NAME="EndDate" TYPE="INPUT">Activity:BillingEndDate</Parameter>
<Parameter NAME="BillGroupGUID" TYPE="INPUT">BillOwnerGUIDMV</Parameter>
<Parameter NAME="BillMinimumAmountThreshhold" TYPE="INPUT">Activity:ThreshholdMinimumAmount</Parameter>
<Parameter NAME="BillMaximumAmountThreshhold" TYPE="INPUT">Activity:ThreshholdMaximumAmount</Parameter>
<Parameter NAME="BillDetailArray" TYPE="OUTPUT">BillDetailArrayMV</Parameter>
<Parameter NAME="BillDetailPolicyGUIDArray" TYPE="OUTPUT">BillDetailPolicyGUIDArrayMV</Parameter>
<Parameter NAME="BillDetailClientGUIDArray" TYPE="OUTPUT">BillDetailClientGUIDArrayMV</Parameter>
<Parameter NAME="BillDetailSegmentGUIDArray" TYPE="OUTPUT">BillDetailSegmentGUIDArrayMV</Parameter>
</Parameters>
</MathStatement>

 
FindLastExchangeDatePricing
TYPE=FindLastExchangeDatePricing
Element Attribute Element/Attribute Value and Description Definition
<Math>      

<MathVariables>

     

<MathStatement>

    Math element executing predefined function code.
  TYPE

ActivityFunction – Literal value only

 

  FUNCTIONNAME

FindLastExchangeDatePricing

Literal value only

Name of Statement Function

<Parameters>

     

<Parameter>

 

Predefined MathVariable Name

Date: Optional output of the guaranteed exchange date for use in activity math.

  NAME GuaranteedExchangeDate - Literal value only

Defined output name.

  TYPE OUTPUT Function parameter type: Input/Output

<Parameter>

 

Predefined MathVariable Name

Date: Optional output of the guaranteed gain/loss exchange date for use in activity math.

 

NAME

GainLossExchangeDate - Literal value only Defined output name.
  TYPE OUTPUT Function parameter type: Input/Output

XML Schema

<MathStatement TYPE="ACTIVITYFUNCTION" FUNCTIONNAME="FindLastExchangeDatePricing">
<Parameters>
<Parameter NAME="GuaranteedExchangeDate" TYPE="OUTPUT">CurrencyExchangeDate</Parameter>
<Parameter NAME="GainLossExchangeDate" TYPE="OUTPUT">GainLossCurrencyExchangeDate</Parameter>
</Parameters>
</MathStatement>
 
FindNextExchangeDatePricing
TYPE=FindNextExchangeDatePricing
Element Attribute Element/Attribute Value and Description Definition
<Math>      

<MathVariables>

     

<MathStatement>

    Math element executing predefined function code.
TYPE

ActivityFunction – Literal value only

 

FUNCTIONNAME

FindNextExchangeDatePricing

Literal value only

Name of Statement Function

<Parameters>

     

<Parameter>

 

Predefined MathVariable Name

Integer: Optional input of the offset.

NAME

ExchangeDateOffset - Literal value only

Defined input name.

TYPE

INPUT

Function parameter type: Input/Output

<Parameter>

 

Predefined MathVariable Name

Date: Optional output of the guaranteed exchange date for use in activity math.

NAME

GuaranteedExchangeDate - Literal value only

Defined output name.

TYPE

INPUT

Function parameter type: Input/Output

<Parameter>

 

Predefined MathVariable Name

Date: Optional output of the guaranteed gail/loss exchange date for use in activity math.

NAME

GainLossExchangeDate - Literal value only

Defined output name.

TYPE

INPUT

Function parameter type: Input/Output

<Parameter>

 

Predefined MathVariable Name

Date: Optional output of the rates that exist.

NAME

RatesExist - Literal value only

Defined output name.

TYPE

INPUT

Function parameter type: Input/Output

XML Schema

<MathStatement TYPE="ACTIVITYFUNCTION" FUNCTIONNAME="FindNextExchangeDatePricing">
<Parameters>
<Parameter NAME="ExchangeDateOffset" TYPE="INPUT">InputOffset</Parameter>
<Parameter NAME="GuaranteedExchangeDate" TYPE="OUTPUT">CurrencyExchangeDate</Parameter>
<Parameter NAME="GainLossExchangeDate" TYPE="OUTPUT">GainLossCurrencyExchangeDate</Parameter>
<Parameter NAME="RatesExist" TYPE="OUTPUT">RatesExist</Parameter>
</Parameters>
</MathStatement>
 
GetBenefitSplit
TYPE=GetBenefitSplit
Element Attribute Element/Attribute Value and Description Definition

<MathStatement>

    Opening element for the math variable.
TYPE

ACIVITYFUNCTION

Required: Defines the math statement type.

FUNCTIONNAME

GetBenefitSplit

Required:Defines the function to run

<Parameters>

    Required:Opening element of the parameters.

<Parameter>

 

  Required: Defines the parameters for the function

NAME

SegmentGUID Required:Defines the parameter to assign the value. A math variable holding the related segment for the BenefitSplit record.

TYPE

INPUT Required: Defines if the parameter is either input or output for the function.

<Parameter>

 

  Optional: Defines the parameters for the function

NAME

EffectiveDate Required:Defines the parameter to assign the value. A math variable holding the valuation effective date for AsNetAssetValue records.

TYPE

INPUT Required:Defines if the parameter is either input or output for the function

<Parameter>

 

  Optional: Defines the parameters for the function

NAME

BenefitSplitTypeCode Required: Defines the parameter to assign the value. A math variable or literal value indicating the BenefitSplit type code to retrieve.

TYPE

INPUT Required:Defines if the parameter is either input or output for the function.

<Parameter>

 

  Optional: Defines the parameters for the function

NAME

ABLIndicator Required: Defines the parameter to assign the value. A math variable holding either Yes or No, indicates if ABL is in effect and variable benefit is to be suppressed.

TYPE

INPUT Required: Defines if the parameter is either input or output for the function

<Parameter>

 

  Optional: Defines the parameters for the function

 

NAME ExcludeFunds Required:Defines the parameter to assign the value. An array of none or more benefit fund GUIDs to exclude from the calculated output.

 

TYPE INPUT Required:Defines if the parameter is either input or output for the function

<Parameter>

 

  Optional: Defines the parameters for the function

 

NAME BenefitAmount Required: Defines the parameter to assign the value. Gross Benefit amount in Plan default currency

 

TYPE OUTPUT Optional:Defines if the parameter is either input or output for the function

<Parameter>

 

  Optional: Defines the parameters for the function

 

NAME ParentFundAmountCollection Required:Defines the parameter to assign the value. Collection of Parent Fund GUID and Benefit Allocation Amounts in decimal values (Highest level parent to the benefit fund).

 

TYPE OUTPUT Optional:Defines if the parameter is either input or output for the function

XML Schema

<MathStatement TYPE=”ACTIVITYFUNCTION” FUNCTIONNAME="[GetBenefitSplit]">
<Parameters>
<Parameter NAME=”SegmentGUID” TYPE="INPUT">[MathVariable SegmentGUID]</Parameter>
<Parameter NAME=”EffectiveDate” TYPE="INPUT">[Date]</Parameter>
<Parameter NAME=”BenefitSplitTypeCode” TYPE="INPUT">[MathVariable Type Code]</Parameter>
<Parameter NAME=”ABLIndicator” TYPE="INPUT">[Yes|No]</Parameter>
<Parameter NAME=”ExcludeFunds” TYPE="INPUT">[Fund GUID Array]</Parameter>
<Parameter NAME=”BenefitAmount” TYPE="OUTPUT”>[MathVariable Numeric]</Parameter>
<Parameter NAME=”ParentFundAmountCollection” TYPE="OUTPUT”>[MathVariable Collection]</Parameter>
<Parameters>
</MathStatement>
 
GetFundPositions
TYPE=GetFundPositions
Element Attribute Element/Attribute Value and Description Definition
<Math>      

<MathVariables>

     

<MathStatement>

    Math element executing predefined function code.
TYPE

Activity Function– Literal value only

 

FUNCTIONNAME

GetFundPositions

Literal value only

Retrieves a policy’s parent fund guid that have fund values

<Parameters>

     

<Parameter>

 

Predefined MathVariable Name

Integer: Optional input of the offset.

  A math variable containing an array of valuation fund GUIDs. An empty array is acceptable. Required. Defines the parameters for the function

NAME

ExcludeFunds - Literal value only

Array of fund types that should not be included in the fund position determination

TYPE

INPUT

Function parameter type: Input/Output

<Parameter>

 

Predefined MathVariable Name

Date: Optional output of the guaranteed exchange date for use in activity math.

NAME

ParentFundCollectionAmount - Literal value only

Collection of parent fund guids and values.

TYPE

OUTPUT

Output Collection

<Parameter>

 

Predefined MathVariable Name

Date: Optional output of the guaranteed gail/loss exchange date for use in activity math.

NAME

GainLossExchangeDate - Literal value only

Defined output name.

TYPE

INPUT

Function parameter type: Input/Output

<Parameter>

 

Predefined MathVariable Name

Date: Optional output of the rates that exist.

NAME

RatesExist - Literal value only

Defined output name.

TYPE

INPUT

Function parameter type: Input/Output

<Parameter>

 

 

 

A math variable defining a collection. The function output is a collection of Parent Fund GUIDs and related percentages.

Optional: Defines the parameters for the function.

NAME “ParentFundPercentAmount ” Required: Defines the parameter to assign the value.
TYPE “OUTPUT” Optional: Defines if the parameter is either input or output for the function

XML Schema

<MathStatement TYPE=”ACTIVITYFUNCTION” FUNCTIONNAME="GetFundPositions">
<Parameters>
<Parameter NAME=”ExcludeFunds” TYPE="INPUT">[MathVariable Array]</Parameter>
<Parameter NAME=”ExcludeFunds” TYPE="INPUT">FundTypeArray</Parameter>
<Parameter NAME=”ParentFundAmountCollection” TYPE="OUTPUT”>OutputCollection</Parameter>
<Parameter NAME=”ParentFundPercentCollection” TYPE="OUTPUT">[MathVariable Collection]</Parameter>
<Parameters>
</MathStatement>
 
MathValuation
TYPE=MathValuation
Element Attribute Element/Attribute Value and Description Definition
<Math>      

<MathVariables>

     

<MathStatement>

Math element executing predefined function code.

TYPE

ActivityFunction

Literal value only.

 

FUNCTIONNAME

MathValuation

Required: Name of Statement Function.

<Parameters>

 

<Parameter>

A field or math variable containing a date. Must be a Date datatype.

Required: Defines the date for valuation.

NAME

ValuationDate

Literal value only.

Required: Defines the valuation date.

TYPE

INPUT

Required: Function parameter type: Input/Output.

<Parameter>

A literal or a field or math variable containing a "Yes" or "No" text string.

Required: Specifies whether the PolicyValues business rule will execute during the valuation process on each policy.

NAME

PolicyValues

Literal value only.

Required: Defines the parameter to assign the value

TYPE

INPUT

Required: Function parameter type: Input/Output.

<Parameter>

A literal or a field or math variable containing a "Yes" or "No" text string.

Required:

No: Indicates the valuation is to be calculated with the exact prices as of the ValuationDate.

Yes: valuation is to be calculated using the last known prices as of the ValuationDate.

If this value is set to No and there are no prices for the specified valuation date, a business error is thrown indicating fund prices do not exist for the specified valuation date.

NAME

NearestPrice

Literal value only.

Required: Defines the parameter to assign the value

TYPE

INPUT

Required: Function parameter type: Input/Output.

<Parameter>

A field or math variable containing a text value of "true" or "false".

Optional: The ExactPriceDateUsed output parameter returns true or false to indicate whether the fund prices used to value the policy were as of the exact ValuationDates specified (true) or the nearest price dates (false).

The NearestPrice parameter must be set to "Yes" to use this output. If NearestPrice is set to “No” the output value will always be ‘true’ when the activity processes.

NAME

ExactPriceDateUsed

Literal value only.

Required: A math variable to hold the function output.

TYPE

OUTPUT

Optional:Function parameter type: Input/Output.

<Parameter>  

Yes: Financial entry calculations and math will need to be executed in PolicyValues BR. IsValueFinancialEntry context value will be assigned a value as Yes.

No: No financial entry calculation in PolicyValues IsValueFinancialEntry will have value No .

Default Value ="No"

Optional: Defines the parameter to assign value.
  NAME ValueFinancialEntry Required: Assign Values for Parameter Literal Value or Field Value or MathVaraible.
  TYPE INPUT Required: Function parameter type.

XML Schema

<MathStatement TYPE=”ACTIVITYFUNCTION” FUNCTIONNAME="MathValuation">
<Parameters>
<Parameter NAME=”ValuationDate” TYPE="INPUT">MyValuationDate</Parameter>
<Parameter NAME=”PolicyValues” TYPE="INPUT">Yes</Parameter>
<Parameter NAME=”NearestPrice” TYPE="INPUT">Yes</Parameter>
<Parameter NAME=”ExactPriceDateUsed” TYPE="OUTPUT">ExactPriceDateUsedMV</Parameter>
<Parameter NAME=”ValueFinancialEntry” TYPE="INPUT">Yes|No| OR MathVariable or Field with Values(Yes|No)</Parameter></Parameters>
</MathStatement>
 

 

 

 

 

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