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.
TYPE=SEGMENTFIELD |
|||
---|---|---|---|
Element | Attribute | 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>