Touchstone 4.0 Database Documentation
tAnalysis Table
Description
Stores information about each sub-section of the activity output. Each activity task creates and writes to this table as the task is performed.
Properties
Creation Date5/31/2016 9:45 AM
File GroupPRIMARY
Text File GroupPRIMARY
System Object
Published for Replication
Rows10
Data Space Used8.00 KB
Index Space Used72.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key AnalysisSIDUnique system-generated sequential identifier for the analysis record.Integer4   
 AnalysisTypeCode

Code that represents the analysis type.

For a complete list of codes, see tAnalysisType Table.

VarChar10   
 ProjectSID

Unique system-generated sequential identifier for the project record.

For a complete list of records, see tProject Table.

Integer4  
 AnalysisNameUser-provided name of the analysis.VarChar255   
 DescriptionUser-provided description of the analysis.VarChar4000  
 AnalysisStatusCode

Code that indicates the status of an analysis instance.  For internal use only.
Note: Use ActivityStatusCode in tActivity Table for determining the status of an analysis.

For a complete list of codes, see tAnalysisStatus Table.

VarChar10   
 AuthorUser that initiated the analysis.VarChar255  
 EnteredDateDate and time when the analysis was configured.DBTimeStamp4 
(getutcdate())
 
 ResultDataSourceSID

Unique system-generated sequential identifier of the results' source record; it acts as a primary key in relation to the Exposure Concentration analysis results tables, available in the AIRResult Database.

For a complete list of records, see tDataSource Table.

Integer4  
 ResultDataSourceNameThe name of the data source that contains the analysis results. This is either the AIRResult Database or the AIRExposureSummary database.VarChar255  
 ResultSIDUnique system-generated sequential identifier for the results record.Integer4  
 CurrencyExchangeRateSetSID

Unique system-generated sequential identifier for the currency exchange rates record.

For a complete list of records, see tCurrencyExchangeRateSet Table.

Integer4   
 CurrencyCode

ISO 3-character code for the currency.

For a complete list of codes, see tCurrency Table.

Char3   
 ExecutedDateDate and time the analysis was executed.DBTimeStamp4  
 StatusCode

System-provided status code for the record in the table.

For a complete list of codes, see tStatus Table.

VarChar10 
('A')
 
 CompletedDateDate and time when the analysis results were generated.DBTimeStamp4  
 AdvancedJobOptionXML expression for the user-provided advanced job options used during an analysis. For internal use by Touchstone.Xml16  
 AnalysisUIDUnique, system-generated identifier for the analysis instance. Used for creating staging tables in the work database.GUID16 
(newid())
 
 SourceTemplateNameName of the analysis template used for the analysis.VarChar255  
 IsTemplateCustomized

Indicates whether the user has customized the source template for the specific analysis.

  • 1 = Yes (customized)
  • 0 = No (not customized)
Boolean1  
 BusinessUnitSID

Unique system-generated sequential identifier for the business unit.

Integer4  
 RowVersionUsed for version stamping.Binary8   
 AnalysisProductVersion

Version of the product used to perform the analysis.

This enables users to view results generated from previous version of Touchstone,  even when the models are updated.

VarChar10 
('3.0.X')
 
Objects that depend on tAnalysis
 Database ObjectObject TypeDescriptionDep Level
