SegmentField

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 Elements and Attributes

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

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>