Stores information about both the user-provided zone sets for geospatial analysis and AIR-provided zone sets available in Touchstone.
Touchstone 2022 Database Reference
tZoneSet Table
Stores information about both the user-provided zone sets for geospatial analysis and AIR-provided zone sets available in Touchstone.
| Creation Date | 4/4/2022 3:02 AM |
| File Group | PRIMARY |
| Text File Group | |
| System Object |  |
| Published for Replication | |
| Rows | 66 |
| Data Space Used | 8.00 KB |
| Index Space Used | 24.00 KB |
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
 | ZoneSetSID | Unique system-generated sequential identifier for the zone set record. | int | 4 | |||
| BusinessUnitSID | Unique system-generated sequential identifier for the business unit record. | int | 4 | ||||
| ZoneSet | Name of the zone set. | varchar | 255 | ||||
| Description | Description of the zone set. | varchar | 4000 |  | |||
| EnteredDate | Date and time when the zone set was created. | datetime | 4 | (getutcdate()) | |||
| EditedDate | Date and time when the zone set was last modified. | datetime | 4 | (getutcdate()) | |||
| IsSystem | Indicates whether the zone set is AIR provided.
| bit | 1 | ((0)) |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
 | tZoneSetZoneXref | Table | System reference table that stores the zones that correspond to each AIR-provided zone set. | 1 |