Touchstone 2022 Database Reference
tCountryScheme Table
AIRGeography Database : tCountryScheme Table
Description
Stores the area and subarea schemes supported for each country.
Properties
Creation Date4/7/2017 2:01 PM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows138
Data Space Used8.00 KB
Index Space Used8.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key CountryCode

Code for the country.

For a complete list of codes, see tCountry Table.

varchar15   
Primary Key AreaScheme

Code that represents the area scheme for the country.

The area scheme specifies the type of area that the application supports for the country, for example, CRESTA.

int4   
 AreaSchemeNameName of the area scheme.varchar30   
 SubareaScheme

Code that represents the subarea scheme for the country.

The subarea scheme specifies the type of subarea that the application supports for the area, for example, county.

int4  
 SubareaSchemeNameName of the subarea scheme.varchar30  
 SubareaCodeAsName

Indicates whether the subarea scheme supports string values for subarea names.

  • 1 = Yes (supports strings)
  • 0 = No (supports only numeric codes)
bit1  
 IsAreaDefault

Indicates whether the subarea scheme is the default subarea scheme for the area scheme.

  • 1 = Yes (default)
  • 0 = No (not default)
bit1  
 ShowCrestaIdColumn

Not used by Touchstone.

bit1   
See Also

Related Objects

AIRGeography 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.