Oracle® Insurance XML Configuration Guide Release 10.2.0.0 E62439-01
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 |
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. |
|
<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>
<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, 2015, Oracle and/or its affiliates. All rights reserved. Legal Notices