Stores the deltas for the aggregate event losses that are calculated during a Comparative Loss analysis.
| 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 | |
|---|---|---|---|---|---|---|---|
 | EventRowID | System-assigned table row identifier for the event. | bigint | 8 | |||
| GroundUpLoss | Ground-Up loss delta. | float | 9 |  | |||
| RetainedLoss | Retained loss delta. | float | 9 | | |||
| PreLayerGrossLoss | Pre-layer Gross loss delta. | float | 9 | | |||
| GrossLoss | Gross loss delta. | float | 9 | | |||
| NetOfPreCATLoss | Net-of-Pre Catastrophe loss delta. | float | 9 | | |||
| PostCATNetLoss | Net-of-Post Catastrophe loss delta. | float | 9 | | |||
| GroundUp_Rank | Unique identifier of the event that produced the highest Ground-Up loss in the simulated year. | bigint | 8 | | |||
| Retained_Rank | Unique identifier of the event that produced the highest Retained loss in the simulated year. | bigint | 8 | | |||
| PreLayerGross_Rank | Unique identifier of the event that produced the highest Pre-layer Gross loss in the simulated year. | bigint | 8 | | |||
| Gross_Rank | Unique identifier of the event that produced the highest Gross loss in the simulated year. | bigint | 8 | | |||
| NetOfPreCAT_Rank | Unique identifier of the event that produced the highest Net of Pre-Catastrophe loss in the simulated year. | bigint | 8 | | |||
| PostCATNet_Rank | Unique identifier of the event that produced the highest Net-of-Post Catastrophe loss in a simulated year. | bigint | 8 | |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
 | tRRRR_CMPLOSS_EventKey | Table | Stores information about the events used during the Comparative Loss analysis. | 1 |