| Creation Date | 4/11/2022 6:15 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 | |||
| 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 | When the analysis target is an exposure view, this table defines the exposure set(s) included in the exposure view. | 1 |
| tAnalysisExposureViewDefinition | Table | When the analysis target is an exposure view, this table defines the exposure set(s) included in the exposure view. | 2 |
| tAnalysisReinsAppliesToGeo | Table | Stores information about the geographic areas to which reinsurance treaties are applied. | 2 |
| tAnalysisReinsurance | Table | Stores information about any reinsurance treaties considered during the analyses. | 1 |
| tAnalysisTarget | Table | This table stores information about the data structures input to each analysis:
| 1 |