tActivity tabletActivityTableStores the ActivitySID, the AnalysisSID and the ProjectSID, which you need to find the location of your analysis results.1
tActivityHpcJob tabletActivityHpcJobTableStores information about each activity that is submitted to the HPC server.2
tActivityOutput tabletActivityOutputTableStores 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.2
tActivityOutputDetail tabletActivityOutputDetailTableStores information about each sub-section of the activity output. Each activity task creates and writes to this table as the task is performed.3
tActivityParentXref tabletActivityParentXrefTableSystem reference table used to associate an activity to the parent activity.2
tActivityTargetStatus tabletActivityTargetStatusTableStores information about each sub-section of the activity output. Each activity task creates and writes to this table as the task is performed.2
tAnalysisFilterXRef tabletAnalysisFilterXRefTableSystem reference table used to the identify the analysis IDs, as well as their associated filters.2
tAnalysisTargetXref tabletAnalysisTargetXrefTableSystem reference table used to the identify the target on which the analysis is going to be performed.2
tClashAnalysisOption tabletClashAnalysisOptionTableStores the hold options settings for a clash underwriting analysis.2
tComparativeLossAnalysisOption tabletComparativeLossAnalysisOptionTableStores the values used to generate the results in a Comparative Loss analysis.2
tComparativeLossAnalysisTargetOption tabletComparativeLossAnalysisTargetOptionTableStores information regarding the target analysis in a Comparative Loss analysis.3
tDataQualityAnalysisOption tabletDataQualityAnalysisOptionTableStores information regarding the augmentation of data during a Data Quality analysis.2
tDataQualityAnalysisOutputOption tabletDataQualityAnalysisOutputOptionTableStores the output options for a Data Quality analysis.3
tDataSourceActivityOption tabletDataSourceActivityOptionTableStores information about the data source created by a specific activity. A data source is a database that is registered with the Touchstone application.2
tDQAnalysisRule tabletDQAnalysisRuleTableStores data relating to the rules used in a Data Quality analysis.5
tDQAnalysisRuleSet tabletDQAnalysisRuleSetTableStores information regarding the rule sets used during a Data Quality analysis.4
tDQAnalysisRuleSetRuleSubTypeSelected tabletDQAnalysisRuleSetRuleSubTypeSelectedTableStores information regarding the rule sub type used during the Data Quality analysis.5
tDQAnalysisSetting tabletDQAnalysisSettingTableStores information regarding the analysis settings used during a Data Quality analysis.4
tDQIndustryFilterLOB tabletDQIndustryFilterLOBTableStores the type of output of the Data Quality analysis and the Line of Business of the insured properties to include in the output results.4
tECAAreaZoneOption tabletECAAreaZoneOptionTableStores the zone set identifiers used during a Geospatial analysis.3
tECACustomSaveOption tabletECACustomSaveOptionTableStores user-defined accumulators that are used in a Geospatial analysis. Reserved for future use.3
tECARingDefinition tabletECARingDefinitionTableStores information regarded the rings used during a Geospatial analysis.4
tECARingGeoMatchLevelOption tabletECARingGeoMatchLevelOptionTableStores information about the geocode match level achieved during the Geospatial \analysis.4
tECARingLandmarkOption tabletECARingLandmarkOptionTableStores information about the landmarks used during a Geospatial analysis.4
tECARingLocationList tabletECARingLocationListTableStores information about the locations included in the Geospatial analysis.4
tECARingOption tabletECARingOptionTableStores information about the ring options selected for the Geospatial analysis.3
tECASpatialDataSetBucketDefinition tabletECASpatialDataSetBucketDefinitionTableStores 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.4
tECASpatialDataSetBucketDetail tabletECASpatialDataSetBucketDetailTableStores 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.5
tECASpatialDataSetOption tabletECASpatialDataSetOptionTableStores information regarding the spatial data set options used during the Geospatial analysis.3
tECASpatialEventOption tabletECASpatialEventOptionTableStores information regarding the events for each model to include during the Geospatial analysis.3
tECASpatialLossOption tabletECASpatialLossOptionTableStores information regarding the loss analysis options used during the Geospatial analysis.3
tExportActivityFilter tabletExportActivityFilterTableStores information about the filter attribute applied during export.3
tExportActivityOption tabletExportActivityOptionTableStores information regarding the export type.2
tExposureConcentrationAnalysisOption tabletExposureConcentrationAnalysisOptionTableStores the options used during a Geospatial analysis.2
tEXPSAnalysisOutputOption tabletEXPSAnalysisOutputOptionTableStores the output options used for the Exposure Summary analysis.2
tHazardAnalysisAttributeOption tabletHazardAnalysisAttributeOptionTableStores information about the attributes applied during a Hazard analysis.3
tHazardAnalysisOption tabletHazardAnalysisOptionTableStores information regarding the options selected for a Hazard analysis.2
tHazardAnalysisOutputOption tabletHazardAnalysisOutputOptionTableStores information regarding the output from a Hazard analysis.2
tImpactAnalysisOption tabletImpactAnalysisOptionTableStores information regarding the analysis options used during a Marginal Impact analysis.2
tImportActivityOption tabletImportActivityOptionTableStores information about an import activity.2
tIntensityAttributeOption tabletIntensityAttributeOptionTableStores information regarding the intensity attribute used during a Hazard analysis.2
tLossAnalysisDemandSurgeOption tabletLossAnalysisDemandSurgeOptionTableStores information regarding the demand surge, by area, used during a Loss analysis.3
tLossAnalysisFloodOption tabletLossAnalysisFloodOptionTableStores information regarding the custom flood zones used during a Loss analysis.3
tLossAnalysisOption tabletLossAnalysisOptionTableStores information regarding the options selected for a Loss analysis.2
tLossAnalysisPerilSetULOBOption tabletLossAnalysisPerilSetULOBOptionTableStores 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.3
tLossAnalysisSTStormOption tabletLossAnalysisSTStormOptionTableStores information regarding the severe storm options using during a Loss analysis.3
tLossAnalysisTerrorismOption tabletLossAnalysisTerrorismOptionTableStores information regarding the terrorism options used during a Loss analysis.3
tNonCatAnalysisOption tabletNonCatAnalysisOptionTableStores analysis options used during a non-catastrophe Loss analysis.2
Objects that tAnalysis depends on
 Database ObjectObject TypeDescriptionDep Level
tDataServer tabletDataServerTableStores information about each data server used in the project, including its sequential identifier (SID), name, description, connection information, and default MDF and LDF paths.3
tDataSource tabletDataSourceTableStores information about the data source used for the Touchstone project. A data source is a database that is registered with the Touchstone application.2
tProject tabletProjectTableStores information regarding the project, such as project name and status code.1
See Also

Related Objects

AIRProject Database

 

 


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.