Touchstone Re 2022 includes new features, enhancements, and Verisk model updates. We have updated the AIR Database schema to accommodate the new and enhanced features. Information specific to maintaining your databases will be available at the time of product release on the Touchstone Re 2022 Release Documentation page on the Client Portal. For related information, also on the portal, see Hot Fixes and Services Packs.        

Models

Touchstone Re 2022 includes a number of model updates. Important model updates are:

• Verisk Severe Thunderstorm Model for the United States: The Verisk Severe Thunderstorm Model for the United States has been separated from the Verisk Severe Thunderstorm Model for Canada so users can experience faster access to the significant loss updates in the U.S. model. Refer to Verisk Severe Thunderstorm Model for the United States on the Client Portal for more information.

• Verisk MPCI Model for the China: A new China Multi-Peril Crop Insurance (10K MPCI – Custom Policy Terms) event set for China MPCI Custom ILF. The new event set is available for clients who have an appropriate licensing agreement for the China MPCI Model. This tool provides more policy term flexibility to customize China crop and livestock policy deductibles by peril, crop/livestock, and province.

• Verisk Crop Hail for the United States: We updated the U.S. region of the U.S. Crop Hail (M086) Model for Touchstone Re. This includes the addition of the latest catalogs for the Verisk U.S. Severe Thunderstorm Model (M22) and Verisk U.S. MPCI Model (M07) in M086. Futher, we have updated the industry exposure data (IED) and default premium rates. Note that there is no change in the IED and industry loss file (ILF) data for the Canadian region. 

Enhancements

Touchstone Re 2022 includes the following new and enhanced features:

• The company loss association (CLA) information is now included when you copy a company.

• User interface improvements for the exposure grid, left navigation pane, and docking and viewing of multiple panes for quick comparison.

• Ability to combine multiple company loss files (CLFs) into a single company loss file via the Reinsurance Data Import API. Previosuly, this feature was supported in the user interface only. With this enhancement, you can combine CLFs using our public API.

• You can choose the flow of an inuring loss benefit in a reinsurance inuring chain.

• Support for zonal results when you run analyses with the Event Total analysis results output option. Now the aggregate loss results no longer generates a huge loss results tables when you save results view by 'Geography' for the program and portfolio loss analyses.

• Obtain single and multiple programs templates and portfolio loss analysis templates using the Reinsurance Program and Portfolio Loss Analysis APIs.

• Enhancements for uploading loss results to Analyze Re. 

Refer to the Touchstone Re 2022 Release Documentation for additional enhancements, APIs, and details.

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 provide capabilities for the aforesaid features and enhancements:

• The AIRUserSetting database was updated to support the enhancement for the China MPCI custom ILF. The existing tReinsuranceEventSets table now includes an unique sequential identifier (SID) for the China Multi-Peril Crop Insurance (10K MPCI – Custom Policy Terms) event set catalog; and the tReinsuranceEventSetCatalogXRef table includes a new reinsurance event set identifier to reference that newly created catalog.

• The AIRIndustry database now includes a TblIndustry2021 table for storing the industry exposure such as the peril type, area scheme, currency, and line of business.

• The AIRExposureRe database now includes the tCompanyCLASizes table to provide the ability to include the CLA information when you copy a company.

• The existing tReinsuranceProgramSourceInure table in the AIRExposureRe database now includes a IsInuringNextProgramFlow flag to record the user's choice of inuring loss flow benefit for a reinsurance program.

• We have made data updates, removed some tables, and made other schema updates to better support the existing workflows in Touchstone Re. 

The following database changes have been introduced in Touchstone Re 10.0:

• New databases
• New tables
• Modified tables
• Removed tables
• Datatype changes

These changes support several new features and enhancements in Touchstone Re. For more information, see Touchstone Re Release Notes and Touchstone Re online help in the Client Portal.

New Databases

We have not added new databases in Touchstone Re 2022.

New Tables

We have added the following tables in Touchstone Re 2022.

Table	Description
AIRIndustry.TblIndustry2021	Stores encoded industry exposure data for the calendar year 2021
AIRExposureRe.tCompanyCLASizes	Stores information about the company loss file (CLF) information such as the CLF set, model code, and size of the CLA record.  You can include the CLF information when you copy a company.

Modified Tables

AIR has modified the following database tables for Touchstone Re 2022.

Table	Description
AIRExposureRe.tReinsuranceProgramSourceInure	Stores information about the sourcing and inuring relationships between reinsurance programs We have added the IsInuringNextProgramFlow field.This field stores the user's choice of the flow of loss benefit for a reinsurance program. Touchstone Re APIs now include an option to select the loss benefit to stop at the direct child in an inuring chain or flow to all the subsequent children in that reinsurance structure.
AIRProject.tAggregateLossAnalysisOption	Stores information about the options specified for each loss analysis. We have added ParentWithInvalidSourceProgramMap
AIRUserSetting.tReinsuranceCatalog	Stores information about the event catalogs that are available in Touchstone Re, including event catalogs for the custom (user-defined) models We have added 'CatalogID' to identify the user-specified event catalog for custom models.
AIRResultRe.tRRRR_LOSS_RePerfLog	Stores information to track the time taken by every task and sub-tasks in the pre-process stage. This internal table enables to identify any performance issues in the program and portfolio analyses.
AIRReference.tActivityType	Stores codes that represent types of activities. We have added the following activity type codes for performing the newly added activities. CNMPCICILF = Generate China MPCI Custom ILF SEQUELCONV = Sequel Convert Csv USMPCI_RPT = US MPCI Report

Remove Tables

We have removed the following tables in Touchstone Re 2022.

Database	Table
AIRExposureRe	tGroupPortfolio tGroupPortfolioViewXRef tReinsuranceProgramStructure tReinsuranceProgramStructureXRef
AIRIndustry	TblIndustry2016
AIRProject	tComparativeLossAnalysisOption tComparativeLossAnalysisTargetOption
AIRResultRe	tRRRR_CMPLOSS_AnnualEPKey tRRRR_CMPLOSS_ContractKey tRRRR_CMPLOSS_EventKey tRRRR_CMPLOSS_GeoKey tRRRR_CMPLOSS_LOBKey tRRRR_TTTT_CMPLOSS_AnnualEP tRRRR_TTTT_CMPLOSS_AnnualEPSummary tRRRR_TTTT_CMPLOSS_ByEvent tRRRR_TTTT_CMPLOSS_ContractLOBAAL tRRRR_TTTT_CMPLOSS_GeoAAL

Datatype Change

We have not modified the datatype in Touchstone Re 2022.