Stores information about the location used during the Comparative Loss analysis.
Touchstone 2022 Database Reference
tRRRR_CMPLOSS_GeoKey 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 | |
|---|---|---|---|---|---|---|---|
 | GeoRowID | System-assigned table row identifier for the location. | bigint | 8 | |||
| GeoLevel | Code that represents the geocode level. For a complete list of codes, see dbo.tGeoLevel Table. | smallint | 2 |  | |||
| ExposureDataSourceSID | Unique system-generated sequential identifier for the exposure data source record. For a complete list of records, see dbo.tDataSource Table. | int | 4 | | |||
| LocationSID | Unique system-generated sequential identifier for the location record. For a complete list of records, see dbo.tLocation Table. | int | 4 | | |||
| ExposureSetName | Unique user-defined name for the exposure set. For a complete list of exposure sets, see dbo.tExposureSet Table. | varchar | 255 | | |||
| ContractID | Unique user-defined identifier for the contract. For a complete list of contracts, see dbo.tContract Table. | varchar | 100 | | |||
| LocationID | Unique user-defined identifier for the location. Corresponds to the identifier in LocationSID | varchar | 100 | | |||
| CountryGeographySID | Unique system-generated sequential identifier for the country record. For a complete list of identifiers, see dbo.tGeography Table. | int | 4 | | |||
| AreaGeographySID | Unique system-generated sequential identifier for the area record. For a complete list of identifiers, see dbo.tGeography Table. | int | 4 | | |||
| SubAreaGeographySID | Unique system-generated sequential identifier for the subarea record. For a complete list of identifiers, see dbo.tGeography Table. | int | 4 | | |||
| PostalGeographySID | Unique system-generated sequential identifier for the postal record. For a complete list of identifiers, see dbo.tGeography Table. | int | 4 | |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
 | tRRRR_TTTT_CMPLOSS_GeoAAL | Table | Stores the deltas in the aggregate average annual losses by location that are calculated during a Comparative Loss analysis.
tRRRR denotes the Results SID for the Comparative Loss analysis and TTTT represents the identifier for the loss analysis.
| 1 |