System reference table used to the identify the target of each analysis.
Touchstone 2022 Database Reference
tAnalysisTargetXref Table
System reference table used to the identify the target of each analysis.
| Creation Date | 4/4/2022 3:02 AM |
| File Group | PRIMARY |
| Text File Group | |
| System Object |  |
| Published for Replication | |
| Rows | 0 |
| Data Space Used | 0.00 KB |
| Index Space Used | 0.00 KB |
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
 | AnalysisSID | Unique system-generated sequential identifier for the analysis record. For a complete list of records, see tAnalysis Table. | int | 4 | |||
| | AnalysisTargetID | Identifier of the analysis target. | int | 4 | |||
| AnalysisTargetTypeCode | Code that specifies the type of the analysis target. For a complete list of codes, see tAnalysisTargetType Table. | varchar | 10 |  | |||
| AnalysisTargetSID | Unique system-generated sequential identifier for the analysis target record. | int | 4 | ||||
| AnalysisTargetName | Name of the analysis target. | varchar | 255 | ||||
| AnalysisTargetAliasName | Alias for the analysis target. | varchar | 10 | | |||
| AnalysisTargetDataSourceSID | Unique system-generated sequential identifier for the database that includes the analysis target. For a complete list of records, see tDataSource Table. | int | 4 | | |||
| AnalysisTargetDataSourceName | Name of the database that includes analysis target database. | varchar | 255 | | |||
| RowVersion | Used for version stamping. | timestamp | 8 | ||||
| AnalysisTargetRoleCode | Code that represents the role type of the analysis target. The code is used only for a Marginal Impact analyses. For a complete list of codes, see tAnalysisTargetRole Table. | varchar | 10 | |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
 | tComparativeLossAnalysisTargetOption | Table | Stores information regarding the target analysis in a Comparative Loss analysis. | 1 |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
| tAnalysis | Table | Stores information about each analysis. | 1 |
| tDataServer | Table | Stores information about each data server associated with the project, including the sequential identifier (SID), name, description, connection information, and default MDF and LDF paths for the server. | 2 |
| tDataSource | Table | Stores information about the databases registered with the application, for example, the exposure and results databases. | 1 |
| tExposureSet | Table | Stores exposure set information from each exposure database on the server. | 2 |
| tProject | Table | Stores information about each project, for example, the project name and status code. | 2 |