| Creation Date | 4/11/2022 5:46 PM |
| File Group | PRIMARY |
| Text File Group | PRIMARY |
| 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 | |
|---|---|---|---|---|---|---|---|
 | ExposureDataSourceSID | Stores attributes associated with each location included in the analysis. These attributes are displayed on the user interface along with data from tRRRR_EC_ByLocation Table. For a complete list of records, see tDataSource Table. | int | 4 | |||
| | LocationSID | Unique system-generated sequential identifier for the location record. For a complete list of records, see tLocation Table. | int | 4 | |||
| ContractSID | Unique system-generated sequential identifier for the contract record. For a complete list of records, see tContract Table. | int | 4 |  | |||
| GeographySID | Unique system-generated sequential identifier for the geographic record. For a complete list of records, see tGeography Table. | int | 4 | | |||
| ExposureSetName | Name of the exposure set. | varchar | 255 | | |||
| LocationID | Unique user-provided identifier for the location. | varchar | 100 | ||||
| CurrencyCode | ISO 3-character code for the currency. For a complete list of codes, see tCurrency Table. | char | 3 | | |||
| AIRConstructionCode | AIR-defined construction code. For a complete list of codes, see tAIRConstruction Table. | smallint | 2 | | |||
| AIROccupancyCode | AIR-defined occupancy code. For a complete list of codes, see tAIROccupancy Table. | smallint | 2 | | |||
| City | City in which the location resides. | varchar | 255 | | |||
| Address | Street address for the location. | varchar | 255 | | |||
| Latitude | Latitude coordinate for the location. 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 location. 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) | | |||
| GeoMatchLevelCode | Code that represents the level at which geocode match occurred. For a complete list of codes, see tGeoMatchLevel Table. | varchar | 10 | | |||
| Stories | Total height of the structure. | tinyint | 1 | | |||
| YearBuilt | Year the structure was built. | smallint | 2 | | |||
| LocationGeo | geography | 0 | | ||||
| ReplacementValueA | float | 9 | | ||||
| ReplacementValueB | float | 9 | | ||||
| ReplacementValueC | float | 9 | | ||||
| ReplacementValueD | float | 9 | | ||||
| TotalReplacementValue | Accumulated replacement values of all Coverages (A, B, C, and D) for the location. | float | 9 | | |||
| RiskCount | Number of risks for the specified location record. | int | 4 | | |||
| PerilSetCode | int | 4 | | ||||
| Territory | varchar | 60 | | ||||
| UserDefined1 | User-defined field 1. | varchar | 60 | | |||
| UserDefined2 | User-defined field 2. | varchar | 60 | | |||
| UserDefined3 | User-defined field 3. | varchar | 60 | | |||
| UserDefined4 | User-defined field 4. | varchar | 60 | | |||
| UserDefined5 | User-defined field 5. | varchar | 60 | | |||
| UserGeoMatchLevel | User-specified geocode match level. | varchar | 60 | | |||
| Employees | Employee count, by location, within the analyzed area. | float | 9 | | |||
| DayShiftEmployees | Day-shift employee count, by location, within the analyzed area. | float | 9 | | |||
| EveningShiftEmployees | Evening-shift employee count, by location, within the analyzed area. | float | 9 | | |||
| NightShiftEmployees | Night-shift employee count, by location, within the analyzed area. | float | 9 | | |||
| 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. | nvarchar | 50 | |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
 | tRRRR_EC_ByLocation | Table | Stores the results of the Geospatial analysis at the latitude/longitude location-level. | 1 |