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

Oracle® Insurance XML Configuration Guide Release 9.4.1.0 E23637_01

# SEGMENTFIELD

## Description

SEGMENTFIELD MathVariableprovides a method for obtaining the value of a field from a segment. If the policy has multiple segments use a segment MathLoop to loop thru each segment by the SegmentGUID.

## SEGMENTFIELD Element/Attribute Table

TYPE=SEGMENTFIELD |  |  |
--- | --- | --- | ---
Element | Attributes | Attribute Value | Element Value
<MathVariable> | TYPE | SEGMENTFIELD | The name of the segment field you want to retrieve.
| SOURCEARRAY | Name of the segment loop that you want the segment field from. |
| SEGMENTGUID | MathVariable name that has the SegmentGUID value. |

## XML Example

<MathVariable VARIABLENAME="DeferredAnnuityGUID" TYPE="SQL" DATATYPE="TEXT">SELECT AsSegment.SegmentGUID FROM AsSegment JOIN AsSegmentName ON AsSegmentName.SegmentNameGUID = AsSegment.SegmentNameGUID AND AsSegmentName.TypeCode='05' AND AsSegment.PolicyGUID='[Policy:PolicyGUID]'</MathVariable>

<MathVariable VARIABLENAME="AnnuityDateMV" TYPE="SEGMENTFIELD" SEGMENTGUID="DeferredAnnuityGUID" DATATYPE="DATE">AnnuitizationDate</MathVariable>

## XML Example Using SegmentLoop

<MathLoop VARIABLENAME="Segments" TYPE="SEGMENT" CONDITION="FieldName = 'SegmentActiveCode' AND TextValue = '02'" POLICY="[Policy:PolicyGUID]">

<MathVariable VARIABLENAME="SegmentGUID" TYPE="SEGMENTFIELD" SOURCEARRAY="Segments" DATATYPE="TEXT">SegmentGUID</MathVariable>

<MathVariable VARIABLENAME="SegmentIndex" TYPE="LOOPINDEX" SOURCEARRAY="Segments" DATATYPE="INTEGER"></MathVariable>

</MathLoop>

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

Open table of contents