Stores the validated geographic information that Touchstone Re displays on the user interface for countries that support custom lines of business, models, and event sets.
| Creation Date | 1/17/2019 5:10 PM |
| File Group | PRIMARY |
| Text File Group | |
| System Object |  |
| Published for Replication | |
| Rows | 564 |
| Data Space Used | 80.00 KB |
| Index Space Used | 24.00 KB |
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
 | GeographySID | Unique system-generated sequential identifier for the geography record. | int | 4 | |||
| ParentGeographySID | Unique system-generated sequential identifier for the parent geography record. A parent geography record is another related record in the table. For example, theParentGeographySID for a postal code record points to the subarea code record associated with the postal code. | int | 4 |  | |||
| GeoLevelCode | Code that represents the resolution of the geography record. For a complete list of codes, see tGeoLevel Table. | varchar | 10 | ||||
| CountryCode | ISO 2-character code for the country associated with the geography record. For a complete list of codes, see tCountry Table. | varchar | 15 | | |||
| CountryName | Name of the country. | varchar | 255 | | |||
| CRESTACode | CRESTA code associated with the geography record. | varchar | 15 | | |||
| CRESTAName | Name of the CRESTA associated with the geography record. | varchar | 255 | | |||
| AreaCode | Code for the area associated with the geography record. | varchar | 15 | | |||
| AreaName | Name of the area associated with the geography record. | varchar | 255 | | |||
| SubareaCode | Code for the subarea associated with the geography record. | varchar | 15 | | |||
| SubareaName | Name of the subarea associated with the geography record. | varchar | 255 | | |||
| PostalCode | Postal code associated with the geography record. | varchar | 15 | | |||
| PostalName | Name of the postal code associated with the geography record. | varchar | 255 | | |||
| Subarea2Code | Area level code at a finer resolution than the postal code associated with the geography record. The field is populated only for countries with more than four geography level codes, for example:
| varchar | 15 | | |||
| Subarea2Name | Name of the subarea 2 code associated with the geography record. | varchar | 255 | | |||
| Latitude | Latitude coordinate associated with the geography record. A positive value indicates a location north of the equator. A negative value indicates a location south of the equator. | numeric | 9 (9,6) | | |||
| Longitude | Longitude coordinate associated with the geography record. A positive value indicates a location east of the prime meridian. A negative value indicates a location west of the prime meridian. | numeric | 9 (9,6) | | |||
| CountryGeographySID | Unique system-generated sequential identifier for the country. | int | 4 | | |||
| CRESTAGeographySID | Unique system-generated sequential identifier for the CRESTA. | int | 4 | | |||
| AreaGeographySID | Unique system-generated sequential identifier for the area. | int | 4 | | |||
| SubAreaGeographySID | Unique system-generated sequential identifier for the subarea. | int | 4 | | |||
| PostalGeographySID | Unique system-generated sequential identifier for the postal code. | int | 4 | | |||
| Subarea2GeographySID | Unique system-generated sequential identifier for the subarea 2. | int | 4 | | |||
| RemappedGeographySID | Unique system-generated sequential identifier for the remapped geography record. | int | 4 | | |||
| GuidExternal | Globally unique identifier for the boundary. For a complete list of records, see TblAreaExternal Table. | binary | 16 | | |||
| GuidRemodel | Globally unique identifier for the remodeled boundary. The identifier joins the table and the TblAreaExternal Table. | binary | 16 | | |||
| AreaScheme | Area scheme path for the geography record. | smallint | 2 | | |||
| IsReinsuranceGeography | Indicates whether you can run an aggregate loss analysis using the geography.
| bit | 1 | | ((1)) | ||
| IsDetailLossGeography | Indicates whether you can run a detailed loss analysis using the geography.
| bit | 1 | |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
 | tGeography | Table | Stores the post-validation geographical area information that the application displays on the user interface. After you import exposure data, the application writes the data to TblAreaExternal Table and validates the data using the airsp_ValidateArea stored procedure. Then, the application updates the records in tGeography to match the content of TblAreaExternal. | 1 |