Oracle® Insurance Rules Palette 10.1.2.0 E59346-01

DateArray

The DateArray math variable provides a method for creating an arrangement of date values. For example, this could be used as an array created to gather the Premium Payment Dates for initial and additional payments. Operations can perform calculations on the date array values by using the Operation math variable property.

Each array is created using a specific math variable type (ActivityArray, NumericArray, DateArray, IntegerArray, or StringArray) as well as the Operation to denote the action executed on the array. The Operation is defined within the math variable properties.

DateArray Math Variable in Palette

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

Define the DateArray Math Variable

Drag and drop the DateArray 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 DateArray. This is required. 

• Select the appropriate DataType from the drop down selection box. DataType is required. The data type must equal Date.

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

• Select the applicable Operation. Operation is a required property. The selections for Operation are as follows:
• Append: Used to add a value to the end of an array. Define the Source Array, which is the name of the array the operation is being performed on, if the original array is being altered during the operation. Value must be defined with the value, GUID, etc... placed at the end of the array.
• Copy: Takes a Source Array and creates a separate but identical array. The Source Array property must be defined with the name of the array the operation is being performed on if the original array is being altered during the operation.
• Create: A new array is created with the length equal to element value and each value defaulting to the value of the Defaultattribute. The Default property must be populated with a value to serve as the automatic value to be returned so the system does not return a null value. The Length property must be configured to indicate how many elements are within the new array.
• Expand: Used for creating a larger array in repeating the first, middle and last values of an array. Specific Multipliers can be used for the first and last values, but the middle values must be repeated the same number of times. To use Expand, the array must have at least three elements to constitute a first, middle, and last. Define the Source Array, which is the name of the array the operation is being performed on, if the original array is to be copied and expanded during the operation. Value is not used if the operation is Expand.

If using Expand, an additional attribute called Multiplier will need to be manually added in the XML Source pane. Multiplier will hold a comma separated list of integer multiplier factors for the first, middle and last elements in the array being expanded. The syntax is MULTIPLIER=”X,Y,Z” where X, Y and Z represent the multiple factors for the first, middle and last elements. Example: If the source array contains the element values of (1,2,3,4) and the Multipliers are 2,3,2 then the target array becomes (1,1,2,2,2,3,3,3,4,4).

• Insert: A value will be placed into the array at a particular location as indicated by Index. Insert results in a new array equal to the array indicated by the Source Array property with an element value placed at the location specified by the index property. Index must be populated withe the value of the location of the element. The Source Array property must be populated with the name of the array to be altered.
• Fill-By Deposit: Fills the array with all deposits for funds on a policy. Fill-By Deposit should be the preferred operation as opposed to Fill-By SQL. The Value property must be populated with FundGUID.
• Fill-By Fund: Fills the array with Fund GUIDs from a policy where the Funds currently have positive value. Fill-By Fund should be the preferred operation as opposed to Fill-By SQL.
• Fill-By List: Manually fills an array with a list of values. These values can be hard-coded (For example: 20) or reside in a previously defined Math variable (For example: "Twenty"). The Value property must be populated with the manual listing of items/values. The values within the listing can be previously defined math variables as well as hard-coded values, or a combination of both and the data type of the items must match the data type of the array.
• Fill-By SQL: Fills the array with the value of a SELECT query statement. The SQL query statement used must return only one single column and the data type of the value must match the data type of the array. The SQL Query property must be populated with the SELECT statement.
• Fill-By Stored Procedure: Fills the array with values from the Stored Procedure execution. You must name the procedure in the Stored Procedure drop down selection box. The box is populated with a current list of Stored Procedures. Input property is required. Defines the input parameter Name, Data Type, and allows for population/configuration of Values (previously defined Math variables).
• Remove: Takes a value from a specific element within the array using index to provide the location of the element. The Index must be specified by using the location of the element in the property. The Source Array name must be populated as the array you are altering with the removal operation.
• Stride: Creates a new array containing every nth element of SourceArray where nis the element value. The Source Array property must be defined with the name of the array you are altering. The Value property represents the element value defining n.
• Transform: Copies the array and uses the array for calculations. Copying the array using the Transform operation create a duplicate array with a different Variable Name. Calculations using Transform could include the addition of two arrays or multiplying all values in the array by a number. The Value property represents the expression (calculation being performed) or an array name (copy the array then perform the calculation).

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