Stores report details for the Data Quality - Industry Data Benchmark reports.
Touchstone 2022 Database Reference
tRRRR_DQ_IDB_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 | |||
| CountryName | Name of the country. | varchar | 255 |  | |||
| AreaName | Name of the area. | varchar | 255 | | |||
| SubAreaName | Name of the subarea. | varchar | 255 | | |||
| CountryCode | ISO 2-character code for the country in which the location resides. For a complete list of codes, see tCountry Table. | varchar | 15 | | |||
| AreaCode | Area code for the location. For a complete list of codes, see tGeography Table. | varchar | 15 | | |||
| SubareaCode | Subarea code for the location. For a complete list of codes, see tGeography Table. | varchar | 15 | | |||
| UserLineOfBusiness | User's Line of Business. | varchar | 60 | | |||
| ConstructionCode | Code that represents the construction type. For a complete list of codes, see tAIRConstruction Table. | int | 4 | | |||
| OccupancyCode | Code that represents the occupancy type. For a complete list of codes, see tAIROccupancy Table . | int | 4 | | |||
| RiskCount | Total number of risks in the corresponding location. | int | 4 | | |||
| ExposureViewName | Name of the exposure view. | varchar | 255 | | |||
| ExposureSetName | Name of the exposure set. | varchar | 255 | | |||
| ContractID | Unique identifier for the contract. | varchar | 100 | | |||
| ExposureViewSID | Unique system-generated sequential identifier for the exposure view record. For a complete list of records, see tExposureView Table. | int | 4 | | |||
| ExposureSetSID | Unique system-generated sequential identifier for the exposure set record. For a complete list of records, see tExposureSet Table. | int | 4 | | |||
| ContractSID | Unique system-generated sequential identifier for the contract record. For a complete list of records, see tContract Table. | int | 4 | | |||
| guidAreaExternal | GUID for the geography information. Same value as GeographySID. | dbo.GUID | 16 | | |||
| UserReplacementValueA | User-supplied Coverage A replacement value. | float | 9 | | |||
| UserReplacementValueC | User-supplied Coverage C replacement value. | float | 9 | | |||
| UserReplacementValueD | User-supplied Coverage D replacement value. | float | 9 | | |||
| IndustryReplacementValueA | Industry replacement value for Coverage A. | float | 9 | | |||
| IndustryReplacementValueC | Industry replacement value for Coverage C. | float | 9 | | |||
| IndustryReplacementValueD | Industry replacement value for Coverage D. | float | 9 | | |||
| GeographySID | Unique system-generated sequential identifier for the geographic record. For a complete list of records, see tGeography Table. | int | 4 | |