Define the column in the availability lookup table

About this task

Next, you must modify the lookup table definition to include the new column. In this example, the new availability column is available only for coverage term options for coverages that are associated with commercial property buildings. To modify the lookup table definition, add a <Dimension> element to the existing <LookupTable> element. You must modify additional nodes to associate the new availability column with coverage term options for other policy lines or with other coverable entities in the commercial property line.

Follow these steps to add a new column to the lookup table.

Procedure

In Studio, use the Projects window to navigate to configuration > config > lookuptables and open lookuptables.xml.
Search for CPBuildingCovOpt and add the <Dimension> element, as shown in the following code fragment.
```
<LookupTable code="CPBuildingCovOpt"
        entityName="CovTermOptLookup" 
        root="covTerm" 
        appliesTo="CPBuilding">
  <Filter field="CovTermPatternCode" valuePath="covTerm.PatternCode"/>
  <Dimension field="State" valuePath="covTerm.Clause.OwningCoverable.CoverableState" precedence="0"/>
  <Dimension field="UWCompanyCode" valuePath="covTerm.Clause.PolicyLine.PolicyPeriod.UWCompany.Code"
          precedence="1"/>
  <Dimension field="JobType" valuePath="covTerm.Clause.PolicyLine.PolicyPeriod.Job.Subtype"
          precedence="2"/>
  <Dimension field="ProductCode" valuePath="covTerm.Clause.PolicyLine.PolicyPeriod.Policy.ProductCode"
          precedence="3"/>
  <DistinguishingField field="CovTermOptCode"/>
</LookupTable>
```
The highlighted <Dimension> element is the new element. This element provides information for the ProductCode field defined on the lookup entity in Extend an availability lookup entity. PolicyCenter decides whether a coverage term is available by comparing the ProductCode in use on the policy with the ProductCode specified by the row in the lookup table. The valuePath attribute designates how PolicyCenter finds the ProductCode for comparison. The valuePath starts with the entity designated in the root attribute. When an availability lookup table has multiple matching rows, the precedence attribute determines that rows matching just the ProductCode column have lower precedence than rows matching other columns.