Stores the average annual loss results, at the peril- and geography-level, from a detailed Loss analysis. This table is created when the user selects "Save Loss By Peril" and also selects a geographic area from the "Geography" drop-down box in the analysis Output Options.
| 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 | |
|---|---|---|---|---|---|---|---|
 | GeographySID | Unique system-generated sequential identifier for the geographic record. For a complete set of records, see tGeography Table. | int | 4 | |||
| | PerilSetCode | Numeric code for the single peril or set of perils. For a complete list of codes, see tPerilSet Table. | int | 4 | |||
| GeoLevelCode | Code that represents the geography level of the exposure. For a complete list of codes, see dbo.tGeoLevel Table. | varchar | 10 | ||||
| GeoCode | Geocode value. | varchar | 15 | ||||
| GeoName | Name that corresponds to the GeoCode. | varchar | 255 | ||||
| GroundUpLoss | Ground-Up loss value prior to the application of terms. For reinsurance, this is the ground-up loss for the treaty. | float | 9 |  | |||
| RetainedLoss | Retained loss value, which is the Ground-Up loss minus the insured Gross loss. | float | 9 | | |||
| PreLayerGrossLoss | Pre-layer Gross loss value, which is the expected gross loss value before the application of layer-level terms. | float | 9 | | |||
| GrossLoss | Gross loss value, which is the loss after layer-level terms are applied. | float | 9 | | |||
| NetOfPreCATLoss | Net-of-Pre Catastrophe loss value, which is the expected net loss value before the application of catastrophe excess of loss reinsurance. | float | 9 | | |||
| PostCATNetLoss | Net-of-Post Catastrophe loss value, which is the expected net loss value after the application of catastrophe excess of loss reinsurance. | float | 9 | |