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.
| Creation Date | 4/19/2012 1:42 PM |
| File Group | PRIMARY |
| Text File Group | |
| System Object |  |
| Published for Replication | |
| Rows | 2255760 |
| Data Space Used | 272,576.00 KB |
| Index Space Used | 2,064.00 KB |
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
| CountyScoringSID | Unique system-generated sequential identifier for the scoring record. | bigint | 8 | ||||
| CountryCode | ISO 2-character code for the country in which the location resides. Currently, Touchstone supports scoring only for the United States. Consequently, the value is always 1. | int | 4 |  | |||
| StateCode | Code that represents the area (state). For a complete list of codes, see tGeography Table. | int | 4 | | |||
| CountyCode | Code that represents the area (county). For a complete list of codes, see tGeography Table. | int | 4 | | |||
| OccCat | Categorization for the typical occupancy type in the area. | varchar | 29 | | |||
| ConcCat | Categorization for the typical construction type in the area. | varchar | 11 | | |||
| YearBuilt | Average year the exposures in the area were built. | int | 4 | | |||
| Height | Average height of the exposures in the area. | int | 4 | | |||
| GeoMean | Mean for a region, calculated using the values for OccCat, ConcCat, YearBuilt, and Height. | float | 9 | | |||
| GeoStdDev | Standard deviation for a region, calculated using the values for OccCat, ConcCat, YearBuilt, and Height. | float | 9 | | |||
| AttribMean | Attribute mean for the county, calculated using each of the values for OccCat, ConcCat, YearBuilt, and Height. | float | 9 | | |||
| AttribStdDev | Attribute standard deviation for the county, calculated using each of the values for OccCat, ConcCat, YearBuilt, and Height. | float | 9 | | |||
| GeoMultiplier | Multiplier for the region. | float | 9 | | |||
| AttribMultiplier | Multiplier for the attribute. | float | 9 | | |||
| Peril | Numeric code for the single peril or set of perils. For a complete list of codes, see tPerilSet Table. | char | 2 | |