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.
| Creation Date | 1/24/2014 5:12 PM |
| File Group | PRIMARY |
| Text File Group | |
| System Object |  |
| Published for Replication | |
| Rows | 605457 |
| Data Space Used | 98,952.00 KB |
| Index Space Used | 376.00 KB |
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
 | CountryID | 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. | smallint | 2 | |||
| Country | Name of the country. | varchar | 60 |  | |||
| | StateID | Code that represents the area (state). For a complete list of codes, see tGeography Table. | varchar | 15 | |||
| STATE | Name of the area (state). | varchar | 60 | | |||
| | CountyID | Code that represents the area (county). For a complete list of codes, see tGeography Table. | varchar | 15 | |||
| County | Name of the subarea (county). | varchar | 60 | | |||
| Zip | Postal code. For a complete list of codes, see tGeography Table. | varchar | 9 | | |||
| Currency | ISO 3-character code for the currency. For a complete list of codes, see tCurrency Table. | char | 3 | | |||
| | LOBID | Identifier for the Line of Business. | smallint | 2 | |||
| LOB | Name of the Line of Business Corresponds to LOBID. | varchar | 60 | | |||
| | OccCode | Code that represents the occupancy type. | smallint | 2 | |||
| Occupancy | Name of the occupancy type. Corresponds to OccCode. | varchar | 60 | | |||
| | ConsCode | Code that represents the construction type. | smallint | 2 | |||
| Construction | Name of the construction type. Corresponds to ConsCode. | varchar | 60 | | |||
| NumRisks | Total number of risks. | int | 4 | | |||
| LimitCovAB | Industry aggregate limit of all risks for Coverage A and B combined. | float | 9 | | |||
| LimitCovC | Industry aggregate limit of all risks for Coverage C. | float | 9 | | |||
| LimitCovD | Industry aggregate limit of all risks for Coverage D. | float | 9 | | |||
| RepCovD | Industry replacement value for Coverage D | float | 9 | | |||
| EmpCount | Average employee count for all risks. | float | 9 | | |||
| GeographySID | Unique system-generated sequential identifier for the geographic record. For a complete list of records, see tGeography Table. | int | 4 | |