Touchstone 2021 (9.0) includes enhancements to AIR models, flexibility (in modeling), marine modeling, terrorism modeling, and licensing by business unit. It also offers expanded database flexibility and loss import capabilities. This release also includes a technical preview of the new Next Generation Models (NGM) framework. AIR has modified the existing Touchstone database schema to integrate the NGM capabilities in Touchstone.
AIR has made changes to the database schema to accommodate the following features and enhancements for Touchstone 2021.
- Includes additional coverages for layer and sublimit, location-level minimum and maximum deductibles, reinsurance treaty terms, and loss results by sub-peril.
- Includes new peril codes for the AIR Severe Thunderstorm Model for the U.S. Now you can directly append the straight-line wind, hail, and tornado perils for contracts and locations in Touchstone.
- Support for a new currency exchange rate table and new currency code BYN (in addition to the existing BYR) for Belarus. The currency table has also been updated with the VEF (Bolivar Fuerte) currency exchange rate.
- Import custom event frequency and custom vulnerability catalogs for all AIR models in Touchstone.
- Determine the highest loss accumulation in a crowded exposure through the Dynamic Ring and Grid Ring analyses. AIR has modified the Exposure Concentration Ring schema to include the "Remove overlaps" function and financial perspective for tracking the highest loss.
- Support for new weapon types for the AIR Terrorism Model (M01) for the U.S. and Workers' Compensation Data (M02) model for the U.S. Now you can specify these new weapon types in the Event Set Manager in Touchstone.
- Support for Fast Underwriting Loss Analysis (FUWLA) by model rather than by event sets or perils. AIR has added a new table to map model information, country, peril, and the associated FUWLA mode.
- To enhance the support for the Marine Line of Business, we have added damage functions for modeling marine cargo, salvage potential, small utility protection, and specie risks. AIR has also added new construction and occupancy codes and secondary modifiers. Note that the secondary modifiers will not impact losses at this time.
- Includes damage functions for modeling marine cargo, salvage potential, small utility protection, and specie risks.
- Includes hazard profiles, such as wind speed and exposure area, for Florida Wind Mitigation (FWM).
- Updates to administrative and postal data for Japan to aid with importing exposure data for Japan exposures into Touchstone.
- Additional construction and occupancy codes for Caribbean, Japan, and the United States.
- Updates to Geospatial data layers for AIR Tropical Cyclone for U.S. (M21), Japan (M62) and AIR Earthquake model for Japan (M52) models. AIR has updated the soil maps, historical events, RDS event, and Tsunami inundation depth.
- Support for non-catastrophe peril detailed loss analyses is no longer available in Touchstone. Therefore, non-catastrophe peril analysis will no longer be available as a separately licensable analysis type. Touchstone still supports the ‘NC’ peril code in the exposure management and geospatial modules. The AIRLossCost and AIRPSOLD databases in the prepared databases, and non-catastrophe loss analyses related schema tables in the AIRExposureSummary, AIRResult, AIRUserSetting, and AIRProject databases is no longer available.
- AIR no longer supports option for importing the Association for Cooperative Operations Research and Development (ACORD) data into Touchstone.
Some of the changes apply to new features and enhancements in Touchstone Re.
New Tables
AIR has added the following database tables in Touchstone 2021.
Tables | Details |
---|---|
AIRExposureSummary.dbo.tLossAnalysisCustomFrequencyInfo |
Stores information for the detailed loss analysis run with custom event frequency. This table contains the custom frequency configuration such as the type of event, custom catalog model code, and the unique sequential identifier associated with an analysis. |
AIRExposureSummary.dbo.tLossAnalysisCustomFrequencySet |
Stores information about the catalogs that contain custom, user-defined event footprints and the associated custom event frequency for a detailed loss analysis. |
AIRExposureSummary.dbo.tLossAnalysisCustomFrequencySetXref | Stores the results of analysis run with 'Custom Event Frequency' in a Detailed Loss analysis. |
AIRReference.dbo.tCargoPacking |
Stores information about the cargo packing details. |
Stores information about the protection of cargo package. |
|
Stores detailed damage information for each content. |
|
AIRReference.dbo.tModelGeographyXref | Stores the geographic location identifiers that correspond to each model. |
AIRReference.dbo.tSalvagePotential | Stores potential damage level associated with each salvage potential code. This table contains information to evaluate the potential loss and the corresponding damage level to determine the total loss for policy conditions. |
AIRReference.dbo.tSpecieStorage |
Stores code that represent types of storage used in special construction structures. |
AIRReference.dbo.tSprinklerType |
This table contains the sprinkler identifier for each sprinkler type. |
AIRReference.dbo.tFWMExposureArea2010 | Stores the possible Florida Wind Mitigation (FWM) 2010 exposure areas. Used during the Hazard analysis. |
AIRReference.dbo.tFWMWindSpeedRegion2010 | Stores the possible Florida Wind Mitigation (FWM) 2010 range of speed. Used during the Hazard analysis. |
AIRResult.dbo.tLossAnalysisCustomFrequencyInfo | Stores the results of a detailed loss analysis run with custom event frequency. This table contains the custom frequency configuration such as the type of event, custom catalog model code, and the unique sequential identifier associated with an analysis. |
AIRResult.dbo.tLossAnalysisCustomFrequencySet | Stores information about the catalogs that contain custom, user-defined event footprints and the associated custom event frequency anaysis for a detailed loss analysis. |
AIRResult.dbo.tLossAnalysisCustomFrequencySetXref | Stores the results when "Custom Event Frequency" is selected from the Detailed Loss Analysis Options. |
AIRResult.dbo.tRRRR_LOSS_DimReCurrencyExchangeRateSetConversion |
Stores information about the exchange rate set that corresponds to each currency in the application. |
AIRResult.dbo.ByLocationByFacultative | Stores the reinsurance results by location from a detailed loss analysis. This table is created when the user specifies "Save Loss By" and selects Facultative reinsurance type in the analysis Output Options. |
AIRResult.dbo.ByLayerByFacultative | Stores the reinsurance results by layer from a detailed loss analysis. This table is created when the user specifies "Save Loss By Layer" and selects Facultative reinsurance type in the analysis Output Options. |
AIRResult.dbo.ByLocationByTreaty | Stores the reinsurance results by location from a detailed loss analysis. This table is created when the user specifies "Save Loss By Location" and selects a reinsurance treaty type in the analysis Output Options. |
AIRResult.dbo.ByLayerByTreaty | Stores the reinsurance results by layer from a detailed loss analysis. This table is created when the user specifies "Save Loss By Layer" and selects a treaty type in the analysis Output Options. |
AIRResult.dbo.ByContractByTreaty | Stores the reinsurance results by contract from a detailed loss analysis. This table is created when the user specifies "Save Loss By Contract" and selects a treaty type in the analysis Output Options. |
AIRUserSetting.dbo.tLossCustomFrequency |
This table stores information about the custom, user-defined custom event frequency selected during the loss analysis. Custom Frequency template file allow the user to customize events that direct the Loss analysis engine to apply a specified events, AIR model, product, catalog, and event years directly to calculate the Ground-Up losses. The loss engine scales the entire Ground-up distribution, not just the mean loss, and applies all policy conditions to the modified losses. It does not cap the modified losses at the total insurable value (TIV). Any custom event frequency modification that is applied to losses from a peril applies also to losses generated by the respective sub-perils. |
AIRProject.dbo.tLossAnalysisCustomFrequencySetXref |
Stores the loss analysis information associated with the custom frequency set. |
AIRReference.dbo.tSequelImpactMMSData | Stores information about the support codes for Gulf of Mexico (GOM) with area code and their corresponding AIR specific sequential identifier. For internal use only. |
AIRReference.dbo.tSequelAirGOMArea | Stores information about the SEQUEL Impact Offshore structure including the type and number of structures. |
Modified Tables
AIR has modified the following database tables for Touchstone 2021.
Tables | Details | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
AIRAddressServer.dbo.tZIP5 | AIR has modified the centroid latitude and centroid longitude for approximately 45282 records. | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
AIRExposure.dbo.tLocFeature |
AIR has added the following columns:
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
AIRExposure.dbo.tReinsuranceEPCurve |
This table applies to Touchstone Re. However, the database schema may contain tables common to both Touchstone and Touchstone Re installation. Removed the following columns:
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
AIRExposure.dbo.tLayer |
AIR has added the following attachment points for including additional financial terms in the contract layer.
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
AIRReference.dbo.tActivityType |
AIR has added these 8 new activity types in both Touchstone and Touchstone Re for monitoring job requests.
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
AIRReference.dbo.tActivityTypeActivityStageXref |
AIR has added PRE, PRO, and POST activity stages in both Touchstone and Touchstone Re for monitoring the status of submitted activities.
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
AIRReference.dbo.tAIRConstOccRegionConstXref |
AIR has added 60 construction occupancy region codes in the range of 2701 to 2720 for the CAR, U.S., and Japan regions. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
AIRReference.dbo.tAIRConstOccRegionOccXref |
AIR has added 36 new occupancy codes in the range of 1001 to 1012 for the CAR region. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
AIRReference.dbo.tAIRConstruction |
AIR has added construction codes in the range of 2701 to 2720 for the Marine Cargo line of business.
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
AIRReference.dbo.tAIROccupancy |
AIR has added occupancy codes in the range of 1001 to 1012 for the Marine Cargo Line of Business.
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
AIRReference.dbo.tCoverage | Removed the column IsLossCostTemplateEnabled. | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
AIRReference.dbo.tConvertCTCurrency | AIR has added the CT Currency code 191 for the currency code BYN. | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
AIRReference.dbo.tConvertUPXPerilSet |
AIR has added the following perils for the severe thunderstorm options.
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
AIRReference.dbo.tPerilSet |
Added the following perils:
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
AIRReference.dbo.tCountryCurrencyXref |
AIR has added 82 new countries and the corresponding currency codes.
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
AIRReference.dbo.tCurrency | Added Belarusian Ruble currency code: BYN. | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
AIRReference.dbo.tExportType | Added the export type code for Export Loss to AnalyzeRe Graphene (LEXPALZGRA). | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Removed the columnIsLossCostTemplateEnabled. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
AIRReference.dbo.tEventFilterTerrorismWeaponType |
AIR has made the following modifications to the weapon types in the AIR Terrorism Model for the U.S.
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
AIRReference.dbo.tPeril |
AIR has added a new code for the straight-line winds peril and enabled the existing perils for tornado and hail.
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
AIRReference.dbo.tReinsuranceCountryPerilYear | AIR has added several hundred records to include perils set code for each country and updated the Industry Exposure Data (IED) | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
AIRReference.dbo.tHazardAttribute |
AIR has added the hazard attribute for:
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
AIRReference.dbo.ModelCountryXref |
AIR has added 7 new model codes for the following countries:
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
AIRReference.dbo.tActivityType |
AIR has added the following activity code for identifying activities enabled with the NGM Loss Engine in a detailed loss analysis.
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
AIRReference.dbo.tConvertCL2ConditionDeductibleType |
AIR has added the following deductible types to capture additional layer conditions in policies.
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
AIRReference.dbo.tDeductibleType |
AIR has added a new location deductible type to apply on the coverages, similar to the 'Site Percent Of Loss' deductible.
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
AIRReference.dbo.tOccLimitType |
AIR has added a new occurrence limit type. This limit type is applied to the total loss for buildings, other structures, and contents. The layer coverage and combined deductibles will no longer be remapped to a blanket layer deductible and a coverage or combined deductible Sublimit. Therefore, you can import a 'Layer Coverage' or 'Combined Deductible' types as is.
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
AIRReference.dbo.OutputTable |
AIR has added one more output table type to view the results of detailed loss analyses.
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
AIRCompanyLoss.dbo.tCompanyLossCatalog |
Added a new column:
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
AIRExposureSummary.dbo.tLossAnalysisCustomFrequencySet |
AIR has removed the following column CatalogTypeTag. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
AIRExposureSummary.dbo.tLossAnalysisOption |
AIR has added the following columns:
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
AIRProject.dbo.tECARingOption |
AIR has added the following:
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
AIR has added the following:
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
AIRProject.dbo.tLossAnalysisOption |
AIR has added the following columns to categorize and save loss analyses results.
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
AIRUserSetting.dbo.tModelInfo |
To support with the disaggregation logic and FUWLA features: AIR has updated the following 9 records in the Model Info table to include the conventional weapon type updates for the Terrorism model for U.S. The existing M01 and M02 model entries are retained as PMV and any new entries are included with an updated Model dll version.
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
AIRUserSetting.dbo.tCatalogType |
AIR has renamed the terrorism weapon type from the Delivery Truck (6-ton TNT) to Small Truck (6-ton TNT). |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
AIRUserSetting.dbo.tLossCustomFrequency |
AIR has removed the following column:
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
AIRUserSetting.dbo.tCurrencyExchangeRateSetConversion | AIR has added BYN currency code and the current exchange rate to this table. | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
AIRIndustry.dbo.TblOffshoreStructures | AIR has added 1328 records for new structures. | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
AIRResult |
AIR has renamed the existing table names to store loss results generated using the NGM Loss Engine. The schema is same for both Touchstone and NGM Loss Engine and the tables in the left column are mapped with the newly created tables in the right column. Therefore, when you run analyses for one of the seven selected models in the Touchstone UI with the NGM Loss Engine setting, Touchstone dynamically generates the loss tables shown in the right column and populates loss results data only for these tables in NGM Loss Engine.
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
AIRResult | We now include standard deviation and maximum loss for all NGM analysis initiated with net financial perspective selection. | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
AIRResult |
AIR has added loss columns such as loss, standard deviation, and maximum loss for the GroundUp, Gross, Recovery, and NetOfPreCat. Therefore, all reinsurance tables now contain the following loss key definitions for reporting the loss, standard deviation and maximum loss financial perspectives:
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
AIRResult.db.tLossAnalysisOption |
AIR has added the following columns to categorize and view loss analyses results.
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
AIR has removed the following column:
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
AIRResult.dbo.tLossAnalysisOption |
AIR has updated the Analysis Output Options in Touchstone to include the Custom Frequency Set, Save By Options, and minimum maximum logic code. To support these capabilities, we have added the following fields in the Touchstone database.
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
AIRGeography.dbo.tRemodeledGeographyXref | AIR has remapped the user-defined Geography SID with the 'Remapped Geography SID' field for approximately 2000 records. | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
AIRGeography.dbo.tGeoCountry | AIR has added additional data for supporting the reverse geocode via address service for Japan and U.S regions. |
Removed Tables
AIR has removed the following tables for the Non-catastrophe loss functionality beginning with Touchstone 2021.
Database | Table |
---|---|
AIRExposureSummary and AIRResult | tRRRR_NONCAT_AnnualEPSummary |
AIRExposureSummary and AIRResult | tRRRR_NONCAT_ByContract |
AIRExposureSummary and AIRResult | tRRRR_NONCAT_ByLayer |
AIRExposureSummary and AIRResult | tRRRR_NONCAT_ByLocation |
AIRExposureSummary and AIRResult | tRRRR_NONCAT_ByReinsurance |
AIRExposureSummary and AIRResult | tRRRR_NONCAT_DimContract |
AIRExposureSummary and AIRResult | tRRRR_NONCAT_DimLayer |
AIRExposureSummary and AIRResult | tRRRR_NONCAT_DimLocation |
AIRExposureSummary and AIRResult | tRRRR_NONCAT_DimReinsurance |
AIRReference |
tNonCatTemplateRule |
AIRProject |
tNonCatAnalysisOption |
AIRUserSetting |
tCustomLossCostTemplateRule |
AIRUserSetting | tLossCostAdjustmentTemplateRule |
AIRUserSetting | tDefaultNonCatAnalysisOption |
Datatype Changes
AIR has modified the following columns in Touchstone 2021.
Table | Column | Previous Datatype | Current Datatype |
---|---|---|---|
Risks | Integer | Big integer | |
AIRExposureSummary.dbo.tRRRR_EC_ByAccumulator | Risks | Integer | Big integer |
YearBuilt |
Small integer | Varchar (8000) | |
Stories |
Small integer |
Varchar (8000) |