Stores values that indicate the supported geocode match levels for each country.
Touchstone 2022 Database Reference
tCountrySupportedGeoLevel Table
| Creation Date | 3/21/2018 10:37 AM |
| File Group | PRIMARY |
| Text File Group | |
| System Object |  |
| Published for Replication | |
| Rows | 130 |
| Data Space Used | 8.00 KB |
| Index Space Used | 8.00 KB |
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
 | CountryCode | Code for the country. For a complete list of codes, see tCountry Table. | varchar | 15 | |||
| HasAREA | Indicates whether the application supports the area geocode match level for the country.
| bit | 1 |  | |||
| HasCRES | Indicates whether the application supports the CRESTA geocode match level for the country.
| bit | 1 | | |||
| HasSUBA | Indicates whether the application supports the subarea geocode match level for the country.
| bit | 1 | | |||
| HasPOST | Indicates whether the application supports the postal geocode match level for the country.
| bit | 1 | | |||
| HasSUB2 | Indicates whether the application supports the subarea 2 geocode match level for the country.
| bit | 1 | | |||
| HasDupAREA | Indicates whether multiple area-level records with the same ParentGeographySID exist and have the same name.
For a complete list of ParentGeographySIDs, see tGeography Table. | bit | 1 | | |||
| HasDupCRES | Indicates whether multiple CRESTA-level records with the same ParentGeographySID exist and have the same name.
For a complete list of ParentGeographySIDs, see tGeography Table. | bit | 1 | | |||
| HasDupSUBA | Indicates whether multiple subarea-level records with the same ParentGeographySID exist and have the same name.
For a complete list of ParentGeographySIDs, see tGeography Table. | bit | 1 | | |||
| HasDupPOST | Indicates whether multiple postal-level records with the same ParentGeographySID exist and have the same name.
For a complete list of ParentGeographySIDs, see tGeography Table. | bit | 1 | | |||
| HasDupSUB2 | Indicates whether multiple subarea 2-level records with the same ParentGeographySID exist and have the same name.
For a complete list of ParentGeographySIDs, see tGeography Table. | bit | 1 | |