SEGMENTFIELD

Description

SEGMENTFIELD MathVariable provides 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>