Description
Stores information about the models that are available in Touchstone.
Properties
Creation Date | 10/30/2018 9:13 AM |
File Group | PRIMARY |
Text File Group | |
System Object |  |
Published for Replication |  |
Rows | 66 |
Data Space Used | 8.00 KB |
Index Space Used | 8.00 KB |
Columns
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula |
| 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 the U.S. (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)
- 18 = AIR Japan Inland Flood Model
- 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)
- 43 = AIR Severe Thunderstorm Model for Europe
- 44 = AIR Severe Thunderstorm Model for Australia (M44 Aus ST)
- 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
- 86 = AIR Crop Hail Model for the U.S. and Canada
- 87 = AIR Multiple Peril Crop Insurance Model for India
- 89 = AIR Multiple Peril Crop Insurance Model for Canada
- 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)
| smallint | 2 | | | |
| Model | Name of the model.
Corresponds to the code in ModelCode. | varchar | 255 |  | | |
| Description | Description of the code. | varchar | 1024 |  | | |
| BriefName | Abbreviated name for the model, reserved for display on the user interface.
Corresponds to the code in ModelCode. | varchar | 255 |  | | |
Objects that depend on tModel
| Database Object | Object Type | Description | Dep Level |
 | tModelCountryXref | Table | System reference table used to determine the countries that are covered by the model. | 1 |
 | tModelCTGeoLevelMapping | Table | Stores information how geocode levels are aggregated for each model.
Touchstone uses the information for company loss file (CLF) exports of detailed loss data for CATRADER. | 1 |
See Also