Stores average annual losses for one analysis by reinsurance treaty.
Touchstone Re creates one table for each analysis that includes a reinsurance portfolio as the analysis target.
| 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 | |
|---|---|---|---|---|---|---|---|
| EPAnnualTypeCode | Code that indicates whether the losses are based on all events that occurred during a year (aggregate) or on the single largest loss caused by all events in a year (occurrence). For a complete list of codes, see tEPAnnualType Table. | varchar | 3 | ||||
| ReTreatySID | Unique system-generated sequential identifier for the reinsurance treaty. For a complete list of records, see tReinsuranceTreaty Table. | int | 4 | ||||
| PortfolioSID | Unique system-generated sequential identifier for the reinsurance portfolio. For a complete list of records, see tPortfolio 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. Participation3 is listed in tReinsuranceTreaty Table. | float | 9 | | |||
| TreatyLossParticipation4 | Reinsurance treaty loss at the Participation4 level. Participation4 is listed in tReinsuranceTreaty Table. | 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 | |