Stores area scheme path definitions and area scheme path chains.
Touchstone 2022 Database Reference
TblAreaSchemePath Table
| Creation Date | 9/8/2004 2:11 PM |
| File Group | PRIMARY |
| Text File Group | |
| System Object |  |
| Published for Replication | |
| Rows | 141 |
| Data Space Used | 8.00 KB |
| Index Space Used | 72.00 KB |
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
 | tuidSchemePath | Identifier for the area scheme path code. | smallint | 2 | |||
| strName | Name of the area scheme path. | varchar | 30 | ||||
| strDesc | Description of the area scheme path. | varchar | 100 |  | |||
| tuidSchemeL0 | Schema for the region. | smallint | 2 | ||||
| tuidSchemeL1 | Schema for the country. | smallint | 2 | (0) | |||
| tuidSchemeL2 | Schema for the area or CRESTA. | smallint | 2 | (0) | |||
| tuidSchemeL3 | Schema for the subarea. | smallint | 2 | (0) | |||
| tuidSchemeL4 | Schema for the postal code. | smallint | 2 | (0) | |||
| tuidSchemePathL0 | Scheme path for the region. | smallint | 2 | | |||
| tuidSchemePathL1 | Scheme path for the country. | smallint | 2 | | |||
| tuidSchemePathL2 | Scheme path for the area or CRESTA. | smallint | 2 | | |||
| tuidSchemePathL3 | Scheme path for the subarea. | smallint | 2 | | |||
| tuidSchemePathL4 | Scheme path for the postal code. | smallint | 2 | | |||
| tuidUserSchemeL3 | Users's scheme path for the subarea, for use with legacy code. When tuidSchemePathL3 contains a postal code, this value is usually 0. | smallint | 2 | | |||
| tuidUserSchemeL4 | User's scheme path for the postal code, for use with legacy code. When tuidSchemePathL3 contains a postal code, the postal code is included in this field as well. | smallint | 2 | |