Touchstone 4.0 Database Documentation
AIRUserSetting Database
Description

The AIRUserSetting database stores all the user-customized information Touchstone.

Schema Diagram

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

Tables
TableDescription
tAdminBoundary

Stores information about the administrative boundaries available in Touchstone.

Detailed information about the administrative boundaries is available in tAdminBoundaryDetail Table

tAdminBoundaryDetail

Stores information about the geographic records that are associated with specific administrative boundaries.

Information regarding the AIR-provided administrative boundaries is available in tAdminBoundary Table.

tCatalog

Stores information about the catalogs available in Touchstone. 

Information regarding catalogs that contain custom, user-defined event footprints is available in tCatalogDetail Table.

tCatalogDetail

AreaStores information about the catalogs that contain custom, user-defined events.

Information regarding the AIR-provided catalogs is available in tCatalog Table.

tCurrencyExchangeRateSet

Stores information about the currency exchange rate sets available in Touchstone. 

Detailed information about the exchange rate for each currency is available in tCurrencyExchangeRateSetConversion Table.

tCurrencyExchangeRateSetConversion

Stores detailed information about the exchange rate for each currency available in Touchstone. 

Information about the exchange rate sets is available in tCurrencyExchangeRateSet Table.

tCustomLossCostTemplateRule

Used for a Non-Catastrophe analysis, this table stores information about the custom, user-defined loss cost calculator that the loss analysis engine uses instead of the calculations provided by ISO's Loss Cost Calculator. 

The loss analysis engine applies the rules (based on geography, construction, and occupancy) to locations after calculating the loss costs, adjusting the number up or down by the adjustment factor when there is a matching rule that applies.

tDBVersionDefines the version of the database.
tDefaultDatabaseOption

Stores the database name prefix for the AIRResult and AIRExposure databases. When defined in the Business Unit Management section of the Administration Console, Touchstone automatically assigns the prefix to the user-defined database name.  

tDefaultImpactAnalysisOptionStores the default reference portfolio used during a Marginal Impact analysis.
tDefaultLocWC

Stores the worker's compensation information that is associated with a specific location. 

tDefaultLossAnalysisOption

Stores the default Loss analysis options. 

tDefaultNonCatAnalysisOption

Stores the default non-catastrophe Loss analysis options. 

tDefaultObjectStores default object information.
tDefaultUserOption

Stores the default non-catastrophe Loss analysis options. 

tDefaultUWAnalysisSetting

Stores the default underwriter analysis options. 

tDefaultUWOption

Stores information regarding the various records used during an underwriter analysis.

tDemandSurge

Stores information about the standard demand surge curves that are available in Touchstone. 

Information regarding the custom, user-defined demand surge function is available in tDemandSurgeFunction Table.

tDemandSurgeFunction

Stores information about the custom, user-defined demand surge functions.

Information regarding the AIR-provided demand surge curves is available in tDemandSurge Table.

tDQDefaultRuleSetTemplateA reference table used to identify the Data Quality analysis rule sets.
tDQRuleSetTemplate

Stores information about the Data Quality rules set templates that are available in Touchstone. 

tDQRuleSetTemplateRuleSubTypeSelected

Stores information about the rule sub-types that are available in Touchstone.

tDQRuleTemplate

Stores information about the Data Quality rules that are available in Touchstone. 

tDQSettingStores the Data Quality analysis settings.
tEventSet

Stores the event sets that are available in Touchstone. 

tEventSetCatalogXrefSystem reference table used to identify the events sets that are associated with specific catalogs.
tEventSetInfo

Stores information about the event sets that are available in Touchstone. 

tForestryLandPrice

Stores information about the per-hectare unit price for forestry land in Finland, Norway, and Sweden. 

tHazardWidgetTemplate

Stores information about the custom, user-defined hazard widget template.

Information regarding the underlying widget template is available in tWidgetTemplate Table.

tImportDefaultProvides the default setting information to be used for import.
tImportMappingSetUsed during import, this table provides mapping between the fields in the source input file to the columns in the target database table.
tLocaleOverride

Stores information used to override region and language settings defined within the computer's operating system.

tLossCostAdjustmentTemplateRule

Used for a Non-Catastrophe analysis, this table stores information about the loss cost adjustment template. 

The loss analysis engine applies the rules (based on geography, construction, and occupancy) to locations after calculating the loss costs, adjusting the number up or down by this factor when there is a matching rule that applies.

tLossModTemplate

Used for a Loss analysis, this table stores information about the custom, user-defined loss modification template. 

Loss modification templates allow the user to define one or more rules that direct the Loss analysis engine to apply a specified loss modification factor directly to Ground-Up losses. The characteristics of the rules are defined in dbo.tLossModTemplateRule.

The loss engine scales the entire Ground-up distribution, not just the mean loss, and applies all policy conditions to the modified losses. It does not cap the modified losses at the total insurable value (TIV). Any loss modification factor that is applied to losses from a peril applies also to losses generated by the respective sub-perils.

tLossModTemplateRule

Used for a Loss analysis, this table stores information about the custom, user-defined rules (filter) that identify the Ground-Up losses to which the Loss analysis engine applies the specified loss modification factor.

tLossModTemplateRuleConstructionCode

Used for a Loss analysis, this table stores information about the construction class filter in the rule definition.

These custom, user-defined rules identify the Ground-Up losses to which the Loss analysis engine applies the specified loss modification factor. The engine applies the factor to losses from the events that satisfy the rules.

tLossModTemplateRuleOccupancyCode

Used for a Loss analysis, this table stores information about the occupancy class filter in the rule definition.

These custom, user-defined rules identify the Ground-Up losses to which the Loss analysis engine applies the specified loss modification factor. The engine applies the factor to losses from the events that satisfy the rules.

tLossModTemplateRuleSetEventParameter

Used for a Loss analysis, this table stores information about the event parameters filter in the rule definition.

These custom, user-defined rules identify the Ground-Up losses to which the Loss analysis engine applies the specified loss modification factor. The engine applies the factor to losses from the events that satisfy the rules.

tLossModTemplateRuleSetEventParameterXrefSystem reference table used  to identify to look-up template rules and event rule set associations.
tLossTemplate

 Stores information about the Loss analysis templates available in Touchstone. 

tLossWidgetTemplate

Stores information about the custom, user-defined loss widget template.

Information regarding the underlying widget template is available in tWidgetTemplate Table.

tModelInfoStores information regarding the models currently avaible with Touchstone. 
tObjectStores information regarding the various widget and template objects available in Touchstone.
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.
tWidgetTemplate

Stores information about the widget templates available in Touchstone. 

Information regarding the custom, user-defined widget templates are available in the following database tables:

tZone

Stores information about the zones available in Touchstone. 

Information regarding the custom, user-defined zones is available in tZoneDefinition Table.

tZoneDefinition

Stores information about the custom, user-defined zones.

Information regarding the AIR-provided zones is available in tZone Table.

tZoneSet

Stores information about the zones sets available in Touchstone. 

tZoneSetZoneXrefSystem reference table used  to associate the zones to zone sets.

 

 


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.