Touchstone 4.0 Database Documentation
AIRExposure Database
Description

The AIRExposure database stores the user-provided exposure information. 

Schema Diagram

To view the database schema diagrams for the AIRExposure database, see Schema Diagrams.

Tables
TableDescription
tContract

Contains records for primary insurance policies.

tDBKeyAndIndexSystem table, used internally by Touchstone.
tDBVersionDefines the version of the database.
tEngineLocPhysicalPropertyStore information about the location's physical properties that were calculated by the engine.
tExposureSetContains exposure set information. An exposure set is a collection of contracts, locations, and other related information.
tLayer

Contains primary contract layer information.

tLayerCondition

Contains layer conditions, such as sublimit and policy restrictions.  Note that sublimit belongs to a layer and is usually associated with a filter criteria, such as specific group of locations or perils.

tLayerConditionLocationXref

System reference table used to map the location to the layer condition.

tLocation

Contains geographical attributes and primary risk characteristics for each location. It serves as a reference point between Location and Contract entities.  All locations entities are tied together by the same Location SID.

tLocFeature

Contains detailed building information, including secondary risk characteristics.

tLocOffshore

Contains risk characteristics for each offshore location.

tLocParsedAddressContains street-level address details for each location.
tLocStepFunctionXrefSystem reference table used to determine the step functions that are associated with a location.
tLocTerm

Contains information about location terms.

tLocWC

Contains information about the workers' compensation details for the location.

tReinsAppliesToExp

Contains information about Facultative certificates and Surplus Share treaties that are applied to exposures such as location, contract, and layer.

tSIDControlContains a list of all SID tables and the last SID value in use for each table.  After each insert operation, the SID value will update.
tStepFunctionContains general information for each step function SID, including the contract in which the step function is used.
tStepFunctionDetailContains detailed information for each step function SID.

 

 


AIR Client Confidential

© 2016. AIR Worldwide is a registered trademark. Touchstone is a registered trademark of AIR Worldwide.

Please contact AIR Worldwide with questions or comments. For database questions. For documentation comments.