| Table | Description |
|---|
| 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 | Stores information about the catalogs that contain custom, user-defined events.
For more information about the AIR-provided catalogs, see tCatalog Table. |
| tCatalogModelXref | Stores the standard Touchstone model code that corresponds to each Touchstone catalog model code. |
| tCurrencyExchangeRateSet | Stores information about the exchange rate sets available in the application.
For more information about the currency exchange rate sets, see tCurrencyExchangeRateSetConversion Table. |
| tCurrencyExchangeRateSetConversion | Stores information about the exchange rate set that corresponds to each currency in the application.
For more information about the exchange rate sets, see tCurrencyExchangeRateSet Table. |
| tDbHistory | Stores information about any packages applied to the database. |
| tDBVersion | Stores the version of the database. |
| tDefaultDatabaseOption | Stores administrator-defined prefixes for the AIRResult and AIRExposure databases.
You define the prefixes in the Business Unit Management section of the Administration Console. The application automatically prepends the prefixes to any user-specified database names. |
| tDefaultExportLobOption | Stores the default AIR lines of business (LOBs) for company loss file (CLF) and UNICEDE/2 file export jobs.
Touchstone replaces any user-specified LOBs with the default LOBs for all countries where the default LOB is valid. Users can optionally override the default values. |
| tDefaultImpactAnalysisOption | Stores 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 default loss analysis options, such as the EP points to include in the analysis results. |
| tDefaultObject | Stores default object information. |
| tDefaultUserOption | Stores administrator-specified default currency rate and geocoding settings. |
| tDefaultUWAnalysisSetting | Stores administrator-specified default settings for analyses in underwriting contract mode. |
| tDefaultUWOption | Stores administrator-specified default settings for underwriting contract mode. |
| tDemandSurge | Stores information about the standard demand surge curves that are available in Touchstone.
For information about the custom, user-specified demand surge function, see tDemandSurgeFunction Table. |
| tDemandSurgeFunction | Stores information about custom, administrator-specified demand surge functions.
For information about the AIR-provided demand surge curves, see tDemandSurge Table. |
| tDQDefaultRuleSetTemplate | A 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. |
| tDQSetting | Stores the Data Quality analysis settings. |
| tEventSet | Stores the event sets that are available in Touchstone. |
| tEventSetCatalogXref | System 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. |
| tImpactAdminBoundaryPerilSet | Stores identifying information about a saved set of administrative boundary and peril combinations that you can use to configure a marginal impact analysis.
Check out AIRProject.tImpactAnalysisOption for analysis run without a marginal impact template. |
| tImpactAdminBoundaryPerilSetXref | Stores detailed information about a saved administrative boundary and peril combination that you can use to configure a marginal impact analysis.
Check out AIRProject.tImpactAnalysisOption for analysis run without a marginal impact analysis template. |
| tImportDefault | Provides the default settings for import jobs. |
| tImportMappingSet | Stores mappings between fields in input files and columns in target databases for import jobs. |
| tLocaleOverride | Stores information used to override region and language settings defined within the computer's operating system. |
| tLossCustomFrequency | This table stores information about the custom, user-defined custom event frequency during the loss analysis.
Custom Frequency template file allow the user to customize events that direct the Loss analysis engine to apply a specified events, AIR model, product, catalog, and event years directly to calculate the Ground-Up losses.
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 custom event frequency modification that is applied to losses from a peril applies also to losses generated by the respective sub-perils. |
| 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. |
| tLossModTemplateRuleSetEventParameterXref | System 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. |
| tLossVulnerabilitySet | Stores information about vulnerability loss sets. |
| tLossVulnerabilitySetDetails | Stores additional information about each loss vulnerability file sets. |
| tLossWidgetTemplate | Stores information about the custom, user-defined loss widget template.
Information regarding the underlying widget template is available in tWidgetTemplate Table. |
| tModel | Stores information about models that users have imported into Touchstone. |
| tModelCountryXref | System reference table that stores the countries associated with each user-imported model. |
| tModelInfo | Stores information about the models available in the application. |
| tObject | Stores information about the widget and template objects available in the application. |
| tSIDControl | Contains 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. |
| tUpgradeLog | Stores information about upgrade scripts. |
| tUserGeoMatchLevelMappingSet | Stores the user-supplied geocode and AIR-specific geocode corresponding to each mapping set. |
| 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 both the AIR-provided and user-created zones for geospatial analyses. |
| tZoneDefinition | Stores information about the AIR-provided zones for geospatial analyses.
For information about the AIR-provided zones, see tZone Table.
For information about user-defined zones for other analyses, see tGlobalZone Table. |
| tZoneSet | Stores information about both the user-provided zone sets for geospatial analysis and AIR-provided zone sets available in Touchstone. |
| tZoneSetZoneXref | System reference table that stores the zones that correspond to each AIR-provided zone set. |
