Stores valid area information.
Touchstone 2022 Database Reference
TblAreaExternal Table
| Creation Date | 12/10/2008 9:17 AM |
| File Group | PRIMARY |
| Text File Group | |
| System Object |  |
| Published for Replication | |
| Rows | 3950052 |
| Data Space Used | 634,328.00 KB |
| Index Space Used | 4,492,784.00 KB |
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
 | guidExternal | GUID of the record. | dbo.GUID | 16 | |||
| guidInternal | GUID of the record, reserved for internal use only. | dbo.GUID | 16 |  | |||
| intYear | Year of the data. | smallint | 2 | | |||
| tuidSchemePath | Identifier for the area scheme path. | smallint | 2 | ||||
| intLevel | Geographic level for the record.
| tinyint | 1 | | |||
| intSortIndex | Sort index, for internal use only. | int | 4 | | |||
| intLevel0 | Region identifier | tinyint | 1 | | |||
| intLevel1 | Country identifier. | smallint | 2 | | |||
| strLevel2 | Area or CRESTA identifier. | varchar | 15 | | |||
| strLevel3 | Subarea identifier. | varchar | 15 | | |||
| strLevel4 | Postal code identifier. | varchar | 15 | | |||
| fltGeoLat | Latitude coordinate. Values will be positive for locations north of the equator and negative south of the equator. | real | 4 | | ((0.0)) | ||
| fltGeoLong | Longitude coordinate. 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. | real | 4 | | ((0.0)) | ||
| strName | Name of the area. | varchar | 60 | | |||
| strBriefName | Brief name of the area. | varchar | 10 | | |||
| guidExternalModel | The corresponding model GUID for the non-modeled postal code, if applicable. | varbinary | 16 | | |||
| strL1Name | Country name. | varchar | 60 | | |||
| strL2Name | Area or CRESTA name. | varchar | 60 | | |||
| strL3Name | Subarea name, if applicable. | varchar | 60 | | |||
| strL4Name | Postal name, if applicable. | varchar | 60 | | |||
| strL1BriefName | Brief name for the country, for example, MX for Mexico. | dbo.AREANAME | 60 | | |||
| strL2BriefName | Brief name for the area, for example, AL for the state of Alabama in the United States. | dbo.AREANAME | 60 | | |||
| GeographySID | Unique system-generated sequential identifier for the geographic record. For a complete list of records, see tGeography Table. | int | 4 | |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
 | TblAreaDistribution_xref | Table | Stores reference data that the application uses to retrieve the highest weighted areas and to assign values to areas that do not have a sufficiently high weight. | 1 |
| TblSourceDefaultTarget_Xref | Table | Stores information that the application uses in the airsp_EA_PagingPrepare stored procedure to retrieve the highest weighted regions and to assign values to regions that do not have a high enough weight. | 1 |
| TblSourceDefaultTargetWc_Xref | Table | Stores information that the application uses in the airsp_EA_PagingPrepare stored procedure to retrieve the highest weighted regions for Workers' Compensation and to assign values to regions that do not have a high enough weight. | 1 |
| TblSourceTargetMap_ANZ | Table | Stores the grid identifier and weight type that corresponds to each source code. The table also stores 'look-up' area codes that the application uses for disaggregated locations in Australia and New Zealand and the weight for each location. | 1 |
| TblSourceTargetMap_BRA | Table | Stores the grid identifier and weight type that corresponds to each source code. The table also stores 'look-up' area codes that the application uses for disaggregated locations in Brazil and the weight for each location. | 1 |
| TblSourceTargetMap_CAM | Table | Stores the grid identifier and weight type that corresponds to each source code. The table also stores 'look-up' area codes that the application uses for disaggregated locations in Central America and the weight for each location. | 1 |
| TblSourceTargetMap_CAN | Table | Stores the grid identifier and weight type that corresponds to each source code. The table also stores 'look-up' area codes that the application uses for disaggregated locations in Canada and the weight for each location. | 1 |
| TblSourceTargetMap_CAR | Table | Stores grid identifier and weight type that corresponds to each source code.The table also stores 'look-up' area codes that the application uses for disaggregated locations in Central African Republic (CAR) and the weight for each location. | 1 |
| TblSourceTargetMap_CHI | Table | Stores the grid identifier and weight type that corresponds to each source code. The table also stores 'look-up' area codes that the application uses for disaggregated locations in China and the weight for each location. | 1 |
| TblSourceTargetMap_EUR | Table | Stores the grid identifier and weight type that corresponds to each source code. The table also stores 'look-up' area codes that the application uses for disaggregated locations in Europe and the weight for each location. | 1 |
| TblSourceTargetMap_IND | Table | Stores the grid identifier and weight type that corresponds to each source code. The table also stores 'look-up' area codes that the application uses for disaggregated locations in India and the weight for each location. | 1 |
| TblSourceTargetMap_JAP | Table | Stores the grid identifier and weight type that corresponds to each source code. The table also stores 'look-up' area codes that the application uses for disaggregated locations in Japan and the weight for each location. | 1 |
| TblSourceTargetMap_MEU | Table | Stores the grid identifier and weight type that corresponds to each source code. The table also stores 'look-up' area codes that the application uses for disaggregated mid-European locations and the weight for each location. | 1 |
| TblSourceTargetMap_MEX | Table | Stores the grid identifier and weight type that corresponds to each source code. The table also stores 'look-up' area codes that the application uses for disaggregated locations in Mexico and the weight for each location. | 1 |
| TblSourceTargetMap_SAM | Table | Stores the grid identifier and weight type that corresponds to each source code. The table also stores 'look-up' area codes that the application uses for disaggregated locations in South America and the weight for each location. | 1 |
| TblSourceTargetMap_SEA | Table | Stores the grid identifier and weight type that corresponds to each source code. The table also stores 'look-up' area codes that the application uses for disaggregated locations in Southeast Asia and the weight for each location. | 1 |
| TblSourceTargetMap_SEU | Table | Stores the grid identifier and weight type that corresponds to each source code. The table also stores 'look-up' area codes that the application uses for disaggregated southern-European locations and the weight for each location. | 1 |
| TblSourceTargetMap_US | Table | Stores the grid identifier and weight type that corresponds to each source code. The table also stores 'look-up' area codes that the application uses for disaggregated locations in the United States and the weight for each location. | 1 |
| TblSourceTargetMapWC_JAP | Table | Stores the grid identifier and weight type that corresponds to each source code. The table is used for workers' compensation and also stores 'look-up' area codes that the application uses for disaggregated locations in Japan and the weight for each location. | 1 |