Report detail results for the Data Quality - Augmentation reports.
Touchstone 2022 Database Reference
tRRRR_DQ_AUG_ResultDetail Table
| Creation Date | 4/11/2022 5:46 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 | |||
| 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 source of the exposure data. | varchar | 255 | | |||
| AreaName | Name of the area. | 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 | | |||
| SubareaCode | Subarea code for the location. For a complete list of codes, see tGeography Table. | varchar | 15 | | |||
| SubAreaName | Name of the subarea. | varchar | 255 | | |||
| CountryName | Name of the country. | varchar | 255 | | |||
| LocationID | Unique user-provided identifier for the location. | varchar | 100 | | |||
| 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 | | |||
| AreaCode | Area code for the location. For a complete list of codes, see tGeography Table. | varchar | 15 | | |||
| 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 | | |||
| ContractSID | Unique system-generated sequential identifier for the contract record. For a complete list of records, see tContract Table. | int | 4 | | |||
| ExposureViewName | Name of the exposure view. | varchar | 255 | | |||
| ExposureSetSID | Unique system-generated sequential identifier for the exposure set record. For a complete list of records, see tExposureSet Table. | int | 4 | | |||
| 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 | | |||
| ExposureViewSID | Unique system-generated sequential identifier for the exposure view record. For a complete list of records, see tExposureView Table. | int | 4 | | |||
| ConstructionCode | Code that represents the construction type. For a complete list of codes, see tAIRConstruction Table. | int | 4 | | |||
| Address | Street address for the location. | varchar | 255 | | |||
| OccupancyCode | Code that represents the occupancy type. For a complete list of codes, see tAIROccupancy Table. | int | 4 | | |||
| OccupancyName | Name of the occupancy type. | varchar | 255 | | |||
| OriginalCurrency | ISO 3-character code for the currency. For a complete list of codes, see tCurrency Table. | char | 3 | | |||
| ReplacementValueA | Coverage A replacement value for the location. | float | 9 | | |||
| Stories | Height of the building. | smallint | 2 | | |||
| ReplacementValueD | Coverage D replacement value for the location. | float | 9 | | |||
| City | City in which the location resides | varchar | 255 | | |||
| ConstructionName | Name of the construction type. | varchar | 255 | | |||
| FormLOBSID | Unique system-generated sequential identifier for the contract's Line of Business. | int | 4 | | |||
| ReplacementValueC | Coverage C replacement value for the location. | float | 9 | | |||
| TotalInsuredValue | (TIV) Monetary value of coverage (across all coverages) paid out as a result of a catastrophe for the corresponding location. | float | 9 | | |||
| TotalReplacementValue | Sum of replacement value for all coverages. | float | 9 | | |||
| GrossArea | Total area of the location. | float | 9 | | |||
| 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) | | |||
| PolicyForm | Name of the policy form. | varchar | 60 | | |||
| ExposureSetName | Name of the exposure set. | varchar | 255 | | |||
| ReplacementValueB | Coverage B replacement value for the location. | float | 9 | | |||
| LocationSID | Unique system-generated sequential identifier for the location record. For a complete list of records, see tLocation Table. | int | 4 | | |||
| ISOBIN | Unique ISO Building Identification Number (BIN) corresponding to the location. | varchar | 14 | | |||
| NewBIN | ISOBIN after augmentation. | bit | 1 | | |||
| YearBuilt | Year the building corresponding to the location was built. | smallint | 2 | | |||
| ContractID | Unique user-provided identifier for the contract. | varchar | 100 | | |||
| 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) | | |||
| SubmitStatus | Code for the submission status. For a complete list of codes, see tSubmitStatus Table. | varchar | 60 | | |||
| LocPhyPropsBinData | Location’s physical properties. | binary | 768 | | |||
| GeographySID | Unique system-generated sequential identifier for the geographic record. For a complete list of records, see tGeography Table. | int | 4 | | |||
| AuditStatusCode | Code that represents the status of exposure data import. For a complete list of codes, see tAuditStatus Table. | int | 4 | | |||
| GeocoderCode | Code for the utility used to geocode the location. For a complete list of codes, see tGeocoder Table. GeocoderCode must be a valid code. The premium geocodes obtained by licensing this feature are restricted for use only within Touchstone and cannot be used outside of Touchstone. These are identified by the GeocoderCode = 'Syncsort' column in Touchstone AIRExposure, AIRReference and AIRResults databases. For the Export feature, these premium geocodes are either encrypted or removed during export to comply with these contractual restrictions. Direct extracts of premium geocodes from the Touchstone databases are also contractually prohibited. | varchar | 10 | | |||
| GeocoderAccountId | Identifier for the geocode account used for premium geocoding through Syncsort. Geocoder AccountId cannot be greater than 50 characters long. | nvarchar | 50 | |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
 | tRRRR_DQ_AUG_ResultValues | Table | Defines actual values referenced by the augmentation rules. Stores both user and industry value for easy comparison and augmentation. Referenced by the tRRRR_DQ_AUG_ResultDetail Table to provide multiple values per location. Each location affected by the augmentation should have an ISOBIN record within this table to keep track of the augmentation data source. | 1 |