Touchstone 4.0 Database Documentation
AIRProject Database
Description

The AIRProject database stores information about Touchstone projects, such as:

  • Activity parameters and output details
  • Analysis descriptions, statuses, filters, targets, and results
  • Data server and data source
  • Data Quality analysis rules, settings, and filters
  • Geospatial analysis zones, ring definitions, geocode match level options, landmark options, location lists, spatial data bucket definitions, spatial data set options, event options, and spatial loss options
  • Export Activity options and filters
  • Exposure View definitions and filters
  • Exposure analysis output options
  • Hazard analysis attributes and output options
  • Loss analysis options, peril set user line of business, demand surge options, and terrorism option
  • Non-catastrophe analysis options
  • Comparative Loss analysis options

Schema Diagram

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

Tables
TableDescription
tActivityStores the ActivitySID, the AnalysisSID and the ProjectSID, which you need to find the location of your analysis results.
tActivityHpcJobStores information about each activity that is submitted to the HPC server.
tActivityOutputStores the ID of an activity and its output, status information, and the file path to the output. An activity output is a logical group of one or more activity task outputs.
tActivityOutputDetailStores information about each sub-section of the activity output. Each activity task creates and writes to this table as the task is performed.
tActivityParentXrefSystem reference table used to associate an activity to the parent activity.
tActivityTargetStatusStores information about each sub-section of the activity output. Each activity task creates and writes to this table as the task is performed.
tAnalysisStores information about each sub-section of the activity output. Each activity task creates and writes to this table as the task is performed.
tAnalysisFilterXRefSystem reference table used to the identify the analysis IDs, as well as their associated filters.
tAnalysisTargetXrefSystem reference table used to the identify the target on which the analysis is going to be performed.
tClashAnalysisOptionStores the hold options settings for a clash underwriting analysis.
tComparativeLossAnalysisOptionStores the values used to generate the results in a Comparative Loss analysis.
tComparativeLossAnalysisTargetOptionStores information regarding the target analysis in a Comparative Loss analysis.
tDataChangeTrackingStores all the RowVersion information needed to determine if any of the data associated with a particular Touchstone activity has changed since the activity completed.
tDataChangeTrackingHashReserved for future use.
tDataQualityAnalysisOptionStores information regarding the augmentation of data during a Data Quality analysis.
tDataQualityAnalysisOutputOptionStores the output options for a Data Quality analysis.
tDataServerStores information about each data server used in the project, including its sequential identifier (SID), name, description, connection information, and default MDF and LDF paths.
tDataSourceStores information about the data source used for the Touchstone project. A data source is a database that is registered with the Touchstone application.
tDataSourceActivityOptionStores information about the data source created by a specific activity. A data source is a database that is registered with the Touchstone application.
tDBVersion

Defines the version of the database.

tDQAnalysisRuleStores data relating to the rules used in a Data Quality analysis.
tDQAnalysisRuleSetStores information regarding the rule sets used during a Data Quality analysis.
tDQAnalysisRuleSetRuleSubTypeSelectedStores information regarding the rule sub type used during the Data Quality analysis.
tDQAnalysisSettingStores information regarding the analysis settings used during a Data Quality analysis.
tDQIndustryFilterLOBStores the type of output of the Data Quality analysis and the Line of Business of the insured properties to include in the output results.
tECAAreaZoneOptionStores the zone set identifiers used during a Geospatial analysis.
tECACustomSaveOptionStores user-defined accumulators that are used in a Geospatial analysis. Reserved for future use.
tECARingDefinitionStores information regarded the rings used during a Geospatial analysis.
tECARingGeoMatchLevelOptionStores information about the geocode match level achieved during the Geospatial \analysis.
tECARingLandmarkOptionStores information about the landmarks used during a Geospatial analysis.
tECARingLocationListStores information about the locations included in the Geospatial analysis.
tECARingOptionStores information about the ring options selected for the Geospatial analysis.
tECASpatialDataSetBucketDefinitionStores information that defines the buckets used in a Geospatial analysis. A bucket is a range of attribute values that is analyzed as a single entity with a single damage ratio; For example, a bucket of wind speed could be 60 – 70 miles per hour.
tECASpatialDataSetBucketDetailStores information regarding the data set bucket used during the Geospatial analysis. A bucket is a range that is analyzed as a single entity with a single damage ratio; For example, a bucket of wind speed could be 60 – 70 miles per hour.
tECASpatialDataSetOptionStores information regarding the spatial data set options used during the Geospatial analysis.
tECASpatialEventOptionStores information regarding the events for each model to include during the Geospatial analysis.
tECASpatialLossOptionStores information regarding the loss analysis options used during the Geospatial analysis.
tExportActivityFilterStores information about the filter attribute applied during export.
tExportActivityOptionStores information regarding the export type.
tExposureConcentrationAnalysisOptionStores the options used during a Geospatial analysis.
tExposureViewStores information regarding exposures views.
tExposureViewDefinitionStores information about the exposure sets that are part of the exposure view optionally with a filter.
tExposureViewFilterXRefSystem reference table used to identify the exposure view filters.
tEXPSAnalysisOutputOptionStores the output options used for the Exposure Summary analysis.
tFilterStores information about exposure view filters, such as filter code and entered date.
tHazardAnalysisAttributeOptionStores information about the attributes applied during a Hazard analysis.
tHazardAnalysisOptionStores information regarding the options selected for a Hazard analysis.
tHazardAnalysisOutputOptionStores information regarding the output from a Hazard analysis.
tImpactAnalysisOptionStores information regarding the analysis options used during a Marginal Impact analysis.
tImportActivityOptionStores information about an import activity.
tIntensityAttributeOptionStores information regarding the intensity attribute used during a Hazard analysis.
tLossAnalysisDemandSurgeOptionStores information regarding the demand surge, by area, used during a Loss analysis.
tLossAnalysisFloodOptionStores information regarding the custom flood zones used during a Loss analysis.
tLossAnalysisOptionStores information regarding the options selected for a Loss analysis.
tLossAnalysisPerilSetULOBOptionStores information regarding the perils and Lines of Business analyzed during the Loss analysis. In addition, it also identifies the percentage of the loss from storm surge or precipitation flood, when applicable.
tLossAnalysisSTStormOptionStores information regarding the severe storm options using during a Loss analysis.
tLossAnalysisTerrorismOptionStores information regarding the terrorism options used during a Loss analysis.
tNonCatAnalysisOptionStores analysis options used during a non-catastrophe Loss analysis.
tProjectStores information regarding the project, such as project name and status code.
tProjectExposureViewXrefSystem reference table used to identify the relationship between the project and exposure views.
tShrinkQueue

Reserved for internal use.  Stores records that were shrunk using functionality built into SQL Server. An internal wrapper around this functionality ensures that shrinking: 

  • only affects AIR databases.
  • does not work on databases that are in use by other AIR processes.
  • Performs robust yet incremental shrinks that frees disk space almost immediately.
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.

 

 


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.