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 | 244199 |
| Data Space Used | 40,048.00 KB |
| Index Space Used | 9,088.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 |  | |||
| AreaLevel2 | Code that represents the area (state). For a complete list of codes, see tGeography Table. | varchar | 15 | ||||
| Area | Name of the area (state). | varchar | 60 | | |||
| AreaLevel3 | Code that represents the area (county). For a complete list of codes, see tGeography Table. | varchar | 15 | ||||
| SubArea | Name of the subarea (county). | varchar | 60 | | |||
| 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 | | |||
| IndType | Type of industry data. | varchar | 12 | ||||
| DetailID | Identifier for the detailed. | smallint | 2 | ||||
| Detail | Name of the detail. Corresponds to DetailID. | varchar | 60 | | |||
| IndPctNumRisks | Percent of risks that are included in the Detail classification. | float | 9 | ||||
| IndPctCoverage | Percent of industry coverage for that Detail classification. | float | 9 | ||||
| IndNumRisksDetail | Number of risks that are included in the Detail classification. | int | 4 | | |||
| IndCoverageDetail | Industry replacement value for coverage detail. | float | 9 | | |||
| IndNumRisks | Total number of risks. | int | 4 | | |||
| IndCoverage | Industry replacement value for Coverage A. | float | 9 | | |||
| IndCoverageC | Industry replacement value for Coverage C. | float | 9 | | |||
| IndCoverageD | Industry replacement value for Coverage D. | float | 9 | |