You are here: Transaction Rules > Transaction Elements > Math Element > SEGMENTFIELD

SEGMENTFIELD

Description

SEGMENTFIELD MathVariableprovides 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>

 

Copyright © 2009, 2011, Oracle and/or its affiliates. All rights reserved. Legal Notices