You are here: Transaction Rules > Transaction Elements > Math Element > COLLECTIONVALUE

Oracle® Insurance XML Configuration Guide Release 9.4.1.0 E23637_01

# COLLECTIONVALUE

## Description

A math variable statement of type COLLECTIONVALUE returns the value associated to a given key. The collection must be created prior to using COLLECTIONVALUE. The COLLECTION MathVariable is used to create collections.

COLLECTIONVALUE Element/Attribute Table
TYPE=COLLECTIONVALUE
Element | Element Value | Attribute | Attribute Value
--- | --- | --- | ---
<MathVariable> | The name of the collection. |  |
| TYPE | COLLECTIONVALUE
KEY | MathVariable or string literal whose value is the key from which the associated value is returned. Do not use KEY if KEYFIELD is configured.
KEYFIELD | String. Math Variable to define key use and to access the key in the collection. Do not use KEYFIELD if KEY is configured.
DATATYPE | Required attribute: DATE TEXT INTEGER DECIMAL DATATYPE must match the data type of the field or math variable in the element name.
ROUND | Integer that sets the rounding for DECIMAL data types.
DEFAULT | Use a default value for math variable in case the system does not return a result, to avoid a null result. For example, integer may have the default value of -999999999, a decimal may have the default value of 0.
LOG | Yes: the result is stored in AsActivityMath table to be used by other activities. No: the result is not stored. This is the default behavior.

## XML Examples

    <MathVariable VARIABLENAME="FixedFundGUID" TYPE="COLLECTIONVALUE" KEY="1601"

    DATATYPE="TEXT">FundGUIDs</MathVariable>

    <MathVariable VARIABLENAME="IssueAge" TYPE="COLLECTIONVALUE" KEY="SegmentIssueAge"

    DATATYPE="INTEGER" DEFAULT="-999999999">SegmentCollection</MathVariable>

    <MathVariable VARIABLENAME="BaseFace" TYPE="COLLECTIONVALUE" KEY="SegmentAmount"

    DATATYPE="DECIMAL" DEFAULT="-999999999">SegmentCollection

    </MathVariable>

Copyright © 2009, 2011, Oracle and/or its affiliates. All rights reserved. Legal Notices

Open table of contents