Stores information about the target of each analysis.
A detailed loss analysis has one analysis target: an exposure view.
A marginal impact analysis has two analysis targets: the reference portfolio and the new portfolio or policy to assess.
A loss group analysis has two or more analysis targets: the loss result sets or loss groups to combine.
| Creation Date | 4/11/2022 5:46 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 on which the analysis is going to be performed. | int | 4 | |||
| AnalysisTargetRoleCode | 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. | 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 data structure that was analyzed. | varchar | 255 | ||||
| AnalysisTargetDataSourceName | Name of the database in which the analysis target is found. | 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 | Contains general information about the analyses that produced the results. The table includes one row for each analysis in the database, regardless of the analysis type (Loss, Loss Grouping, Catastrophe Excess of Loss, or Marginal Impact). | 1 |