Touchstone 4.0 Database Documentation
AIRDQIndustry Database
Description

The AIRDQIndustry database stores the industry data that is used for scoring during the Data Quality analysis. 

Schema Diagram

To view the database schema diagrams for the AIRDQIndustry database, see Schema Diagrams.

Tables
TableDescription
tCountyMaxStats_ALL

A scoring table that consists of a pre-calculated data matrix. This table contains, for each county, the modeled loss cost for each possible combination of primary property characteristics (construction, occupancy, year built, height, and geocode location). 

This table is used during Data Quality - Scoring analysis to compute the Data Quality Score and Overall Risk Score.

tCountyMaxStats_EQ

A scoring table that consists of a pre-calculated data matrix. This table contains, for each county, the modeled loss cost for each possible combination of primary property characteristics (construction, occupancy, year built, height, and geocode location). 

This table is used during Data Quality - Scoring analysis to compute the Data Quality Score and Overall Risk Score.

tCountyMaxStats_TC

A scoring table that consists of a pre-calculated data matrix. This table contains, for each county, the modeled loss cost for each possible combination of primary property characteristics (construction, occupancy, year built, height, and geocode location). 

This table is used during Data Quality - Scoring analysis to compute the Data Quality Score and Overall Risk Score.

tCountyMaxStats_TCTS

A scoring table that consists of a pre-calculated data matrix. This table contains, for each county, the modeled loss cost for each possible combination of primary property characteristics (construction, occupancy, year built, height, and geocode location). 

This table is used during Data Quality - Scoring analysis to compute the Data Quality Score and Overall Risk Score.

tCountyMaxStats_TS

A scoring table that consists of a pre-calculated data matrix. This table contains, for each county, the modeled loss cost for each possible combination of primary property characteristics (construction, occupancy, year built, height, and geocode location). 

This table is used during Data Quality - Scoring analysis to compute the Data Quality Score and Overall Risk Score.

tCurrencyExchangeRateStores the currency exchange rate as of a defined date.
tDBVersionDefines the current version of the database.
tIndustryAggregate

A scoring table that stores pre-calculated aggregate industry data. This table is used during Data Quality - Scoring analysis to compute the Data Quality Score and Overall Risk Score.

tIndustryAggregatePercentage

A scoring table that stores pre-calculated aggregate industry data. This table is used during Data Quality - Scoring analysis to compute the Data Quality Score and Overall Risk Score.

tScoringMaxStats_ALL

A scoring table that consists of a pre-calculated data matrix. This table contains, for each postal code, the modeled loss cost for each possible combination of primary property characteristics (construction, occupancy, year built, height, and geocode location). 

This table is used during Data Quality - Scoring analysis to compute the Data Quality Score and Overall Risk Score.

tScoringMaxStats_EQ

A scoring table that consists of a pre-calculated data matrix. This table contains, for each postal code, the modeled loss cost for each possible combination of primary property characteristics (construction, occupancy, year built, height, and geocode location). 

This table is used during Data Quality - Scoring analysis to compute the Data Quality Score and Overall Risk Score.

tScoringMaxStats_NonModeledZip

Stores postal codes for modeled and non-modeled regions. This table is used during Data Quality - Scoring analysis to compute the Data Quality Score and Overall Risk Score.

tScoringMaxStats_TC

A scoring table that consists of a pre-calculated data matrix. This table contains, for each postal code, the modeled loss cost for each possible combination of primary property characteristics (construction, occupancy, year built, height, and geocode location). 

This table is used during Data Quality - Scoring analysis to compute the Data Quality Score and Overall Risk Score.

tScoringMaxStats_TCTS

A scoring table that consists of a pre-calculated data matrix. This table contains, for each postal code, the modeled loss cost for each possible combination of primary property characteristics (construction, occupancy, year built, height, and geocode location). 

This table is used during Data Quality - Scoring analysis to compute the Data Quality Score and Overall Risk Score.

tScoringMaxStats_TS

A scoring table that consists of a pre-calculated data matrix. This table contains, for each postal code, the modeled loss cost for each possible combination of primary property characteristics (construction, occupancy, year built, height, and geocode location). 

This table is used during Data Quality - Scoring analysis to compute the Data Quality Score and Overall Risk Score.

 

 


AIR Client Confidential

© 2016. AIR Worldwide is a registered trademark. Touchstone is a registered trademark of AIR Worldwide.

Please contact AIR Worldwide with questions or comments. For database questions. For documentation comments.