The AIRExposure database stores user-provided exposure information.
CEDE 9.0 Database Reference
AIRExposure Database
The AIRExposure database stores user-provided exposure information.
| Table | Description |
|---|---|
| tContract | Stores records for primary insurance policies. |
| tDBVersion | Defines the version of the database. |
| tExposureSet | Stores information about exposure sets. An exposure set is a collection of contracts, locations, and other related information. |
| tLayer | Stores primary contract layer information. |
| tLayerCondition | Stores layer conditions, such as sublimit and policy restrictions.
Sublimits are generally applied to layers based on filter criteria, such as a list of locations or perils.
|
| tLayerConditionLocationXref | System reference table used to map the location to the layer condition. |
| tLocation | Stores geographical attributes and primary risk characteristics for each location. The table serves as a reference point between Location and Contract entities.You can identify each location by the location sequential identifier (SID). |
| tLocFeature | Stores detailed building information for each location. The information includes secondary risk characteristics, such as the building shape and glass type. |
| tLocOffshore | Stores risk characteristics for each offshore location. |
| tLocStepFunctionXref | System reference table used to determine the step functions that are associated with a location. |
| tLocTerm | Stores information about location terms. |
| tLocWC | Stores information about the workers' compensation details for the location. |
| tReinsAppliesToExp | Stores information about facultative certificates and surplus share treaties that are applied to exposures such as locations, contracts, and layers. |
| tReinsuranceProgramJapanCFLRatio | |
| tSIDControl | 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. |
| tStepFunction | Stores general information about step functions, including the contract associated with each step function. |
| tStepFunctionDetail | Stores detailed information about step functions. |
| tUpgradeLog | Stores information about upgrade scripts. |