Touchstone 4.0 Database Documentation
tZone Table
Description

Stores information about the zones available in Touchstone. 

Information regarding the custom, user-defined zones is available in tZoneDefinition Table.

Properties
Creation Date5/31/2016 9:46 AM
File GroupPRIMARY
Text File GroupPRIMARY
System Object
Published for Replication
Rows66
Data Space Used16.00 KB
Index Space Used80.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key ZoneSIDUnique system-generated sequential identifier for the zone record.Integer4   
 BusinessUnitSID

Unique system-generated sequential identifier for the business unit record.

Integer4   
 ZoneName of the zone.VarChar255   
 PerilSetCode

Numeric code for the single peril or set of perils.

For a complete list of codes, see tPerilSet Table.

Integer4   
 DamageRatioDamage ratio (percent) associated with the zone.Single4  
 ZoneDefinitionTypeCode

Code that represents the zone definition type.

For a complete list of codes, see tZoneDefinitionType Table.

VarChar10   
 FilterSQLStringSQL representation of the user-selected geography filter.LongVarChar16  
 FilterExpression

XML string that defines the geography filter. Used internally by Touchstone.

Xml16  
 DescriptionDescription of the zone.VarChar4000  
Objects that depend on tZone
 Database ObjectObject TypeDescriptionDep Level
tZoneDefinition tabletZoneDefinitionTable

Stores information about the custom, user-defined zones.

Information regarding the AIR-provided zones is available in tZone Table.

1
tZoneSetZoneXref tabletZoneSetZoneXrefTableSystem reference table used  to associate the zones to zone sets.1
See Also

Related Objects

AIRUserSetting Database

 

 


AIR Client Confidential

© 2016. AIR Worldwide is a registered trademark. Touchstone is a registered trademark of AIR Worldwide.

Please contact AIR Worldwide with questions or comments. For database questions. For documentation comments.