BillDetailReconciliationSearchScreen

BillDetailReconciliationSearchScreen BR is listed under the Screen Rule section in Rules Palette Global Rules Explorer -> Business Rules. This screen allows to configure a set of search criteria and results like all other OIPA search screens under a <Search> element and a <Results> element.

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

<BillDetailReconciliationSearchScreen>

 

The opening and closing elements of the BillDetailReconciliationSearchScreen Business Rule

  

<Search>

 

 

Required element:   

Indicates and defines search criteria and the fields to be included as part of the Bill Detail Reconciliation Search Screen

 

.

<Fields>

Required element:

Standard fields element configuration for Search Screens

Available Results Groups:

  • BillDetailReconciliation
  • BillDetail
  • BilldetailField
  • GroupCustomer
  • GroupCustomerField
  • Client
  • ClientField
  • Policy
  • PolicyField
  • Segment
  • SegmentField

<Results>

 

Required Attribute:

Indicates and defines search criteria and the fields to be included as part of the Bill Detail Reconciliation Search Screen

 

<Table>

 

Required Attribute:

Standard Table element configuration for Search Screen results

Available Results Groups::

  • BillDetailReconciliation
  • BillDetail
  • BilldetailField
  • GroupCustomer
  • GroupCustomerField
  • Client
  • ClientField
  • Policy
  • PolicyField
  • Segment
  • SegmentField

XML Example:

<BillDetailReconciliationSearchScreen>
<Search>
<Fields>
<Field>
<Name>BillDetailReferenceID</Name>
<Group>BillDetailField</Group>
<Display>Bill Detail Reference Number</Display>
<DataType>Text</DataType>
</Field>
<Field>
<Name>Amount</Name>
<Group>BillDetail</Group>
<Display>Bill Detail Reconciliation Amount</Display>
<DataType>Money</DataType>
</Field>
<Field>
<Name>SuspenseNumber</Name>
<Group>BillDetailReconciliation</Group>
<Display>SuspenseNumber</Display>
<DataType>Integer</DataType
</Field>
<Field>
<Name>StatusCode</Name>
<Group>Status</Group>
<Display>Combo</Display>
<Query TYPE="SQL">
<Oracle>SELECT '', '', 1 FROM DUAL UNION SELECT AsCode.CodeValue, AsCode.LongDescription, 2 FROM AsCode WHERE AsCode.CodeName='AsCodeBillDetailStatusCode' AND AsCode.CodeValue IN ('BILLED', 'PENDING', 'UNDERRECON', 'RECONCILED') ORDER BY 3, 1</Oracle>
<SqlServer>SELECT '', '', 1 UNION SELECT AsCode.CodeValue, AsCode.LongDescription, 2 FROM AsCode WHERE AsCode.CodeName = 'AsCodeBillDetailStatusCode' AND AsCode.CodeValue IN ('BILLED', 'PENDING', 'UNDERRECON', 'RECONCILED') ORDER BY 3, 1</SqlServer>DB2>SELECT '', '', 1 FROM SYSIBM.SYSDUMMY1 UNION SELECT AsCode.CodeValue, AsCode.LongDescription, 2 FROM AsCode WHERE AsCode.CodeName = 'AsCodeBillDetailStatusCode' AND AsCode.CodeValue IN ('BILLED', 'PENDING', 'UNDERRECON', 'RECONCILED') ORDER BY 3, 1</DB2>
</Query>
<Group>BillDetailReconciliation</Group>
</Field>
</Fields>
<Results>
<Table>
<Column>
<Display>Bill Detail Reference Number</Display>
<Name>BillDetailReferenceID</Name>
<Group>BillDetailField</Group>
<DataType>Text</DataType>
</Column>
<Column>
<Name>PolicyNumber</Name>
<Group>Policy</Group>
<Group>Policy</Group>
<DataType>Text</DataType>
</Column>
<Column>
<Display>Suspense Number</Display>
<Name>SuspenseNumber</Name>
<Group>BillDetailReconciliation</Group>
<DataType>Integer</DataType>
</Column>
</Table>
</Results>
</BillDetailReconciliationSearchScreen>

 

XML Schema

<BillDetailReconciliationSearchScreen>
<Search>
<Fields>
<Field>
<Name>SearchCriteriaFieldName</Name>
<Group>BillDetailReconciliation|BillDetail|BillDetailField|GroupCustomer|GroupCustomerField|Client|ClientField|Policy|PolicyField|Segment|SegmentField</Group>
<Display>SearchFieldDisplayName</Display>
<DataType>SearchFieldDataType</DataType>
</Field>
........
</Fields>
</Search>
</Results>
<Table>
<Column>
<Display>ResultsFieldDisplayName</Display>
<Name>ResultsFieldName</Display>
<Group>BillDetailReconciliation|BillDetail|BillDetailField|GroupCustomer|GroupCustomerField|Client|ClientField|Policy|PolicyField|Segment|SegmentField</Group>
<DataType>ResultsFieldDataType</DataType> 
</Column>
......
</Table>
</Results>
</BillDetailReconciliationSearchScreen>

 

 

 

 

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