CEDE 8.0 Database Reference
AIRExposure Database
Description

The AIRExposure database stores user-provided exposure information.

Tables
TableDescription
tContract

Stores records for primary insurance policies.

tDBVersionDefines 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.

tLocStepFunctionXrefSystem 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.

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.

tStepFunctionStores general information about step functions, including the contract associated with each step function.
tStepFunctionDetailStores detailed information about step functions.
tUpgradeLogStores information about upgrade scripts.