Touchstone 4.0 Database Documentation
tModel Table
Description
Stores information regarding the models that are available via Touchstone.
Properties
Creation Date2/16/2011 6:00 PM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows60
Data Space Used8.00 KB
Index Space Used8.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key ModelCode

Code that represents the model in Touchstone.

  • 1 = AIR Terrorism Model (M01 US TR)
  • 2 = AIR  Workers' Compensation Model for the U.S. (M02 US WC)
  • 3 = AIR Personal Accident Model for Japan (M03 Jpn PA)
  • 4 = AIR Longevity
  • 5 = AIR Wildfire Model for California (M05 US WF)
  • 6 = AIR Australia Bushfire (M06 Aus BF)
  • 7 = AIR Multi-Perils Crop Insurance Model for the U.S.
  • 8 = AIR Flood Model for the U.S. (M08 US FL)
  • 11 = AIR Earthquake Model for the U.S. (M11 US EQ)
  • 12 = AIR Earthquake Model for Canada (M12 Can EQ)
  • 13 = AIR Earthquake Model for Hawaii (M13 Haw EQ)
  • 14 = AIR Earthquake Model for Alaska (M14 Ala EQ)
  • 15 = AIR Earthquake Model for the Caribbean (M15 Car EQ)
  • 20 = AIR Severe Thunderstorm Model for the U.S. and Canada (M20 NorAm ST)
  • 21 = AIR Hurricane Model for the U.S. (M27 NorAtl TC)
  • 22 = AIR Severe Thunderstorm Model for the U.S. (M20 NorAm ST)
  • 23 = AIR Hurricane Model for Hawaii (M23 Haw TC)
  • 24 = AIR U.S. Hurricane Model for Offshore Assets (M27 NorAtl TC)
  • 25 = AIR Tropical Cyclone Model for the Caribbean (M27 NorAtl TC)
  • 26 = AIR Severe Thunderstorm Model for Canada (M20 NorAm ST)
  • 27 = AIR North Atlantic Basinwide Hurricane Model (M27 NorAtl TC)
  • 28 = AIR Winter Storm Model for the U.S. (M28 US WS)
  • 29 = AIR Tropical Cyclone Model for Mexico (M27 NorAtl TC)
  • 30 = AIR Tropical Cyclone Model for Canada (M30 Can TC)
  • 31 = AIR Earthquake Model for the Pan-European Region (M31 Eur EQ)
  • 33 = AIR Earthquake Model for Southeast Europe
  • 41 = AIR Extratropical Cyclone Model for Europe (M41 Eur ETC)
  • 42 = AIR Winter Storm Model  for Canada (M42 Can WS)
  • 51 = AIR Earthquake Model for Australia (M51 Aus EQ)
  • 52 = AIR Earthquake Model for Japan (M52 Jpn EQ)
  • 53 = AIR Earthquake Model for New Zealand (M53 NZ EQ)
  • 54 = AIR Earthquake Model for Southeast Asia (M54 SEA EQ)
  • 55 = AIR Earthquake Model for China (M55 Chi EQ)
  • 58 = AIR Earthquake Model for India (M58 Ind EQ)
  • 60 = AIR Northwest Pacific Basinwide Typhoon Model (M60 NorPac TC)
  • 61 = AIR Cyclone Model for Australia (M61 Aus TC)
  • 62 = AIR Typhoon Model for Japan (M60 NorPac TC)
  • 63 = AIR Typhoon Model for New Zealand
  • 64 = AIR Typhoon Model for Southeast Asia (M60 NorPac TC)
  • 65 = AIR Typhoon Model for China (M60 NorPac TC)
  • 66 = AIR Typhoon Model for South Korea (M60 NorPac TC)
  • 67 = AIR Tropical Cyclone Model for Central America (M27 NorAtl TC)
  • 68 = AIR Tropical Cyclone for India (M68 Ind TC)
  • 70 = AIR Earthquake Model for South America (M70 SouAm EQ)
  • 71 = AIR Earthquake Model for Colombia (M70 SouAm EQ)
  • 72 = AIR Earthquake Model for Mexico (M72 Mex EQ)
  • 73 = AIR Earthquake Model for Chile  (M70 SouAm EQ)
  • 74 = AIR Earthquake Model for Venezuela (M70 SouAm EQ)
  • 75 = AIR Earthquake Model for Peru (M70 SouAm EQ)
  • 76 = AIR Earthquake Model for Central America (M76 CenAm EQ)
  • 81 = AIR Global Pandemic Flu
  • 85 = AIR Multi-Perils Crop Insurance Model for China
  • 90 = AIR Inland Flood Model for Central Europe (M90 CenEur FL)
  • 91 = AIR Flood Model for Great Britain (M91 UK CFL)
  • 92 = AIR Inland Flood Model for Great Britain (M92 UK FL)
  • 93 = AIR Inland Flood Model for Germany (M93 Ger FL)
  • 94 = AIR Inland Flood model for Southeast Europe
  • 95 = AIR Inland Flood Model for Austria, Czechoslovakia, and Switzerland (M95 Cze FL)
  • 230 = ERN Earthquake model for Mexico
  • 231 = ERN Tropical Cyclone Model for Mexico
UnsignedTinyInt1   
 Model

Name of the model.

Corresponds to the code in ModelCode.

VarChar255  
 Description

Description of the code.

VarChar1024  
 BriefName

Abbreviated name for the model, reserved for display on the user interface.  

Corresponds to the code in ModelCode.

VarChar255  
Objects that depend on tModel
 Database ObjectObject TypeDescriptionDep Level
tCatalogModelXref tabletCatalogModelXrefTable

System reference table used during a Loss analysis to determine the mapping between the model codes and catalog model codes.

1
tModelCountryXref tabletModelCountryXrefTableSystem reference table used to determine the countries that are covered by the model.1
tModelCTGeoLevelMapping tabletModelCTGeoLevelMappingTable

Stores information regarding the appropriate aggregation of geocode levels for each model. This information is used to enable CLF export of detailed loss to be used in CATRADER.

1
See Also

Related Objects

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