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/Attributes

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>

 


 

 

 

 

Oracle Insurance Logo Copyright © 2017, Oracle and/or its affiliates. All rights reserved. About Oracle Insurance | Contact Us