Touchstone 2022 Database Reference
tGeoLevel Table
AIRReference Database : tGeoLevel Table
Description

Stores codes that represent geographic levels.

Properties
Creation Date2/16/2011 6:00 PM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows8
Data Space Used8.00 KB
Index Space Used8.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key GeoLevelCode

Code that represents the geographic levels.

  • AREA = Area
  • COUN = Country
  • CRES = CRESTA
  • LOC = Location
  • POST = Postal
  • SUB2 = Subarea2
  • SUBA = Subarea
  • ZONE = Custom Zone
varchar10   
 GeoLevel

Name of the geographic levels.

Corresponds to the code in GeoLevelCode.

varchar40  
 Description

Description of the geographic levels.

varchar1024  
Objects that depend on tGeoLevel
 Database ObjectObject TypeDescriptionDep Level
tImpactRegionPerilSet tabletImpactRegionPerilSetTable

Stores the possible groups of geographic areas impacted by specific peril sets identified by the Marginal Impact analysis options.

1
tImpactRegionPerilSetXref tabletImpactRegionPerilSetXrefTableSystem reference table used to determine the possible geographic areas impacted by specific peril sets. This table is not human-readable.2
See Also

Related Objects

AIRReference Database

 

 

Verisk Analytics Client Confidential

© 2022. AIR Worldwide is now Extreme Event Solutions. AIR Worldwide is a registered trademark. Touchstone is a registered trademark of AIR Worldwide.

Please contact Verisk Analytics with questions or comments.