Stores the mappings between each area and the model that corresponds to the area for the current version of the application.
Touchstone 2022 Database Reference
TblAreaModel Table
| Creation Date | 1/22/2015 6:44 AM |
| File Group | PRIMARY |
| Text File Group | |
| System Object |  |
| Published for Replication | |
| Rows | 628582 |
| Data Space Used | 58,144.00 KB |
| Index Space Used | 216,216.00 KB |
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
 | guidUser | GUID of the user. | dbo.GUID | 16 | |||
| intUserLevel1 | User's country. | smallint | 2 | ||||
| strUserLevel2 | User's area or CRESTA. | varchar | 15 |  | |||
| strUserLevel3 | User's subarea. | varchar | 15 | | |||
| strUserLevel4 | User's postal code. | varchar | 15 | | |||
| guidModel | GUID of the model record. | dbo.GUID | 16 | ||||
| intModelLevel1 | Model's country. | smallint | 2 | ||||
| strModelLevel2 | Model's area or CRESTA. | varchar | 15 | | |||
| strModelLevel3 | Model's subarea. | varchar | 15 | | |||
| strModelLevel4 | Model's postal code. | varchar | 15 | | |||
| tuidSchemePath | Identifier for the area's scheme path code. | smallint | 2 | | |||
| tuidModelSchemePath | Identifier for the model's scheme path code. | smallint | 2 | |