AlternateNameScreen

The AlternateNameScreen enables users to add, maintain, and search for multiple alternate names for a client. It also supports the ability to record the status of an alternate name instance.

Note: This screen do not support the dynamic fields.

AlternateNameScreen Elements/Attributes
Element/Tag Attribute Definition Element/Attribute Value and Description

<AlternateNameScreen>

 

The opening and closing tags of this rule.

 

<Table>

 

See Table Element.

 

<Fields>

 

The opening and closing tag for the fields section. See Fields Elements. 

Fields section is required to define the Actions, Events and ScreenMath in AlternatenameScreen.

<Events>

 

See Action Events.

 

<ScreenMath>

 

See ScreenMath.

 

<Actions>

 

See Action Events.

 

XML Example

<AlternateNameScreen>
	<Table>
		<Column WIDTH="60" ALIGN="LEFT">
			<Name>AlternateId</Name>
			<Display>Alternate Name</Display>
			<Group>ClientAltId</Group>
			<DataType>Text</DataType>
		</Column>
		<Column WIDTH="60" ALIGN="LEFT">
			<Name>EffectiveFrom</Name>
			<Display>Effective From</Display>
			<Group>ClientAltId</Group>
			<DataType>Date</DataType>
		</Column>
		<Column WIDTH="60" ALIGN="LEFT">
			<Name>EffectiveTo</Name>
			<Display>Effective To</Display>
			<Group>ClientAltId</Group>
			<DataType>Date</DataType>
		</Column>
		<Column WIDTH="60" ALIGN="LEFT">
			<Name>StatusCode</Name>
			<Display>Status</Display>
			<Group>ClientAltId</Group>
			<DataType>Text</DataType>
		</Column>
		<Column WIDTH="60" ALIGN="CENTER">
			<Name>DefaultIndicator</Name>
			<Display>Default</Display>
			<Group>ClientAltId</Group>
			<DataType>Text</DataType>
		</Column>
	</Table>
	<Fields>
		<Field>
			<Name>Dummy</Name>
			<Display>Dummy</Display>
			<DataType>Text</DataType>
			<Hidden>Yes</Hidden>
		</Field>
	</Fields>
	<Events>
		<Event TYPE="ONLOAD">
			<ActionSet ID="OnLoadValidation"></ActionSet>
		</Event>
		<Event TYPE="ONCHANGE" FIELD="StatusCode">
			<ActionSet ID="OnChangeValidation"></ActionSet>
		</Event>
		<Event TYPE="ONSUBMIT">
			<Math ID="LocalScreenMath"></Math>
			<ActionSet ID="OnSubmitValidation"></ActionSet>
		</Event>
	</Events>
	<ScreenMath>
		<Math ID="GlobalScreenMath" GLOBAL="Yes">
			<MathVariables>
				<MathVariable VARIABLENAME="Today" TYPE="SYSTEMDATE" DATATYPE="DATE"></MathVariable>
				<MathVariable VARIABLENAME="AlternateIdMV" TYPE="VALUE" DATATYPE="TEXT">Enter name here</MathVariable>
				<MathVariable VARIABLENAME="StatusCodeMV" TYPE="VALUE" DATATYPE="TEXT">01</MathVariable>
				<MathVariable VARIABLENAME="DefaultFlagMV" TYPE="VALUE" DATATYPE="TEXT">N</MathVariable>
				<MathVariable VARIABLENAME="NameCount" TYPE="SQL" DATATYPE="INTEGER">SELECT Count(P1.AlternateId) FROM asclientaltid P1 WHERE EXISTS ( SELECT 1 FROM asclientaltid P2 WHERE P2.AlternateId = P1.AlternateId AND P2.ClientAltIDGUID &lt;&gt; P1.ClientAltIDGUID AND p1.ClientGUID = '[GroupCustomerClientGUID]')</MathVariable>
				<MathVariable VARIABLENAME="AgreementNames" TYPE="STRINGARRAY" DATATYPE="TEXT" OPERATION="FILLBY-SQL">SELECT Distinct P1.AlternateId FROM asclientaltid P1 WHERE EXISTS ( SELECT 1 FROM asclientaltid P2 WHERE P2.AlternateId = P1.AlternateId AND P2.ClientAltIDGUID &lt;&gt; P1.ClientAltIDGUID AND p1.ClientGUID = '[GroupCustomerClientGUID]')</MathVariable>
				<MathVariable VARIABLENAME="FailingAgreementsCount" TYPE="AGGREGATEFUNCTION" DATATYPE="INTEGER" METHOD="COUNT">AgreementNames</MathVariable>
				<MathLoop VARIABLENAME="AgreementNamesLoop" TYPE="FOR" ITERATIONS="FailingAgreementsCount">
					<MathVariable VARIABLENAME="NamesLoopIndex" TYPE="LOOPINDEX" SOURCEARRAY="AgreementNamesLoop" DATATYPE="INTEGER"></MathVariable>
					<MathVariable VARIABLENAME="CurrentAgreementName" TYPE="AGGREGATEFUNCTION" METHOD="INDEX" INDEX="NamesLoopIndex" DATATYPE="TEXT">AgreementNames</MathVariable>
					<MathIF IF="NamesLoopIndex = 0">
						<MathVariable VARIABLENAME="FailingAgreementNames" TYPE="EXPRESSION" DATATYPE="TEXT">CurrentAgreementName</MathVariable>
					</MathIF>
					<MathIF IF="NamesLoopIndex &gt; 0">
						<MathVariable VARIABLENAME="FailingAgreementNames" TYPE="EXPRESSION" DATATYPE="TEXT">FailingAgreementNames + " , " + CurrentAgreementName</MathVariable>
					</MathIF>
				</MathLoop>
				<MathVariable VARIABLENAME="Zero" TYPE="VALUE" DATATYPE="INTEGER">0</MathVariable>
				<MathVariable VARIABLENAME="DefaultCount" TYPE="SQL" DATATYPE="INTEGER">select Count(*) from asclientaltid where asclientaltid.clientguid = '[GroupCustomerClientGUID]' and asclientaltid.DefaultIndicator = 'Y'</MathVariable>
			</MathVariables>
		</Math>
		<Math ID="LocalScreenMath" GLOBAL="No">
			<MathVariables>
				<MathVariable VARIABLENAME="Zero2" TYPE="VALUE" DATATYPE="INTEGER">0</MathVariable>
				<MathVariable VARIABLENAME="DefaultCount" TYPE="SQL" DATATYPE="INTEGER">select Count(*) from asclientaltid where asclientaltid.clientguid = '[GroupCustomerClientGUID]' and asclientaltid.DefaultIndicator = 'Y'</MathVariable>
			</MathVariables>
		</Math>
	</ScreenMath>
	<Actions>
		<ActionSet ID="OnLoadValidation">
			<Condition IF="IsEmpty(AlternateId)">
				<Action ACTIONTYPE="ASSIGN" FIELD="AlternateId">GlobalScreenMath:AlternateIdMV</Action>
			</Condition>
			<Condition IF="IsEmpty(EffectiveFrom)">
				<Action ACTIONTYPE="ASSIGN" FIELD="EffectiveFrom">GlobalScreenMath:Today</Action>
			</Condition>
			<Condition IF="GlobalScreenMath:NameCount &gt; GlobalScreenMath:Zero">
				<Action ACTIONTYPE="WARNING">This Group Customer has duplicate Alternate Names: $$$GlobalScreenMath:FailingAgreementNames$$$</Action>
			</Condition>
			<Condition IF="GlobalScreenMath:DefaultCount &gt; GlobalScreenMath:Zero">
				<Action ACTIONTYPE="WARNING">This Group Customer has $$$GlobalScreenMath:DefaultCount$$$ Alternate Names identified as default.</Action>
			</Condition>
		</ActionSet>
		<ActionSet ID="OnChangeValidation">
			<Condition IF="StatusCode='05'">
				<Action ACTIONTYPE="ASSIGN" FIELD="EffectiveTo">GlobalScreenMath:Today</Action>
				<Action ACTIONTYPE="ASSIGN" FIELD="DefaultIndicator">GlobalScreenMath:DefaultFlagMV</Action>
			</Condition>
		</ActionSet>
		<ActionSet ID="OnSubmitValidation">
			<Condition IF="AlternateId='Enter name here'">
				<Action ACTIONTYPE="ERROR">Alternate Name is a required field.</Action>
			</Condition>
		</ActionSet>
	</Actions>
</AlternateNameScreen>

 

 

 

 

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