Stores event losses for one analysis by each combination of reinsurance treaty and geography.
Touchstone Re creates one table for each analysis that includes Treaty and Geography as output options.
| 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 | |
|---|---|---|---|---|---|---|---|
| CatalogTypeCode | Code that represents the type of catalog that produced the loss. For a complete list of codes, see tCatalogType Table. | varchar | 10 | ||||
| EventID | Unique system-provided identifier of the event that produced the loss. | int | 4 | ||||
| DayID | int | 4 | |||||
| YearID | Identifier of the year that generated the losses. | int | 4 | ||||
| ModelCode | Code that represents the catastrophe model that generated the losses. For a complete list of codes, see tModel Table. | smallint | 2 | ||||
| PerilSetCode | Numeric code for the single peril or set of perils. For a complete list of codes, see tPerilSet Table. | int | 4 | ||||
| GeographySID | Unique system-generated sequential identifier for the geographic record. For a complete list of records, see tGeography Table. | int | 4 | ||||
| ReTreatySID | Unique system-generated sequential identifier for the reinsurance treaty. For a complete list of records, see tReinsuranceTreaty Table. | int | 4 | ||||
| TreatyLoss100Participation | Reinsurance treaty loss at 100% participation. | float | 9 |  | |||
| TreatyFinalNetLoss100Participation | Reinsurance treaty final net loss at 100% participation. The final net loss is the event loss less any reinstatement premium that is triggered by the payment of that event loss. | float | 9 | |