Stores information about aggregate loss analysis results.
Touchstone Re 2022 Database Reference
tAnalysisResult Table
| 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. | 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 AnalysisType 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-specified description of the analysis. | varchar | 4000 |  | |||
| StatusCode | System-provided status code for the result. For a complete list of codes, see tStatus Table. | varchar | 10 | ('A') | |||
| EnteredDate | Date and time when the analysis was configured. | datetime | 4 | ||||
| ExecutedDate | Date and time when the analysis results was executed. | datetime | 4 | | |||
| CompletedDate | Date and time when the analysis results were generated. | datetime | 4 | | |||
| AnalysisUID | Unique system-generated identifier for analysis associated with the results. | uniqueidentifier | 16 | ||||
| SourceTemplateName | Name of the analysis template associated with the results. | varchar | 255 | | |||
| IsTemplateCustomized | Indicates whether the analysis template was customized.
| bit | 1 | | ((0)) |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
 | tAnalysisTarget | Table | Stores information about aggregate loss analysis targets. | 1 |