Touchstone 4.0 Database Documentation
tAnalysisTargetXref Table
System reference table used to the identify the target on which the analysis is going to be performed.
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 AnalysisSID

Unique system-generated sequential identifier for the analysis record.

For a complete list of records, see tAnalysis Table.

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

Unique, system-generated sequential identifier for the analysis target instance.

For a complete list of codes, see tAnalysisTargetType Table.


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

 AnalysisTargetNameName of the analysis target.VarChar255   
 AnalysisTargetAliasNameAlias for the analysis target.VarChar10  

Unique system-generated sequential identifier for the target's analysis data source record.

For a complete list of records, see tDataSource Table.

 AnalysisTargetDataSourceNameName of the analysis target database.VarChar255  
 RowVersionUsed for version stamping.Binary8   

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.

Objects that depend on tAnalysisTargetXref
 Database ObjectObject TypeDescriptionDep Level
tComparativeLossAnalysisTargetOption tabletComparativeLossAnalysisTargetOptionTableStores information regarding the target analysis in a Comparative Loss analysis.3
Objects that tAnalysisTargetXref depends on
 Database ObjectObject TypeDescriptionDep Level
tAnalysis tabletAnalysisTableStores information about each sub-section of the activity output. Each activity task creates and writes to this table as the task is performed.1
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.