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.
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 <> 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 <> 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 > 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 > GlobalScreenMath:Zero"> <Action ACTIONTYPE="WARNING">This Group Customer has duplicate Alternate Names: $$$GlobalScreenMath:FailingAgreementNames$$$</Action> </Condition> <Condition IF="GlobalScreenMath:DefaultCount > 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>