Touchstone 4.0 Database Documentation
tAnalysisTarget Table

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.
Creation Date5/31/2016 9:45 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.

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

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.


Code that represents the analysis target type.

For a complete list of codes, see tAnalysisTargetType Table.


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

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

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.