Stores country-level geography label information.
Touchstone 2022 Database Reference
tGeoLabel Table
| Creation Date | 5/10/2011 11:10 AM |
| File Group | PRIMARY |
| Text File Group | |
| System Object |  |
| Published for Replication | |
| Rows | 251 |
| Data Space Used | 8.00 KB |
| Index Space Used | 8.00 KB |
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
 | CountryCode | ISO 2-character code for the country in which the location resides. For a complete list of codes, see tCountry Table. | varchar | 30 | |||
| CrestaLabel | Label for the CRESTA within the country. | varchar | 255 |  | |||
| AreaLabel | Label for the area within the country, such as "State" or "District".. | varchar | 255 | | |||
| SubAreaLabel | Label for the subarea within the country, such as "County" or "Municipality". | varchar | 255 | | |||
| PostalLabel | Label for the postal code within the country, such as "ZIP5" or "4-digit postal code". | varchar | 255 | | |||
| SubArea2Label | Label for the level that is at a finer resolution than postal, such as "6-digit Area Unit Code " or "Sonpo code". | varchar | 255 | |