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 ordering of the products is done according to the Effective From Date as per its ORDER attribute.
- the products with same Effective From Date shall in turn be arranged as per the ORDER attribute of Effective To Date
- the products with same Effective To Date shall in turn be ordered as per the ORDER attribute of the Product Name.
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:
- Company Activity
- Disbursement Approval
- Disbursement Search
-
OIPA Table Views: Plan Withholding, Plan Fields, Plan Allocations and NAV Table - Policy
- Policy Search
- Plan Activity
- State Approval
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>