Oracle® Insurance Rules Palette 10.1.2.0 E59346-01

Collection

The Collection math variable is used to hold a grouping of key and value pairs of data. The key-value pairings can be created by executing a SQL statement that will return two result columns as a key-value pair. Alternately, a Collection may be built using a SetValue operation where the key is defined as an attribute of the math variable to attach to its value. The math variable CollectionValue is used to retrieve its associated value.

Collection Math Variable in Palette

Note: For a comprehensive explanation of the characteristics of this math variable, refer to the XML Configuration Guide in the Help menu.

Define the Collection Math Variable

Drag and drop the Collection math variable from the Palette window onto the Math Pane. Enter the following information for the math variable. 

• Type a name in the Name field. This is required.

• Make sure variable type is defined as Collection. This is required. 

• The data type selection is: Boolean, Date, Decimal, Integer, Map, and Text. This is required. 

• Select Yes or No from Log field. Default is No. This is an optional field.  

• The operation is defined as Create, FillBy-SQLor SetValue.

• Create will initialize the collection and prepare it to be polulated by SetValue operations in subsequent math variables. FillBy-SQL does not require that the collection first be created. When using Create the data type selection should be either Map or Currency.

• The SetValue operation is a way to build the collection after it is created using singly added values statement by statement instead of using a SQL query. When using SetValue, the data type must match that of the value being set.
• FillBy-SQL populates the collection using a SELECT statement that returns two columns; key and its value. This is required. 

Note: If using FillBy-SQL, then a third column must be added if the collection is of currency values. This third column will hold the Currency Code. The datatype in this case must be Currency otherwise the data type must be Map.

 

• Type the Key to be used to map the value to be inserted into the collection when the operation is SetValue. The key could be a math variable or a field or a literal value but it must be unique to the value being inserted. This is required when the operation is SetValue.

Check-in the transaction to save the information to the database.