The AIRDQIndustry database stores the industry data that the application uses for scoring during data quality analyses.
You can view a diagram of the AIRDQIndustry database in Schema Diagrams.
| Table | Description |
|---|---|
| tCountyMaxStats_ALL | Stores a pre-calculated matrix of data quality scoring values. Specifically, the table stores the modeled loss cost for each combination of primary property characteristics (for example, construction, occupancy, year built, height, and geocode location) for each county. Touchstone uses the data during data quality scoring analyses to compute the Data Quality Score and Overall Risk Score. |
| tCountyMaxStats_EQ | Stores a pre-calculated matrix of data quality scoring values. Specifically, the table stores the modeled loss cost for each combination of primary property characteristics (for example, construction, occupancy, year built, height, and geocode location) for each county. Touchstone uses the data during data quality scoring analyses to compute the Data Quality Score and Overall Risk Score. |
| tCountyMaxStats_TC | Stores a pre-calculated matrix of data quality scoring values. Specifically, the table stores the modeled loss cost for each combination of primary property characteristics (for example, construction, occupancy, year built, height, and geocode location) for each county. Touchstone uses the data during data quality scoring analyses to compute the Data Quality Score and Overall Risk Score. |
| tCountyMaxStats_TCTS | Stores a pre-calculated matrix of data quality scoring values. Specifically, the table stores the modeled loss cost for each combination of primary property characteristics (for example, construction, occupancy, year built, height, and geocode location) for each county. Touchstone uses the data during data quality scoring analyses to compute the Data Quality Score and Overall Risk Score. |
| tCountyMaxStats_TS | Stores a pre-calculated matrix of data quality scoring values. Specifically, the table stores the modeled loss cost for each combination of primary property characteristics (for example, construction, occupancy, year built, height, and geocode location) for each county. Touchstone uses the data during data quality scoring analyses to compute the Data Quality Score and Overall Risk Score. |
| tCurrencyExchangeRate | Stores the currency exchange rate as of a defined date. |
| tDbHistory | Stores information about any packages applied to the database. |
| tDBKeyAndIndex | System table, used internally by the system to apply packages. |
| tDBVersion | Stores information about the current version of the database. |
| tIndustryAggregate | Stores pre-calculated aggregate industry data for data quality scoring. Touchstone uses the data during data quality scoring analyses to compute the Data Quality Score and Overall Risk Score. |
| tIndustryAggregatePercentage | Stores pre-calculated aggregate industry data for data quality scoring. Touchstone uses the data during data quality scoring analyses to compute the Data Quality Score and Overall Risk Score. |
| tScoringMaxStats_ALL | Stores a pre-calculated matrix of data quality scoring values. Specifically, the table stores the modeled loss cost for each combination of primary property characteristics (for example, construction, occupancy, year built, height, and geocode location) for each postal code. Touchstone uses the data during data quality scoring analyses to compute the Data Quality Score and Overall Risk Score. |
| tScoringMaxStats_EQ | Stores a pre-calculated matrix of data quality scoring values. Specifically, the table stores the modeled loss cost for each combination of primary property characteristics (for example, construction, occupancy, year built, height, and geocode location) for each postal code. Touchstone uses the data during data quality scoring analyses to compute the Data Quality Score and Overall Risk Score. |
| tScoringMaxStats_NonModeledZip | Stores postal codes for modeled and non-modeled regions.
Touchstone uses the data during data quality scoring analyses to compute the Data Quality Score and Overall Risk Score. |
| tScoringMaxStats_TC | Stores a pre-calculated matrix of data quality scoring values. Specifically, the table stores the modeled loss cost for each combination of primary property characteristics (for example, construction, occupancy, year built, height, and geocode location) for each postal code. Touchstone uses the data during data quality scoring analyses to compute the Data Quality Score and Overall Risk Score. |
| tScoringMaxStats_TCTS | Stores a pre-calculated matrix of data quality scoring values. Specifically, the table stores the modeled loss cost for each combination of primary property characteristics (for example, construction, occupancy, year built, height, and geocode location) for each postal code. Touchstone uses the data during data quality scoring analyses to compute the Data Quality Score and Overall Risk Score. |
| tScoringMaxStats_TS | Stores a pre-calculated matrix of data quality scoring values. Specifically, the table stores the modeled loss cost for each combination of primary property characteristics (for example, construction, occupancy, year built, height, and geocode location) for each postal code. Touchstone uses the data during data quality scoring analyses to compute the Data Quality Score and Overall Risk Score. |
| tUpgradeLog | Stores information about upgrade scripts. |