Stores information about aggregate loss analysis targets.
Touchstone Re 2022 Database Reference
tAnalysisTarget Table
Stores information about aggregate loss analysis targets.
| Creation Date | 4/11/2022 6:17 PM |
| 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 | |
|---|---|---|---|---|---|---|---|
 | ResultSID | Unique system-generated sequential identifier for the results record. For a complete list of records, see tAnalysisResult Table. | int | 4 | |||
| | AnalysisTargetID | Identifier of the analysis target associated with the results. | int | 4 | |||
| AnalysisTargetRoleCode | Not used by Touchstone Re. | varchar | 10 |  | |||
| AnalysisTargetTypeCode | Code that represents the analysis target type. 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 | ||||
| AnalysisTargetDataSourceName | Name of the database that contains the analysis target. | varchar | 255 | | |||
| AnalysisTargetDataSourceUID | Unique system-generated identifier for the database where analysis target is found. | uniqueidentifier | 16 | |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
 | tAnalysisResult | Table | Stores information about aggregate loss analysis results. | 1 |