dbo Schema

Tables

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

Related Objects

AIRExposure Database