Stores event losses for one analysis by each combination of reinsurance portfolio, line of business (LOB), and zone.
Touchstone Re creates one table for each portfolio analysis that includes a reinsurance portfolio as the analysis target and LOB and Zone 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 | ||||
| ModelCode | Code that represents the catastrophe model that generated the losses. For a complete list of codes, see tModel Table. | smallint | 2 | ||||
| DayID | Identifier of the date that generated the losses. | int | 4 | ||||
| YearID | Identifier of the year that generated the losses. | int | 4 | ||||
| PortfolioSID | Numeric code for the single peril or set of perils. For a complete list of codes, see tPerilSet Table. | int | 4 |  | |||
| LOBCode | Numeric code for the line of business that generated the losses. For a complete list of codes, see tReinsuranceLOB Table. | int | 4 | ||||
| TSZoneSID | Unique system-provided identifier of the geographic zone that generated the losses. For a complete list of zones, see tRRRR_LOSS_DimReZone 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 | ||||
| TreatyLoss100Participation | Reinsurance treaty loss at 100% participation. | float | 9 | | |||
| TreatyLossGrossParticipation | Reinsurance treaty loss at the gross participation level. The gross participation level is the percentage of the losses assumed by the reinsurer before the reinsurer cedes any percentage of the losses to another reinsurer. | float | 9 | | |||
| TreatyLossNetParticipation | Reinsurance treaty loss at the net participation level. The net participation level is the percentage of the losses assumed by the reinsurer after the reinsurer cedes any percentage of the losses to another reinsurer. | float | 9 | | |||
| TreatyLossParticipation3 | Reinsurance treaty loss at the Participation3 level. | float | 9 | | |||
| TreatyLossParticipation4 | Reinsurance treaty loss at the Participation4 level. | 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 | | |||
| TreatyFinalNetLossGrossParticipation | Reinsurance treaty final net loss at the gross participation level. The gross participation level is the percentage of the losses assumed by the reinsurer before the reinsurer cedes any percentage of the losses to another reinsurer. The final net loss is the event loss less any reinstatement premium that is triggered by the payment of that event loss. | float | 9 | | |||
| TreatyFinalNetLossNetParticipation | Reinsurance treaty final net loss at the net participation level. The net participation level is the percentage of the losses assumed by the reinsurer after the reinsurer cedes any percentage of the losses to another reinsurer. The final net loss is the event loss less any reinstatement premium that is triggered by the payment of that event loss. | float | 9 | | |||
| TreatyFinalNetLossParticipation3 | Reinsurance treaty final net loss at the Participation3 level. The final net loss is the event loss less any reinstatement premium that is triggered by the payment of that event loss. | float | 9 | | |||
| TreatyFinalNetLossParticipation4 | Reinsurance treaty final net loss at the Participation4 level. The final net loss is the event loss less any reinstatement premium that is triggered by the payment of that event loss. | float | 9 | |