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.
| Creation Date | 4/19/2012 1:51 PM |
| File Group | PRIMARY |
| Text File Group | |
| System Object |  |
| Published for Replication | |
| Rows | 21810960 |
| Data Space Used | 3,597,664.00 KB |
| Index Space Used | 1,453,504.00 KB |
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
| ScoringSID | 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 only supports scoring for the United States, so this value is always 1. | int | 4 |  | |||
| StateName | Name of the area (state). | varchar | 50 | | |||
| StateCode | Code that represents the area (state). For a complete list of codes, see tGeography Table. | int | 4 | | |||
| CountyName | Name of the subarea (county). | varchar | 100 | | |||
| CountyCode | Code that represents the area (county). For a complete list of codes, see tGeography Table. | int | 4 | | |||
| ZipCode | Postal code. For a complete list of codes, see tGeography Table. | varchar | 9 | | |||
| SumsInsured | Average value for total sums insured for the area. | float | 9 | | |||
| TotRisks | Total number of risks in the area. | 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 standard 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 | | |||
| XreffZipCode | Reference postal code. | varchar | 9 | |