Touchstone 2022 Database Reference
tModelCountryXref Table
AIRUserSetting Database : tModelCountryXref Table
Description
System reference table that stores the countries associated with each user-imported model.
Properties
Creation Date4/4/2022 3:02 AM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows0
Data Space Used0.00 KB
Index Space Used0.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key ModelCode

Code that represents the user-imported model in the application.

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

  • 1 = Yes (previous version)
  • 0 = No (current version)
bit1 
((0))
 
Objects that tModelCountryXref depends on
 Database ObjectObject TypeDescriptionDep Level
tModel tabletModelTableStores information about models that users have imported into Touchstone.1
See Also

Related Objects

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