System reference table used to the identify the target of each analysis.
Touchstone Re 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 | Not used by Touchstone Re. | varchar | 10 | |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
 | tAnalysis | Table | Stores information about each analysis. | 1 |
| tExposureSet | Table | Stores exposure set information from each exposure database on the server. | 3 |