ProductPlanOrder

The ProductPlanOrder business rule defines the sort order for all screens that have system-defined Product or Plan drop-down lists.The rule can contain configuration for Products, Plans or both. The contents of the Product drop-down list are derived from the ProductName column of AsProduct, sorted alphabetically. The contents of the Plan drop-down list are derived from AsPlan columns or dynamic plan fields. If a fieldname is used for the Plan order that is not applicable to all plans, then those plans where the field is not applicable will appear alphabetically at the end of the drop down list. Each list is sorted in ascending or descending order as specified by the ORDER attribute, or in ascending order if ORDER is not specified.

The OrderBy attribute can be repeated so products ordered by a specific order attribute can in turn be ordered by another attribute. Example: Products with the same EffectiveTo date value could subsequently be ordered by ProductName.

The ordering takes place as per the order of the ORDER attributes. Example: If the order of ORDER attributes is, " Effective From Date, Effective To Date, Product Name" then

The order attribute only applies to fixed fields. In case of use of field name which doesn't belong to fixed fields in order by tag be interpreted as spelling mistake and shall be ignored. If the BR is not configured, then the products and plans shall be ordered in default order. i.e. alphabetically ascending.

For example, the screens affected by this rule may include:

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

<ProductPlanOrder>

Opening tag for this rule.

 

 

<Product>

Optional element:   

Marks the beginning of Product configuration.

 

 

<OrderBy>

 

Required and repeatable element:   

This element defines the sort order for Products where Product is a system-defined drop-down list for user selection.

 

The contents of the drop-down list are derived from the ProductName column of AsProduct.

 

ORDER

Optional attribute:   

ASCENDING or DESCENDING   

Specifies the sort order. If absent, the default is ascending order.

<Plan>

Optional element:   

Marks the beginning of plan configuration.

 

 

<OrderBy>

 

Required and repeatable element:   

This element defines the sort order for Plan screens where Plan is a system-defined drop-down list for user selection.

 

The contents of the drop-down list are derived from AsPlan columns or dynamic plan fields.

 

ORDER

Optional attribute:   

ASCENDING or DESCENDING   

Specifies the sort order. If absent, the default is ascending order.

XML Schema

<ProductPlanOrder>
<Product>
<OrderBy ORDER=”DESCENDING”>ProductName</OrderBy>
</Product>
<Plan>
<OrderBy ORDER=”DESCENDING”>EffectiveDate</OrderBy>
</Plan>
</ProductPlanOrder>

 

 

 

 

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