| 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 database that stores the exposure information. | varchar | 255 | | |||
| LocationSID | Unique system-generated sequential identifier for the location record. For a complete list of records, see tLocation Table. | int | 4 | | |||
| LocationID | Unique identifier of the location flagged as being in violation of the rule(s). | 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 for the postal code. | varchar | 255 | | |||
| Address | 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 | | |||
| 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 | Name of the 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 | Unique user-provided identifier for the contract. | varchar | 100 | ||||
| ReplacementValueA | Coverage A replacement value for the location. | float | 9 | | |||
| ReplacementValueB | Coverage B replacement value for the location. | float | 9 | | |||
| ReplacementValueC | Coverage C replacement value for the location. | float | 9 | | |||
| ReplacementValueD | Coverage D replacement value for the location. | float | 9 | | |||
| TotalReplacementValue | Sum of replacement value for all coverages. | 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 | | |||
| 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) | | |||
| SubmitStatus | Code for the submission status. For a complete list of codes, see tSubmitStatus Table. | varchar | 60 | | |||
| ConstructionCode | Code that represents the construction type. For a complete list of codes, see tAIRConstruction Table. | int | 4 | | |||
| ConstructionName | Name of the construction type. | 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 | | |||
| TotalWeightedScore | Reserved for future use. | int | 4 | | |||
| InceptionDate | Inception date of the contract. Also referred to as the Effective FROM Date. | datetime | 4 | | |||
| ExpirationDate | Contract expiration date. Also referred to as the Effective TO Date. | datetime | 4 | | |||
| Stories | Height of the building. | smallint | 2 | | |||
| GrossArea | Total area of the location. | float | 9 | | |||
| ISOBIN | Unique ISO Building Identification Number (BIN) corresponding to the location. | varchar | 14 | | |||
| Premium | Combined premiums of flagged locations in the corresponding location. | float | 9 | | |||
| RiskCount | Total number of risks in the corresponding location. | int | 4 | | |||
| YearBuilt | Year the building corresponding to the location was built. | smallint | 2 | | |||
| StatusName | Name corresponds to the SubmitStatus value. | varchar | 200 | | |||
| PerilSet | Name corresponds to the PerilSetCode value. | varchar | 255 | | |||
| GeoMatchLevelCode | Code for the level at which geocode match occurred. For a complete list of codes, see tGeoMatchLevel Table. | varchar | 10 | | |||
| GeoMatchLevel | Name for the level at which geocode match occurred. | varchar | 50 | | |||
| 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 | | |||
| GeographySID | Unique system-generated sequential identifier for the geographic record. For a complete list of records, see tGeography Table. | int | 4 | | |||
| UserGeoMatchLevel | User-specified geocode match level. | varchar | 60 | | |||
| GeocoderCode | Code for the utility used to geocode the location. For a complete list of codes, see tGeocoder Table. 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. | nvarchar | 50 | |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
 | tRRRR_DQ_DVA_ResultDetailTerms | Table | Stores detailed term result for the Data Quality - Validation reports. | 1 |
| tRRRR_DQ_DVA_Violations | Table | Stores all Data Quality - Validation rule violations for each location record in tRRRR_DQ_DVA_ResultDetail Table. Each single table contains detail data for one report and each row represents a failed rule for specific location. The ViolationDescription attribute combines the information from rule and rule set for easy access. (For example "RV A is less than 50000") | 1 |