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.
| Creation Date | 5/27/2011 3:35 PM |
| File Group | PRIMARY |
| Text File Group | |
| System Object |  |
| Published for Replication | |
| Rows | 3950044 |
| Data Space Used | 678,480.00 KB |
| Index Space Used | 3,005,480.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. The parent is a record in the tGeography table. For example, theParentGeographySID for the PostalCode will point to the SubareaCode for this specific PostalCode. | int | 4 |  | |||
| GeoLevelCode | Code that represents the highest resolution to which the location was validated. For a complete list of codes, see tGeoLevel Table. | varchar | 10 | ||||
| CountryCode | ISO 2-character code for the country. For a complete list of codes, see tCountry Table. | varchar | 15 | | |||
| CountryName | Name of the country. | varchar | 255 | | |||
| CRESTACode | CRESTA code for the location, where applicable. | varchar | 15 | | |||
| CRESTAName | CRESTA name. | varchar | 255 | | |||
| AreaCode | Area code for the location. | varchar | 15 | | |||
| AreaName | Name of the area. | varchar | 255 | | |||
| SubareaCode | Subarea code for the location. | varchar | 15 | | |||
| SubareaName | Name of the subarea. | varchar | 255 | | |||
| PostalCode | Postal code for the location. | varchar | 15 | | |||
| PostalName | Name for the postal code. | varchar | 255 | | |||
| 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:
| varchar | 15 | | |||
| Subarea2Name | Subarea2 name. | varchar | 255 | | |||
| Latitude | Latitude coordinate for the record. 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 record. 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) | | |||
| CountryGeographySID | Unique system-generated sequential identifier for the country record. | int | 4 | | |||
| CRESTAGeographySID | Unique system-generated sequential identifier for the CRESTA record. This field will not be populated when the AreaGeographySID field contains a value. | int | 4 | | |||
| AreaGeographySID | Unique system-generated sequential identifier for the area record. This field will not be populated when the CRESTAGeographySID field contains a value. | int | 4 | | |||
| SubareaGeographySID | Unique system-generated sequential identifier for the subarea record. | int | 4 | | |||
| PostalGeographySID | Unique system-generated sequential identifier for the postal record. | int | 4 | | |||
| Subarea2GeographySID | Unique system-generated sequential identifier for the subarea2 record. | int | 4 | | |||
| RemappedGeographySID | Unique system-defined identifier for the remapped geography record. | int | 4 | | |||
| GuidExternal | GUID of the boundary as supplied from tblAreaExternal. | binary | 16 | | |||
| GuidRemodel | Globally unique identifier for the remodeled record. This identifier will join the tGeography and TblAreaExternal tables. | binary | 16 | | |||
| AreaScheme | Area scheme path for the validated location. | smallint | 2 | | |||
| IsReinsuranceGeography | Indicates whether you can run an aggregate loss analysis using the geography.
| bit | 1 | | ((0)) | ||
| IsDetailLossGeography | Indicates whether you can run a detailed loss analysis using the geography.
| bit | 1 | |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
 | tReinsuranceGeographyEMM | Table | 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. | 1 |