Touchstone 2022 Database Reference
tModelCountryXref Table
AIRReference Database : tModelCountryXref Table
Description
System reference table used to determine the countries that are covered by the model.
Properties
Creation Date7/5/2012 3:19 PM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows404
Data Space Used8.00 KB
Index Space Used24.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key ModelCode

Code that represents the model in Touchstone.

For a complete list of codes, see tModel Table.

smallint2   
Primary Key CountryCode

ISO 2-character code for the country associated with the model. 

For a complete list of codes, see tCountry Table.

varchar15   
Primary Key IsPreviousVersionModel

Indicates whether the model version corresponds to the current or previous version of the AIR models.

  • 1 = Yes (previous version)
  • 0 = No (current version)
bit1 
((0))
 
Objects that tModelCountryXref depends on
 Database ObjectObject TypeDescriptionDep Level
tModel tabletModelTableStores information about the models that are available in Touchstone.1
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.