Touchstone AIR Databases

Enhancements in the database schema.

We made the following schema changes to accommodate new features and enhancements

NGM updates

We updated the database schema for saving loss results by sub-peril, configuring loss modifications by sub-peril, and for launching multiple loss modification templates. We added the following new tables:

  • AIRResult.tLossAnalysisLossModTemplateXref: Stores the custom loss modification templates associated with a detailed loss analysis.

  • AIRExposureSummary.tLossAnalysisLossModTemplateXref: Stores exposures associated with a custom loss modification template in the exposure summary.

  • AIRProject.tLossAnalysisLossModTemplateXref: Stores the custom loss modification template referenced in a project.

Demand surge

We updated the database schema for a new demand surge methodology, which is country-specific and accounts for the whole year instead of for each event individually. Also, we made schema changes to capture the calculated core economic demand surge factor and the cost construction inflation percentage and related information in a loss results table. We added the following tables:

  • AIRUserSetting.tDemandSurgeAIRConstructionExclusion: Stores a list of the user- excluded construction codes at the time of selection of custom curves for demand surge calculation via the Touchstone user interface.

  • AIRUserSetting.tDemandSurgeAIROccupancyExclusion: Stores a list of the user-excluded occupancy codes at the time of selection of custom curves for demand surge calculation via the Touchstone user interface.

  • AIRUserSetting.tDemandSurgeUserLOBExclusion: Stores a list of the user-excluded LOB at the time of selection of custom curves for demand surge calculation via the Touchstone user interface.

  • AIRUserSetting.tDemandSurgeConstructionCostInflation: Stores the user-specified construction cost inflation for each country included in the demand surge calculation. Now you can customize an additional construction cost inflation factor for each country, which gets automatically added to the economic demand surge factor.

  • AIRUserSetting.tDemandSurgeLatestModelXref:

    We modified the existing table:

    • AIRReference.tDemandSurgeRegion:

Export exposure to UNICEDE/2

We updated the database schema to allow users to exclude exposures by the lines of business, construction, and occupancy codes when exporting exposures to a UNICEDE/2 file. We added the following new tables:

  • AIRResult.tLossAnalysisIDSExposureExclusion: Stores a list of user-excluded lines of business, construction, and occupancy codes associated with an aggregate loss analysis.

  • AIRProject.tLossAnalysisIDSExposureExclusion: Stores a list of user-excluded lines of business, construction, and occupancy codes associated with a project.

  • AIRExposureSummary.tLossAnalysisIDSExposureExclusion: Contains a list of the user-excluded lines of business, construction, and occupancy codes associated with exposures in the exposure summary.

For more information about the database schema information, refer to the Touchstone Technical Preview Database Reference documentation available in Developer Zone.