Stores information about the reinsurance treaties or layers that generated loss during a portfolio loss analysis.
Touchstone Re creates one table for each portfolio loss analysis.
| 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 | |
|---|---|---|---|---|---|---|---|
| ReinsuranceTreatySID | 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 portfolio that includes the reinsurance treaty. For a complete list of records, see tPortfolio Table. | int | 4 | ||||
| PrincipalAmount | Principal amount. | float | 9 |  | |||
| InvestmentAmount | Investment amount. | float | 9 | | |||
| PercentAnnualSpread | Coupon spread for the reinsurance treaty over LIBOR. | float | 9 | | |||
| ParticipationNet | Net participation. 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 | | |||
| ParticipationGross | Gross participation. 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 | | |||
| Participation3 | User-specified Participation3 value. Participation3 is listed in tReinsuranceTreaty Table. | float | 9 | | |||
| Participation4 | User-specified Participation4 value. Participation4 is listed in tReinsuranceTreaty Table. | float | 9 | | |||
| Premium | Premium amount. | float | 9 | | |||
| ReinstatementPremium | Reinstatement premium. A value of less than or equal to 1 indicates a percentage. | float | 9 | | |||
| EnteredDate | Date and time the record was created. | datetime | 4 | | |||
| EditedDate | Date and time the record was last edited. | datetime | 4 | |