Stores internal identifiers for each geography SID (sequential identifier).
Touchstone 2022 Database Reference
TblAreaExternalInternalXref Table
| Creation Date | 6/7/2018 12:59 PM |
| File Group | PRIMARY |
| Text File Group | |
| System Object |  |
| Published for Replication | |
| Rows | 3528396 |
| Data Space Used | 73,320.00 KB |
| Index Space Used | 63,216.00 KB |
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
 | geographysid | Unique system-generated sequential identifier for the geographic record. For a complete list of codes, see tGeography Table. | int | 4 | |||
| intLevel1 | Internal identifier for the country. | smallint | 2 |  | |||
| intLevel2 | Internal identifier for the area. | smallint | 2 | | |||
| intLevel3 | Internal identifier for the subarea. | int | 4 | |