Stores information about both the AIR-provided and user-created zones for geospatial analyses.
Touchstone 2022 Database Reference
tZone Table
Stores information about both the AIR-provided and user-created zones for geospatial analyses.
| Creation Date | 4/4/2022 3:02 AM |
| File Group | PRIMARY |
| Text File Group | PRIMARY |
| System Object |  |
| Published for Replication | |
| Rows | 66 |
| Data Space Used | 16.00 KB |
| Index Space Used | 80.00 KB |
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
 | ZoneSID | Unique system-generated sequential identifier for the zone record. | int | 4 | |||
| BusinessUnitSID | Unique system-generated sequential identifier for the business unit record. | int | 4 | ||||
| Zone | Name of the zone. | varchar | 255 | ||||
| PerilSetCode | Numeric code for the single peril or set of perils. For a complete list of codes, see tPerilSet Table. | int | 4 | ||||
| DamageRatio | Damage ratio (percent) associated with the zone. | real | 4 |  | |||
| ZoneDefinitionTypeCode | Code that represents the zone definition type. For a complete list of codes, see tZoneDefinitionType Table. | varchar | 10 | ||||
| FilterSQLString | SQL representation of the user-selected geography filter. | varchar | 16 | | |||
| FilterExpression | XML string that defines the geography filter. Used internally by Touchstone. | xml | 0 | | |||
| Description | Description of the zone. | varchar | 4000 | |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
 | tZoneDefinition | Table | Stores information about the AIR-provided zones for geospatial analyses. For information about the AIR-provided zones, see tZone Table. For information about user-defined zones for other analyses, see tGlobalZone Table. | 1 |
| tZoneSetZoneXref | Table | System reference table that stores the zones that correspond to each AIR-provided zone set. | 1 |