Touchstone 2022 Database Reference
AIRReinsurance Database
Description

The AIRReinsurance database stores information about user-specified reinsurance programs and reinsurance contracts.

Schema Diagram

You can view a diagram of the AIRExposure database in Schema Diagrams.

Tables
TableDescription
Stores information about any packages applied to the database.
Defines the version of the database.

Stores information about reinsurance programs.

A reinsurance program includes one or more related reinsurance treaties or layers. Reinsurance coverage applies to locations or treaties and not to reinsurance programs.

System reference table used to identify the relationship between the program and exposure views.

Stores information about the geographic or area filter applied to each reinsurance treaty.

Reinsurance treaty geographic filters are optional.

Stores information about reinsurance treaties.

A reinsurance program includes one or more related reinsurance treaties or layers. Reinsurance coverage applies to locations or treaties and not to reinsurance programs.

Stores a list of all SID tables and the last SID value in each table.

After each insert operation, the system updates the SID value.

Stores information about upgrade scripts.