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