Touchstone 4.0 Database Documentation
tAnalysisResult Table
Contains general information about the analyses that produced the results. The table contains one row for each analysis in the database, regardless of the analysis type (Loss, Loss Grouping, Catastrophe Excess of Loss, or Marginal Impact).
Creation Date5/31/2016 9:46 AM
Text File Group
System Object
Published for Replication
Data Space Used0.00 KB
Index Space Used0.00 KB
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key ResultSID

Unique system-generated sequential identifier for the results record.

For a complete list of records, see tAnalysisResult Table.

 AnalysisNameName of the analysis that generated the results.VarChar255   

Code that represents the analysis type.

For a complete list of codes, see tAnalysisType Table.

 CurrencyExchangeRateSetExchange rate set used to standardize the results to a common currency.VarChar40   

ISO 3-character code for the currency.

For a complete list of codes, see tCurrency Table.

 DescriptionUser-provided description of the analysis.VarChar4000  

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

For a complete list of codes, see tStatus Table.

 EnteredDateDate and time when the analysis results were created.DBTimeStamp4   
 ExecutedDateDate and time when the analysis results were last modified.DBTimeStamp4  
 CompletedDateDate and time when the analysis results were generated.DBTimeStamp4  
 AnalysisUIDUnique, system-generated identifier for analysis set to which the results belong.GUID16   
 SourceTemplateNameName of the analysis template used for the Detailed Loss analysis.VarChar255  

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

  • 1 = Yes (customized)
  • 0 = No (not customized)
Objects that depend on tAnalysisResult
 Database ObjectObject TypeDescriptionDep Level
tAnalysisExposureView tabletAnalysisExposureViewTableWhen the analysis target is an exposure view, this table defines the exposure set(s) included in the exposure view.1
tAnalysisExposureViewDefinition tabletAnalysisExposureViewDefinitionTableWhen the analysis target is an exposure view, this table defines the exposure set(s) included in the exposure view.2
tAnalysisReinsAppliesToGeo tabletAnalysisReinsAppliesToGeoTableStores information about the geographic areas to which reinsurance treaties are applied.2
tAnalysisReinsurance tabletAnalysisReinsuranceTableStores information about any reinsurance treaties considered during the analyses.1
tAnalysisTarget tabletAnalysisTargetTable

This table stores information about the data structures input to each analysis:

  • A detailed loss analysis has a single analysis target, e.g. an exposure view.
  • A marginal impact analysis has two analysis targets, the reference portfolio and the new portfolio or policy whose impact will be assessed.
  • Loss grouping has two or more analysis targets, the loss result sets or loss groups that are being grouped together.
See Also

Related Objects

AIRExposureSummary 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.