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).
| 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. | int | 4 | |||
| AnalysisName | Name of the analysis that generated the results. | varchar | 255 | ||||
| AnalysisTypeCode | Code that represents the analysis type. For a complete list of codes, see tAnalysisType Table. | varchar | 10 | ||||
| CurrencyExchangeRateSet | Exchange rate set used to standardize the results to a common currency. | varchar | 40 | ||||
| CurrencyCode | ISO 3-character code for the currency. For a complete list of codes, see tCurrency Table. | char | 3 | ||||
| Description | User-provided description of the analysis. | varchar | 4000 |  | |||
| StatusCode | System-provided status code for the record in the table. For a complete list of codes, see tStatus Table. | varchar | 10 | ('A') | |||
| EnteredDate | Date and time when the analysis results were created. | datetime | 4 | ||||
| ExecutedDate | Date and time when the analysis results were last modified. | datetime | 4 | | |||
| CompletedDate | Date and time when the analysis results were generated. | datetime | 4 | | |||
| AnalysisUID | Unique, system-generated identifier for analysis set to which the results belong. | uniqueidentifier | 16 | ||||
| SourceTemplateName | Name of the analysis template used for the Detailed Loss analysis. | varchar | 255 | | |||
| IsTemplateCustomized | Indicates whether the user has customized the source template for the specific analysis.
| bit | 1 | | ((0)) |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
 | tAnalysisExposureView | Table | Stores information about exposure views used as analysis targets and the filters used to create the exposure views. | 1 |
| tAnalysisExposureViewDefinition | Table | Stores the exposure set(s) included in each exposure view used as an analysis target. | 2 |
| tAnalysisReinsAppliesToGeo | Table | Stores information about the geographic areas to which reinsurance treaties are applied. | 2 |
| tAnalysisReinsurance | Table | Stores information about any reinsurance treaties applied during analyses. | 1 |
| tAnalysisTarget | Table | 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. | 1 |