Stores the user-supplied geocode and AIR-specific geocode corresponding to each mapping set.
Touchstone 2022 Database Reference
tUserGeoMatchLevelMappingSet Table
Stores the user-supplied geocode and AIR-specific geocode corresponding to each mapping set.
| Creation Date | 4/4/2022 3:02 AM |
| File Group | PRIMARY |
| Text File Group | |
| System Object |  |
| Published for Replication | |
| Rows | 0 |
| Data Space Used | 0.00 KB |
| Index Space Used | 0.00 KB |
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
 | UserGeoMatchLevelMappingSetSID | Unique system-generated sequential identifier for the user-supplied geocode match level mappin set. | int | 4 | |||
| | UserGeoMatchLevelCode | Contains the user-supplied geocode match. | varchar | 60 | |||
| AIRGeoMatchLevelCode | Contain the AIR-specific geocode defined by Touchstone administrators. | varchar | 10 | ||||
| | CountryCode | Contains the country code for each match level mapping set. | varchar | 15 |