QuoteResultScreen

The Quote Result screen enables users to display quote results via the rule defined format, this can include results in OIPA's regular layout (two column non editable field label and value) or in a table layout (grid).

OIPA supports a "Total" Attribute for the output column specification in the Quote Result screen wherein if the Column Data is numeric, a total of the results can be displayed. The total that referred here is the entire results set, the new attribute "Total" added to the Column will fetch the value results for the numeric column data at the bottom of the grid via configured SQL statement.

QuoteResultScreen: Elements and Attributes

Element/Tag	Attributes	Parent Element	Description	Element/Attribute Value
<QuoteResultScreen>			The opening and closing elements of the rule.
<Output>		<QuoteResultScreen>	Defines the Output section of the Inquiry screen. Configured differently for field display and table display.
<Result>	DISPLAY	<Output>		String: Name of the result set.
<Fields>			Defines the output fields.
<Query>	TYPE	<Result>	Summary: Indicates a field display with a MathVariables section. The Query element is a descendant of the Result XML element. Will define the fields to be displayed at the top of the results screen. Note: User can add multiple Queries /Summaries in the results screen. Math: Indicates a field display with a MathVariables section. The Query element is a descendant of the Result XML element. SQL: Indicates a table display supported by a SQL statement that may return multiple columns and multiple rows. The Query element is a descendent of a Results XML element.
<Fields>		<Result>	Used when Query TYPE="SQL" to define the table. Standard column attributes are available.
<MathVariables>			Used when Query TYPE="MATH" Standard math variables functionality is available.
<Table>		<Result>	Used with Query TYPE="SQL" to indicate that results will be returned in a table format. See Table_Element for more details.   Note: <Group> tag is compulsory to Identify defaultPII fields and perform defaultPII masking.
	TOTAL		Optional Attribute:	Yes/No Yes: Displays a sum of a numeric column at the bottom of the column. No: No does not display a sum for the column. Default Value is “No”.
<Query>	TYPE	<Results>	Math: Indicates a field display with a MathVariables section. The Query element is a descendent of the Result XML element. SQL: Indicates a table display supported by a SQL statement that may return multiple columns and multiple rows. The Query element is a descendent of a Results XML element.
<Fields>		<Result>	Used when Query TYPE="SQL" to define the table. Standard column attributes are available.
<MathVariables>			Used when Query TYPE="MATH" Standard math variables functionality is available.

XML Example

<QuoteResultScreen>

<Output>

<Result DISPLAY="QUOTE DATA">

<Query TYPE="SUMMARY">

<MathVariables>

<MathVariable VARIABLENAME="QuoteNumber" TYPE="SQL" DATATYPE="TEXT">Select TextValue from AsQuoueVersionField where QuoteVersionGUID = '[QuoteVersionGUID]' And FieldName = 'QuoteNumber'</MathVariable>

<MathVariable VARIABLENAME="MemberCount" TYPE="SQL" DATATYPE="INTEGER">Select Count(*) from AsQuoteMember Where QuoteGUID =  '[QuoteGUID] </MathVariable>

<MathVariable VARIABLENAME="EffectiveDate" TYPE="SQL" DATATYPE="DATE">Select EffectiveDate from AsQuoteVersion where QuoteVersionGUID = '[QuoteVersionGUID]'</MathVariable>

<MathVariable VARIABLENAME="MemberPremiums" TYPE="SQL" DATATYPE="DECIMAL">Select Sum(FloatValue) from AsMemberField where FieldName= 'MemberPremiumAmount'</MathVariable>

</MathVariables>

</Query>

<Fields>

<Field>

<Display>Quote Number</Display>

<Name>QuoteNumber</Name>

<DataType>Text</DataType>

</Field>

<Field>

<Name>EffctiveDate</Name>

<Display>Effective Date</Display>

<DataType>Date</DataType>

</Field>

<Field>

<Display>Member Count</Display>

<Name>MemberCount</Name>

<DataType>Integer</DataType>

</Field>

<Field>

<Display>Member Premiums</Display>

<Name>MemberPremiums</Name>

<DataType>Decimal</DataType>

</Field>

</Fields>

</Result>

<Result DISPLAY="MEMBER LIST">

<Table>

<Results>

<Query TYPE="SQL">SELECT FirstName,LastName,MemberResult1,MemberResult2 from AsQuoteMember where QuoteGUID='[QuoteGUID]'</Query>

</Results>

<Column ALIGN="RIGHT">

<Display>First Name</Display>

<Name>FirstName</Name>

<DataType>Text</DataType>

<Group>QuoteMember</Group>

</Column>

<Column ALIGN="RIGHT">

<Display>Last Name</Display>

<Name>LastName</Name>

<DataType>Text</DataType>

</Column>

<Column ALIGN="RIGHT">

<Display>Member Result 1</Display>

<Name>MemberResult1</Name>

<DataType>Decimal</DataType>

</Column>

<Column ALIGN="RIGHT">

<Display>Member Result 2</Display>

<Name>MemberResult2</Name>

<DataType>Decimal</DataType>

</Column>

</Table>

</Result>

<Result DISPLAY="BENEFIT LIST">

<Table>

<Results>

<Query TYPE="SQL">SELECT Description,BenefitName,BenefitResult1,BenefitResult2 from AsQuoteBenefit where QuoteVersionGUID='[QuoteVersionGUID]'</Query>

</Results>

<Column ALIGN="RIGHT">

<Display>Description</Display>

<Name>Description</Name>

<DataType>Text</DataType>

</Column>

<Column ALIGN="RIGHT">

<Display>Benefit Name</Display>

<Name>BenefitName</Name>

<DataType>Text</DataType>

</Column>

<Column ALIGN="RIGHT  TOTAL="Yes"">

<Display>Benefit Result 1</Display>

<Name>BenefitResult1</Name>

<DataType>Decimal</DataType>

</Column>

<Column ALIGN="RIGHT">

<Display>Benefit Result 2</Display>

<Name>BenefitResult2</Name>

<DataType>Decimal</DataType>

</Column>

</Table>

</Result>

</Output>

</QuoteResultScreen>