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