Stores result details for the Data Quality - Scoring reports. Each single table contains detail data for one report.
Touchstone 2022 Database Reference
tRRRR_DQ_SCR_ResultDetail Table
| Creation Date | 4/11/2022 6:15 PM |
| File Group | PRIMARY |
| Text File Group | |
| System Object |  |
| Published for Replication | |
| Rows | 0 |
| Data Space Used | 0.00 KB |
| Index Space Used | 0.00 KB |
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
 | ResultDetailSID | Unique system-generated sequential identifier for the detailed results record. For a complete list of records, see tAnalysisResult Table. | int | 4 | |||
| LocationSID | Unique system-generated sequential identifier for the location record. For a complete list of records, see tLocation Table. | int | 4 |  | |||
| LocationID | User-defined identifier for the location. | varchar | 100 | ||||
| CountryCode | ISO 2-character code for the country in which the location resides. For a complete list of codes, see tCountry Table. | varchar | 15 | | |||
| CountryName | Name of the country. | varchar | 255 | | |||
| AreaCode | Area code for the location. For a complete list of codes, see tGeography Table. | varchar | 15 | | |||
| AreaName | Name of the area. | varchar | 255 | | |||
| SubareaCode | Subarea code for the location. For a complete list of codes, see tGeography Table. | varchar | 15 | | |||
| SubAreaName | Name of the subarea. | varchar | 255 | | |||
| PostalCode | Postal code for the location. For a complete list of codes, see tGeography Table. | varchar | 15 | | |||
| PostalName | Name of the postal code. | varchar | 255 | | |||
| Address | Street address for the location. | varchar | 255 | | |||
| ExposureSetSID | Unique system-generated sequential identifier for the exposure set record. For a complete list of records, see tExposureSet Table. | int | 4 | | |||
| ExposureSetName | Name of the exposure set. | varchar | 255 | ||||
| ExposureViewSID | Unique system-generated sequential identifier for the exposure view record. For a complete list of records, see tExposureView Table. | int | 4 | | |||
| ExposureViewName | Name of the exposure view. | varchar | 255 | | |||
| ScorePeril | Name of the peril that serves as the basis for the loss cost used to calculate hazard-specific component of the risk score. | varchar | 50 | | |||
| PerilSetCode | Numeric code for the single peril or set of perils. For a complete list of codes, see tPerilSet Table. | int | 4 | | |||
| UserLOBSID | Unique system-generated sequential identifier for the user's Line of Business record. | int | 4 | | |||
| UserLineOfBusiness | User's Line of Business. | varchar | 60 | | |||
| FormLOBSID | Unique system-generated sequential identifier for the contract's Line of Business record. | int | 4 | | |||
| PolicyForm | Name of the policy form. | varchar | 60 | | |||
| ContractSID | Unique system-generated sequential identifier for the contract record. For a complete list of records, see tContract Table. | int | 4 | | |||
| ContractID | User-provided identifier for the contract. | varchar | 100 | ||||
| ScoreDQS | Data Quality score that is calculated based on the scoring data provided by the AIR DQIndustry database. This score is combined with ScoreARI, ScoreDQU, and ScoreBRI values to determine the Overall Risk score and Data Quality Score. | float | 9 | | |||
| ScoreARI | Referred to on the user interface as the Overall Risk Score, this is the adjusted risk index score that is calculated based on the scoring data provided by the AIR DQIndustry database. This score is combined with ScoreDQS, ScoreDQU and ScoreBRI values to determine the Overall Risk score and Data Quality Score. A higher Overall Risk Score indicates greater risk based on geography, replacement value, and the primary attributes of each location. | float | 9 | | |||
| ScoreBRI | Base risk index score that is calculated based on the scoring data provided by the AIR DQIndustry database. This score is combined with ScoreDQS, ScoreDQU, and ScoreARI values to determine the Overall Risk score and Data Quality Score. | float | 9 | | |||
| ScoreDQU | Data Quality Uncertainty score that is calculated based on the scoring data provided by the AIR DQIndustry database. This score is calculated by subtracting the ScoreBRI from ScoreARI. | float | 9 | | |||
| ScoreRF | Reserved for future use. | float | 9 | | |||
| ReplacementValueA | Combined Coverage A replacement value of flagged location(s). | float | 9 | | |||
| ReplacementValueB | Combined Coverage B replacement value of flagged location(s). | float | 9 | | |||
| ReplacementValueC | Combined Coverage C replacement value of flagged location(s). | float | 9 | | |||
| ReplacementValueD | Combined Coverage D replacement value of flagged location(s). | float | 9 | | |||
| TotalReplacementValue | Sum of replacement value for all coverages. | float | 9 | | |||
| ScoreConstruction | Construction class description. | varchar | 50 | | |||
| ScoreOccupancy | Occupancy class description. | varchar | 50 | | |||
| ScoreHeight | Height of the structure. | int | 4 | | |||
| ScoreYearBuilt | Year the structure was built. | int | 4 | | |||
| GeoCode | Geocode values for the location. | varchar | 50 | | |||
| City | City in which the location resides. | varchar | 255 | | |||
| Latitude | Latitude coordinate for the city. Values will be positive for locations north of the equator and negative south of the equator. | numeric | 9 (9,6) | | |||
| Longitude | Longitude coordinate for the city. Values will be negative for locations west of the prime meridian up to the international date line. They will be positive for locations east of the prime meridian. | numeric | 9 (9,6) | | |||
| OriginalCurrency | ISO 3-character code for the currency. For a complete list of codes, see tCurrency Table. | char | 3 | | |||
| AreaFips | FIPS code where the location resides. FIPS is an acronym for Federal Information Processing Standards. For a complete list of codes, see tGeography Table. | varchar | 15 | | |||
| ExposureDataSourceSID | Unique system-generated sequential identifier for the exposure data source record. For a complete list of records, see tDataSource Table | int | 4 | | |||
| ExposureDataSourceName | Name of the database that stores the exposure information. | varchar | 255 | | |||
| GeographySID | Unique system-generated sequential identifier for the geographic record. For a complete list of records, see tGeography Table. | int | 4 | | |||
| GeocoderCode | varchar | 10 | | ||||
| GeocoderAccountId | nvarchar | 50 | |