SegmentField
The SegmentField allows for assigning the value of a field from AsSegment or AsSegmentField to a math variable so the value can be used to perform calculations. The SegmentField math variable has been designed for efficiency and therefore its use is preferred over an SQL statement in the configuration.
SegmentField 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 SegmentField Math Variable
Drag and drop the SegmentField 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.
-
The applicable Data Types are: Boolean, Date, Decimal, Integer, Map and Text. This is required.
-
Make sure variable type is defined as SegmentField. This is required.
-
Select Yes or No from Log field. Default is No. This is an optional field.
-
Round offers the option of Yes or No. Round is only enabled if the user selects the Decimal in the data type property. Select Yes to round the Decimal. Enter the number of decimal places to round the result value.
- Note: When the data type of Decimal is selected, the default value for Round is set to No. You must change the selection of the radio button to Yes if you wish to round.
-
Default is used for a Decimal or Integer value so the system will not return a null value. For example, the default for an Integer data type could be -999999999.
- The Segment GUID value is the GUID for the specific segment on the policy that contains the field to be retrieved. The value of this attribute will be a math variable and the Rules Palette provides a list of all configured math variables in the transaction. Only ones containing SegmentGUIDs should be used here.
- The Source Array lists all previously defined MathLoop variables. Use the Source Array if you are extracting the value from a field inside a loop and the policy has multiple segments.
- The Segment Name Filter provides a drop down selection box pre-populated with all of the currently configured Segment Names for the plan. It is only informational and not part of the configuration of the variable.
- The Segment Field is the name of the Field you wish to retrieve. Type in the Name of the field that resides in AsSegmentField.
Note: When Ctrl+Space bar is clicked , a selectable list of fields for the filtered segment name will appear based on the data type selected. If the segment name filter is not used, then all fields of that data type for all segments of the plan will be displayed.
Check-in the transaction to save the information to the database.
Copyright © 2009, 2014, Oracle and/or its affiliates. All rights reserved. Legal Notices