CEDE 10.0 Database Reference
What's New in Touchstone 2022 Databases
Revision History for the CEDE Database Reference > What's New in Touchstone 2022 Databases
 What's New in Touchstone® 2022 Databases

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:

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 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:

  • CNMPCICILF = Generate China MPCI Custom ILF
  • USMPCI_RPT = US MPCI Report
AIRReference.tAIRConstOccRegionConstXRef

Stores the AIR construction class codes supported for each geographic region

Added 42 new construction codes for China and Europe.

  • CH = 2701
  • CH = 2702
  • CH = 2703
  • CH = 2704
  • CH = 2705
  • CH = 2706
  • CH = 2707
  • CH = 2708
  • CH = 2709
  • CH = 2710
  • CH = 2711
  • CH = 2712
  • CH = 2713
  • CH = 2714
  • CH = 2715
  • CH = 2716
  • CH = 2717
  • CH = 2718
  • CH = 2719
  • CH = 2720
  • EU = 2701
  • EU = 2702
  • EU = 2703
  • EU = 2704
  • EU = 2705
  • EU = 2706
  • EU = 2707
  • EU = 2708
  • EU = 2709
  • EU = 2710
  • EU = 2711
  • EU = 2712
  • EU = 2713
  • EU = 2714
  • EU = 2715
  • EU = 2716
  • EU = 2717
  • EU = 2718
  • EU = 2719
  • EU = 2720
  • US = 239
  • US = 240
AIRReference.tAIRConstOccRegionOccXRef

Stores the countries supported for each region.

Added 25 occupancy region codes for China, Europe, and the United States.

  • CH = 1001
  • CH = 1002
  • CH = 1003
  • CH = 1004
  • CH = 1005
  • CH = 1006
  • CH = 1007
  • CH = 1008
  • CH = 1009
  • CH = 1010
  • CH = 1011
  • CH = 1012
  • EU = 1001
  • EU = 1002
  • EU = 1003
  • EU = 1004
  • EU = 1005
  • EU = 1006
  • EU = 1007
  • EU = 1008
  • EU = 1009
  • EU = 1010
  • EU = 1011
  • EU = 1012
  • US = 374                                                          
AIRReference.tIntensityAttribute

We have added the following new intensity attributes to the Verisk Hazard Model.

  • 131 = HAZIT
  • 132 = HAZIT
AIRReference.tModelCountryXref We have added the following countries to the Model 20 and 27.                                         
  •  

  • 20 = CA
  • 20 = US
  • 27 = BQ
  • 27 = CW                                                 
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.

  • 60050 (LOCFEAT) = Wet Floodproofing must be 0,1,2,3 Or 4
  • 60051 (LOC Latitude) = Location will be address based geocoded.

EX_PORT

  • 70000 = Portfolio invalid.
  • 70001 = Portfolio cannot be null.
  • 70002 = Portfolio ref cannot be empty.
  • 70100 = PortfolioOptions invalid.
  • 70101 = PortfolioOptions cannot be empty.
  • 70102 = Extraction Options cannot be empty.
  • 70103 = Publish Code cannot be empty.
  • 70104 = Data source ref cannot be empty.
  • 70105 = Business unit ref cannot be empty.
  • 70106 = Business unit refs cannot be empty.
  • 70200 = Cedent invalid.
  • 70201 = Cedent cannot be null.
  • 70202 = Cedent Sid must be greater than 0.
  • 70203 = Cedent name must not be empty.
  • 70300 = Project invalid.
  • 70301 = Project cannot be null.
  • 70302 = Project must be null.
  • 70303 = Project Sid must be greater than 0.
  • 70400 = Company invalid.
  • 70401 = Company cannot be null.
  • 70402 = Company must be null.
  • 70403 = Project Sid must be greater than 0.
  • 70500 = Cedent relationship invalid.
  • 70501 = Cedent relationship cannot be null.
  • 70502 = Exposure view sid must be greater than 0.
  • 70503 = Risk program sid must be greater than 0.
  • 70504 = Risk program sid must not be null.
  • 71000 = Portfolio cannot be null.
  • 71001 = Portfolio is invalid.
  • 71002 = Portfolio ref cannot be empty.
  • 71003 = Portfolio name cannot be empty.
  • 71005 = Extraction options are invalid.
  • 71006 = Publish Code cannot be empty.
  • 71007 = Data Source Ref cannot be empty.
  • 71008 = Current Business Unit Ref cannot be empty.
  • 71009 = BusinuessUnitRefs cannot be empty.
  • 71010 = Extraction options cannot be empty.
  • 71100 = Extraction option is invalid.
  • 71201 = Project sid is invalid.
  • 71202 = Exposure view sid in invalid.
  • 71203 = ReinsuranceProgram sid is invalid.
  • 71301 = Company sid is invalid.
  • 71302 = Cat Treaty sid is invalid.
  • 71303 = Cat Program sid is invalid.

We have added three new validation checks.

  • 60052 =  Users are restricted from placing multiple tiers of MinMax deductibles in a policy
  • 60053 = Users are restricted from placing more than two tiers of Deductibles in a policy
  • 60054 = Sublimit deductible type is invalid for tiered sublimits.

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:

Table Column
tAggregateExposure AggregateExposureSID
tAppliesToArea AppliesToAreaSID
tAppliesToAreaGeoXRef AppliesToAreaSID
tAppliesToEventFilter AppliesToEventFilterSID
tAppliesToEventFilterGeoXRef AppliesToEventFilterSID
tAppliesToEventFilterLatLong AppliesToEventFilterSID
tAppliesToEventFilterRule AppliesToEventFilterRuleSID
tCatBondAttributeValue ReinsuranceProgramSID
tCLFCatalog CLFCatalogSID
tCompanyLossAssociation CompanyLossAssociationSID
tCompany CompanySID
tEngineLocPhysicalProperty LocationSID
tGroupPortfolio GroupPortfolioSID
tGroupPortfolioViewXRef GroupPortfolioSID
tPortfolio PortfolioSID
tPortfolioFilter PortfolioFilterSID
tReinsuranceExposureAdjustmentFactor ReinsuranceExposureAdjustmentFactorSID
tReinsuranceProgram ReinsuranceProgramSID
tReinsuranceProgramSourceInure ReinsuranceProgramInuringSID
tReinsuranceProgramStructure ReinsuranceProgramStructureSID
tReinsuranceTreaty ReinsuranceTreatySID
tReinsuranceEPCurve ReinsuranceEPCurveSID

 

AIRExposure

We have removed the following tables:

  • tGroupPortfolio
  • tGroupPortfolioViewXRef
  • tReinsuranceProgramStructure
  • tReinsuranceProgramStructureXRef           

Datatype Changes

We have not made any datatype changes in Touchstone 2022.