Completeness Rules

The Data Quality Analysis Validate Data Completeness rules 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. The following are the Completeness rules:

          Geographic

          Values and terms

          Primary risk characteristics

          Secondary risk characteristics

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 AIR's 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 AIR's 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 AIR codes or that have placeholder values. Since these values make up part of the damage function that AIR 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 AIR's 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 AIR codes.

 

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. Example

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 AIR's 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

 

 


© 2020 AIR Worldwide. All rights reserved.

Touchstone 7.0 Updated September 03, 2020