Stores the zone sets available in the application instance.
Touchstone Re 2022 Database Reference
tGlobalZoneSet Table
| Creation Date | 4/4/2022 3:03 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 | |
|---|---|---|---|---|---|---|---|
 | GlobalZoneSetSID | Unique system-generated sequential identifier for the zone set. | int | 4 | |||
| GlobalZoneSetName | Name of the zone set. | varchar | 255 |  | |||
| Description | Description of the zone set. | varchar | 255 | | |||
| CompatibilityType | Code that indicates whether you can use the zone set to run an aggregate loss, detailed loss, or geospatial analysis.
A zone set may be compatible with multiple analysis types. Touchstone Re applies a bitwise inclusive OR operator (|) to generate the code. For example, if a zone set is compatible with both Aggregate Loss and Detailed Loss analyses, Touchstone Re evaluates 1 | 2, and generates a code of 3. | int | 4 | |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
 | tGlobalZone | Table | Stores the zones that comprise the zone sets available in the application instance. | 1 |
| tGlobalZoneGeographyXRef | Table | System reference table that stores the geography sequential identifiers (SIDs) that correspond to each zone. | 2 |