Introduction

Touchstone Re is Verisk's catastrophe modeling application for reinsurers and other professionals who evaluate risk transfer alternatives. The application and application databases enable you to:

Import and manage aggregated exposure data and company loss data.
Evaluate reinsurance programs and portfolios of reinsurance contracts.
Obtain consistent loss estimates.
Transfer data seamlessly.
Share loss estimates with other users in your business unit.

The Touchstone Re Database Reference provides a detailed description of the Touchstone Re database schema. Specifically, the reference describes the tables, columns, and dependencies in the following databases:

Database	Description
AIRCompanyLoss	Stores information about company loss file (CLF) sets exported from Touchstone to Touchstone Re.
AIRDBAdmin	Stores the scripts that Touchstone Re uses to create or upgrade the AIRExposureRe and AIRResultsRe database tables.
AIRExposureRe	Stores user-specified exposure information.
AIRGeography (read-only)	Stores geographic information.
AIRGlobalSetting	Stores information about user-created zone sets. A zone set is a group of geographic regions or areas that you can use during loss analyses.
AIRIndustry (read-only)	Stores information about offshore structure modeling.
AIRProject	Stores information about the activities performed by Touchstone Re. For each loss analysis, the database stores the options specified by the user that triggered the analysis.
AIRReference (read-only)	Stores reference information such as codes and filters that Touchstone Re uses for various tasks.
AIRResultRe	Stores analysis options, results, and reference information.
AIRUserSetting	Stores information about user-customizable options in Touchstone Re.

You can optionally search the reference by expanding the Search drawer in the navigation pane.

To facilitate integrations between Touchstone and Touchstone Re, some databases include data for both applications. However, only databases and tables that are relevant to Touchstone Re are described in this reference. For more information about Touchstone-specific databases and tables, see Touchstone Database Reference on Developer Zone.

Audience

The reference is intended for database administrators, system administrators, database application developers, and any other users that require access to Touchstone Re data outside the application.

Conventions

The following conventions are used throughout the reference:

Convention	Description
Key Icon ()	Indicates a primary key.
DepLevel	Column that specifies the dependency level between two tables.