Touchstone 2022 includes new features, enhancements, and Verisk model updates. We have updated the AIR Database schema to accommodate the new and enhanced features. The purpose of this posting is primarily for knowledge sharing of the upcoming scope of database schema changes for the Touchstone 2022 AIR Databases.
Information specific to maintaining your databases will be available at the time of product release on the Touchstone 2022 Release Documentation page on the Client Portal. For related information, also on the portal, see Hot Fixes and Services Packs.
Enhancements
Touchstone 2022 includes the following new features and enhancements:
-
User interface improvements for the exposure grid, left navigation pane, Verisk rebrand, and docking and viewing of multiple panes for quick comparison
-
Ability to access additional metadata elements such as Analysis Name, Analysis SID, Application Version, Project Name, Event Set Name, Demand Surge, Currency Exchange Rate Set Name, Peril Set, and Loss Perspective for the AnalyzeRe clients
Note: The Touchstone (Re) database schema is the proprietary information and intellectual property of AIR Worldwide and will remain as AIR Databases. In the Touchstone (Re) Documentation, we will refer to the database schema as AIR Databases (for example, AIR Reference, AIR Project, etc.).
Database updates
We have made the following updates to the AIR Database Schema to support the new features and enhancements in Touchstone 2022.
-
The construction and occupancy codes in AIRReference that you assign for each exposure in loss analysis calculation now includes 42 construction and 25 occupancy codes for the United States, China and European regions. The addition of these codes extends support of the codes to the Verisk Severe Thunderstorm model for the United States, enabling consistency with the Verisk Hurricane model for the United States.
-
We updated the AIRReference database schema to include updated model codes, validation error codes, and analyses activity types. This enhancement allows you to identify loss analyses when you query data directly in the AIRResult database.
The following database changes have been introduced in the Touchstone 2022 release:
Some of the changes apply to new features and enhancements in Touchstone Re.
New Tables
We have not implemented any new tables in Touchstone 2022.
Modified Tables
We have modified the following database tables for Touchstone 2022.
Tables | Details |
---|---|
AIRReference.tActivityType |
Added the following activity codes:
|
AIRReference.tAIRConstOccRegionConstXRef |
Stores the AIR construction class codes supported for each geographic region Added 42 new construction codes for China and Europe.
|
AIRReference.tAIRConstOccRegionOccXRef |
Stores the countries supported for each region. Added 25 occupancy region codes for China, Europe, and the United States.
|
AIRReference.tIntensityAttribute |
We have added the following new intensity attributes to the Verisk Hazard Model.
|
AIRReference.tModelCountryXref |
We have added the following countries to the Model 20 and 27.
|
AIRReference.tReinsuranceCountryPerilYear |
We have added 470 new mappings between country codes and their corresponding peril codes.
|
AIRReference.tValidationError |
We have removed 46 validation error codes.
EX_PORT
We have added three new validation checks.
|
Removed Tables and Schema Data
We have removed the following tables beginning with Touchstone 2022.
Database | Table | ||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
AIRExposure |
We have removed the following columns in tSIDControl table:
|
||||||||||||||||||||||||||||||||||||||||||||||
AIRExposure |
We have removed the following tables:
|
Datatype Changes
We have not made any datatype changes in Touchstone 2022.