A support table that contains the unique set of all geographies for an Exposure Summary. Reserved for future use.
Touchstone 2022 Database Reference
tEXPS_ByGeography Table
A support table that contains the unique set of all geographies for an Exposure Summary. Reserved for future use.
| 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 | |
|---|---|---|---|---|---|---|---|
 | ResultSID | Unique system-generated sequential identifier for the results record. For a complete list of records, see tAnalysisResult Table. | int | 4 | |||
| | CountryCode | ISO 2-character code for the country in which the location resides. For a complete list of codes, see tCountry Table. | varchar | 15 | |||
| | CRESTACode | CRESTA code for the location, when applicable. 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 | |||
| | SubareaCode | Subarea 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 | |||
| | Subarea2Code | Area level code at a finer resolution than postal. This is populated when a country has more than four codes. This field is used by three countries:
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 |  | |||
| CountryName | Name of the country. | varchar | 255 | ||||
| CRESTAName | Name of the CRESTA, when applicable. | varchar | 255 | ||||
| AreaName | Name of the area. | varchar | 255 | ||||
| SubareaName | Name of the subarea. | varchar | 255 | ||||
| PostalName | Name for the postal code. | varchar | 255 | ||||
| Subarea2Name | Name for the Subarea2 code. | varchar | 255 | ||||
| Locations | Total number of locations within the designated geography. | bigint | 8 | | |||
| PercentOfLocations | Number of locations within the designated geography, expressed as a percent of all the locations. | real | 4 | | |||
| TotalReplacementValue | Accumulated replacement value for all locations | float | 9 | | |||
| PercentOfTRV | Total combined replacement value for all locations within the designated Coverage band, expressed as a percent of the total replacement value. | real | 4 | | |||
| ReplacementValueA | Accumulated Coverage A replacement value for all locations within the designated geography. | float | 9 | | |||
| ReplacementValueB | Accumulated Coverage B replacement value for all locations within the designated geography. | float | 9 | | |||
| ReplacementValueC | Accumulated Coverage C replacement value for all locations within the designated geography. | float | 9 | | |||
| ReplacementValueD | Accumulated Coverage D replacement value for all locations within the designated geography. | float | 9 | | |||
| Premium | Combined premiums for all locations within the designated geography. | float | 9 | | |||
| RiskCount | Total number of risks within the designated geography. May differ from the Location Count value if any of your location records represent aggregate data. | bigint | 8 | | |||
| Limit1 | Accumulated Coverage A limit for all locations within the designated geography. | float | 9 | | |||
| Limit2 | Accumulated Coverage B limit for all locations within the designated geography. | float | 9 | | |||
| Limit3 | Accumulated Coverage C limit for all locations within the designated geography. | float | 9 | | |||
| Limit4 | Accumulated Coverage D limit for all locations within the designated geography. | float | 9 | | |||
| Deductible1 | Accumulated Coverage A deductible amount for all locations within the designated geography. | float | 9 | | |||
| Deductible2 | Accumulated Coverage B deductible amount for all locations within the designated geography. | float | 9 | | |||
| Deductible3 | Accumulated Coverage C deductible amount for all locations within the designated geography. | float | 9 | | |||
| Deductible4 | Accumulated Coverage D deductible amount for all locations within the designated geography. | float | 9 | |