Touchstone 4.0 Database Documentation
tAnalysisResult Table
Description
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).
Properties
Creation Date5/31/2016 9:45 AM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows0
Data Space Used0.00 KB
Index Space Used0.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key ResultSID

Unique system-generated sequential identifier for the results record.

Integer4   
 AnalysisNameName of the analysis that generated the results.VarChar255   
 AnalysisTypeCode

Code that represents the analysis type.

For a complete list of codes, see tAnalysisType Table.

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

ISO 3-character code for the currency.

For a complete list of codes, see tCurrency Table.

Char3   
 DescriptionUser-provided description of the analysis.VarChar4000  
 StatusCode

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

For a complete list of codes, see tStatus Table.

VarChar10 
('A')
 
 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  
 IsTemplateCustomized

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

  • 1 = Yes (customized)
  • 0 = No (not customized)
Boolean1
((0))
 
Objects that depend on tAnalysisResult
 Database ObjectObject TypeDescriptionDep Level
tAnalysisExposureView tabletAnalysisExposureViewTableWhen the analysis target is an exposure view, this table stores information about the analyzed exposure view and any filters used to create it.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.
1
See Also

Related Objects

AIRResult
Locating Results for a Specific Analysis

 

 


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.