Stores the zones that comprise the zone sets available in the application instance.
Touchstone Re 2022 Database Reference
tGlobalZone Table
Stores the zones that comprise the zone sets available in the application instance.
| 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 | |
|---|---|---|---|---|---|---|---|
 | GlobalZoneSID | Unique system-generated sequential identifier for the zone. | int | 4 | |||
| GlobalZoneSetSID | Unique system-generated sequential identifier for the zone set that includes the zone. For a complete list of records, see tGlobalZoneSet Table. | int | 4 | ||||
| GlobalZoneName | Name of the zone. | varchar | 255 |  | |||
| CompatibilityType | Code that indicates whether you can use the zone to run an aggregate loss, detailed loss, or geospatial analysis.
A zone may be compatible with multiple analysis types. Touchstone Re applies a bitwise inclusive OR operator (|) to generate the code. For example, if a zone 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 | |
|---|---|---|---|---|
 | tGlobalZoneGeographyXRef | Table | System reference table that stores the geography sequential identifiers (SIDs) that correspond to each zone. | 2 |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
| tGlobalZoneSet | Table | Stores the zone sets available in the application instance. | 2 |