Completeness rules

The Validate Data completeness rules in Data Quality enable you to analyze the quality of your exposure data by flagging locations with empty, unknown, or user-specified values for geographic fields, values and terms fields, and primary or secondary risk characteristics.

This topic contains information about geographic rules, values and terms rules, primary risk characteristics rules, and secondary risk characteristics rules.

Geographic rules

Geographic rules help you identify locations with empty or missing location information. Without accurate location information, you run the risk of analyzing locations whose attributes may include an incorrect soil type or an incorrect distance to a coastline, which can significantly affect modeled losses. The following table describes the settings in the available rules, including the settings in our default rule set.

Attribute Flags AIR Default
Street Address Is Empty or X Locations with an empty, unknown, or default (X) street address Enabled
Street Number Is Missing Locations with a valid street name but no street number Enabled
City Is Empty or X Locations with an empty, unknown, or default (X) city Enabled
Postal Code Is Empty or 0 Locations with an empty, unknown, or default (0) postal code Enabled
Street Address Contains Locations with a street address that contains a user-specified text string Not applicable
City Contains Locations with a city that contains a user-specified text string Not applicable
Postal Code Locations with a postal code that matches a user-specified value Not applicable
Match Level Includes Locations that meet user-specified geocode levels Flags locations geocoded as:
  • City Centroid (6)

  • Postal Code Centroid (4)County Centroid (7)

Values and terms rules

Values and terms rules help you identify locations with specific or no replacement values, with specific limits, and/or with specific deductible information. You can also configure the rules to flag locations with values above or below a specific range, such as locations with a building replacement value less than or equal to $50,000. The following table describes the settings in the available rules, including the settings in our default rule set.

Attribute Flags AIR Default
Total Replacement Value Locations with a user-specified total replacement value 0
Replacement Value A and B Locations with a user-specified combined building and other structures replacement value Not applicable
Replacement Value A and C Locations with a user-specified combined building and contents replacement value Not applicable
Replacement Value C Locations with a user-specified contents replacement value Not applicable
Total Location Limit Locations with a user-specified limit value 0
Location Limit A and C Locations with a user-specified combined building and contents limit value Not applicable
Total Location Deductible Locations with a user-specified deductible value 0
Location Deductible A and C Locations with a user-specified combined building and deductible value Not applicable
Per Diem Replacement Value D Locations with a user-specified per diem time element replacement value Not applicable
Annual Replacement Value D Locations with a user-specified annual time element replacement value Not applicable

Primary risk characteristics rules

Primary risk characteristics rules help you identify locations with unknown values for key building attributes. You can also configure the rules to flag locations that match specific Touchstone codes or that have placeholder values. Since these values make up part of the damage function that Touchstone uses to calculate modeled losses for a location, it is important that they are accurate and complete. The following table describes the settings in the available rules, including the settings in the default rule set.

Attribute Flags AIR Default
Building Construction Is Empty or 100 (unknown) Locations with an empty or Unknown (100) building construction class Enabled
Building Occupancy Is Empty or 300 (unknown) Locations with an empty or Unknown (300) building occupancy class Enabled
Building Construction Code Includes Locations with user-specified building construction codes Not available
Occupancy Code Includes Locations with user-specified building occupancy codes Flags locations geocoded as:
  • General commercial (311)

  • General industrial (321)

Year Built Locations built in a user-specified year 0
Height Locations with a user-specified number of stories 0
Gross Area Locations with a user-specified gross area Not available

Secondary risk characteristics rules

Secondary risk characteristic rules help you identify locations with unknown values for secondary building attributes. You can also configure the rules to flag locations that match specific Touchstone codes.

Note:

Many of these rules are peril-specific; they will flag locations with unknown values only if the locations are also covered for the affected peril.

The analysis will flag a location with an unknown torsion value if the location is covered for Earthquake Shake, but not if it is only covered for Tropical Cyclone Wind.

Note:

By default, this rule set is not enabled in the AIR (Default) completeness rule set. Select the check box if you want to enable it. The following table describes the settings in the available rules, including the settings in our default rule set. The descriptive information notes the peril-specific rules that apply to the attribute.

Attribute Flags
Building Detail
Shape Locations with user-specified Shape values that are covered for the Earthquake Shake peril
Torsion Locations with user-specified Torsion values that are covered for the Earthquake Shake peril
Soft Story Locations with user-specified Soft Story values that are covered for the Earthquake Shake peril
Roof Detail
Roof Geometry Locations with user-specified Roof Geometry values that are covered for the Tropical Cyclone Wind peril
Roof Cover Locations with user-specified Roof Cover values that are covered for the Tropical Cyclone Wind and Wildfire perils
Roof Cover Attachment Locations with user-specified Roof Cover Attachment values that are covered for the Tropical Cyclone Wind peril
Roof Deck Locations with user-specified Roof Deck values that are covered for the Tropical Cyclone Wind and Earthquake Shake perils
Roof Deck Attachment Locations with user-specified Roof Deck Attachment values that are covered for the Tropical Cyclone Wind peril
Roof Anchorage Locations with user-specified Roof Anchorage values that are covered for the Tropical Cyclone Wind peril
Wall Detail
Wall Type Locations with user-specified External Wall Type values that are covered for the Tropical Cyclone Wind and Earthquake Shake perils
Siding Locations with user-specified Siding values
Glass Type Locations with user-specified Glass Type values that are covered for the Tropical Cyclone Wind peril
Glass Percent Locations with user-specified Glass Percent values that are covered for the Tropical Cyclone Wind peril
Window Protection Locations with user-specified Window Protection values that are covered for the Tropical Cyclone Wind peril
External Doors Locations with user-specified External Doors values that are covered for the Tropical Cyclone Wind peril
Connection Detail
Foundation Type Locations with user-specified Foundation Type values that are covered for the Tropical Cyclone Wind peril
Building Foundation Connection Locations with user-specified Building Foundation Connection values that are covered for the Tropical Cyclone Wind and Earthquake Shake perils
Appurtenant Structure Locations with user-specified Appurtenant Structure values