AIRExposure Database

Description

The AIRExposure database stores user-provided exposure information.

The following tables apply only to Touchstone Re or are not used, but may appear in your installation for internal purposes:

tAggregateExposure
tAppliesToArea
tAppliesToAreaGeoXRef
tAppliesToEventFilter
tAppliesToEventFilterGeoXRef
tAppliesToEventFilterLatLong
tAppliesToEventFilterRule
tCatBondAttributeValue
tCLFCatalog
tCompany
tCompanyCLASizes
tCompanyLossAssociation
tCompanyLossMarketShare
tCompanyUDCClassification_Xref
tGroupPortfolio
tGroupPortfolioViewXRef
tPortfolio
tPortfolioFilter
tPortfolioReinsuranceTreaty
tProgramBusinessCategoryFactor
tReinsuranceLOBCountryOverride
tReinsuranceExposureAdjustmentFactor
tReinsuranceProgram
tReinsuranceProgramEPAdjustment
tReinsuranceProgramEPAdjustmentPoints
tReinsuranceProgramSourceInure
tReinsuranceProgramStructure
tReinsuranceProgramStructureXRef
tReinsuranceProgramTargetXRef
tReinsuranceTreaty
tReinsuranceTreatySavedResults
tReinsuranceTreatyTerrorismOption
tReinsuranceTreatyUDCClassification_Xref
tReinsuranceProgramJapanCFLRatio

For more information about the tables, see Touchstone Re Database Reference on AIR's Developer Zone.

Schema Diagram

You can view a diagram of the AIRExposure database in Schema Diagrams.

Tables

Table	Description
tContract	Stores records for primary insurance policies.
tDbHistory	Stores information about any packages applied to the database.
tDBVersion	Defines the version of the database.
tEngineLocPhysicalProperty	Stores information about the physical properties that the analysis engine calculated for each location.
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.
tLocParsedAddress	Stores street-level address details for each 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.
tUpgradeOption	Stores information about database upgrades.