Touchstone 2022 Database Reference
tAnalysisTarget Table
AIRExposureSummary Database : tAnalysisTarget Table
Description

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.
Properties
Creation Date4/11/2022 6:15 PM
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.

For a complete list of records, see tAnalysisResult Table.

int4   
Primary Key AnalysisTargetIDIdentifier of the analysis target on which the analysis is going to be performed.int4   
 AnalysisTargetRoleCode

Code that represents the role type of the analysis target. This is used only for a Marginal Impact analysis.

For a complete list of codes, see tAnalysisTargetRole Table.

varchar10  
 AnalysisTargetTypeCode

Code that represents the analysis target type.

For a complete list of codes, see tAnalysisTargetType Table.

varchar10   
 AnalysisTargetSID

Unique system-generated sequential identifier for the analysis target record.

int4   
 AnalysisTargetNameName of the data structure that was analyzed.varchar255   
 AnalysisTargetDataSourceNameName of the database in which the analysis target is found.varchar255  
 AnalysisTargetDataSourceUIDUnique system-generated identifier for the database where analysis target is found.uniqueidentifier16  
Objects that tAnalysisTarget depends on
 Database ObjectObject TypeDescriptionDep Level
tAnalysisResult tabletAnalysisResultTableContains 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).1
See Also

Related Objects

AIRExposureSummary Database

 

 

Verisk Analytics Client Confidential

© 2022. AIR Worldwide is now Extreme Event Solutions. AIR Worldwide is a registered trademark. Touchstone is a registered trademark of AIR Worldwide.

Please contact Verisk Analytics with questions or comments.