The AIRIndustry database stores industry exposure information.
Schema Diagram
You can view a diagram of the AIRIndustry database in Schema Diagrams.
Touchstone Re 2022 Database Reference
AIRIndustry Database
The AIRIndustry database stores industry exposure information.
You can view a diagram of the AIRIndustry database in Schema Diagrams.
| Table | Description |
|---|---|
| TblIndustry2017 | Stores encoded industry exposure data for calendar year 2017. |
| TblIndustry2018 | Stores encoded industry exposure data for calendar year 2018. |
| TblIndustry2019 | Stores encoded industry exposure data for calendar year 2019. |
| TblIndustry2020 | Stores encoded industry exposure data for calendar year 2020. |
| TblIndustry2021 | Stores encoded industry exposure data for the calendar year 2021. |
| TblOffshoreStructures | Stores industry information for the offshore structures. |
| tCountryOffshore | Defines whether the countries that have offshore structures are modeled by AIR. |
| tDbHistory | Stores information about any packages applied to the database. |
| tDBVersion | Defines the version of the database. |
| tIndustry | Stores encoded industry exposure data for various calendar years. |
| tMultiYearMap | Reserved for future use. Stores information that Touchstone Re uses to create multi-year iterations from each set of 10,000 simulations in each model event catalog. For each model, the table stores the mappings between years in the catalog and years in the multi-year iteration. Each Yearx column identifies one out of 10,000 simulated years. |
| tReinsuranceIndustryRate | Stores industry-default and user-specified per-life premium rates for the pandemic peril. |
| tUpgradeLog | Stores information about upgrade scripts. |