Stores information about locations that generated loss during a detailed loss analysis.
Touchstone creates one dimension table for each analysis that included Location as an output option.
| 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 | |
|---|---|---|---|---|---|---|---|
 | ExposureDataSourceSID | Unique system-generated sequential identifier for the exposure data source record. 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 |  | |||
| ExposureSetName | Name of the exposure set. | varchar | 255 | | |||
| LocationID | Name of the exposure set. | varchar | 100 | ||||
| GeographySID | Unique system-generated sequential identifier for the geographic record. For a complete list of records, see tGeography Table. | int | 4 | ||||
| TotalReplacementValue | Sum of replacement values for all Coverages. | float | 9 | | |||
| CurrencyCode | ISO 3-character code for the currency. For a complete list of codes, see tCurrency Table. | char | 3 | ||||
| GeoMatchLevelCode | Code for the level at which geocode match occurred. For a complete list of codes, see tGeoMatchLevel Table. | varchar | 10 | | |||
| AIROccupancyCode | Code that represents the AIR occupancy code. For a complete list of codes, see tAIROccupancy Table. | smallint | 2 | | |||
| AIRConstructionCode | Code that represents the AIR occupancy code. For a complete list of codes, see tAIROccupancy Table. | smallint | 2 | | |||
| Stories | Total number of stories in the location. | smallint | 2 | | |||
| YearBuilt | Year the building was built. | smallint | 2 | | |||
| City | City in which the location resides. | varchar | 255 | | |||
| Address | Address for the location. | 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) | | |||
| ReplacementValueA | float | 9 | | ||||
| ReplacementValueB | float | 9 | | ||||
| ReplacementValueC | float | 9 | | ||||
| ReplacementValueD | float | 9 | | ||||
| ReplacementValueDaysCovered | int | 4 | | ||||
| Premium | float | 9 | | ||||
| Territory | varchar | 60 | | ||||
| InceptionDate | date | 8 | | ||||
| ExpirationDate | date | 8 | | ||||
| GrossArea | float | 9 | | ||||
| 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 | | |||
| ExposureCurrencyCode | ISO 3-character code for the currency. For a complete list of codes, see tCurrency Table. | char | 3 | ||||
| UserGeoMatchLevel | User-specified geocode match level. | varchar | 60 | | |||
| GeocoderCode | varchar | 10 | | ||||
| GeocoderAccountId | nvarchar | 50 | | ||||
| DamageFunctionID | varchar | 60 | |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
 | tRRRR_LOSS_ByLocation | Table | Stores location-level loss results from a detailed Loss analysis. This table is created when the user specifies "Save Loss By Location" in the analysis Output Options. | 1 |
| tRRRR_LOSS_ByLocationSummary | Table | Stores summary losses for one detailed loss analysis by location. Touchstone creates one table for each analysis that includes Location Summary as an output option. | 1 |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
| tRRRR_LOSS_DimExposureDataSource | Table | Stores information about databases that contain exposures that have been analyzed. This dimension table is created for every Loss analysis. | 1 |