Stores information about the reinsurance treaties that generated loss during a loss analysis.
Touchstone Re creates one table for each analysis that includes Treaty as an output option.
| 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 | |
|---|---|---|---|---|---|---|---|
| ReProgramSID | Unique system-provided identifier for the reinsurance program record. For a complete list of records, see tReinsuranceProgram Table. | int | 4 | ||||
| ReTreatySID | Unique system-generated sequential identifier for the reinsurance treaty. For a complete list of records, see tReinsuranceTreaty Table. | int | 4 | ||||
| ReTreatyID | User-specified identifier for the reinsurance treaty. | varchar | 100 | ||||
| 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 |  | |||
| 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 | | |||
| Participation3 | User-specified Participation3 value. Participation3 is listed in tReinsuranceTreaty Table. | float | 9 | | |||
| Participation4 | User-defined Participation4 value. Participation4 is listed in tReinsuranceTreaty Table. | float | 9 | | |||
| OccurrenceLimit | Occurrence limit. | float | 9 | | |||
| OccurrenceRetention | Occurrence retention. | float | 9 | | |||
| AggregateLimit | Aggregate limit. | float | 9 | | |||
| AggregateRetention | Aggregate retention. | float | 9 | | |||
| InuringSequenceNumber | Number that represents the inuring order of the treaty. | int | 4 | | |||
| StepLayerSequenceNumber | Number that represents the order of application for the step layer. | int | 4 | | |||
| ReinsuranceTypeCode | Code that represents the reinsurance type. For a compete list of codes, see tReinsuranceType Table. | varchar | 10 | ||||
| PlacedAmount | Amount placed. | float | 9 | | |||
| InvestmentAmount | Investment amount. | float | 9 | | |||
| CoinsuranceAmount | Percentage of insurer's coinsurance, expressed as a decimal value. Insurer's coinsurance is the portion of the losses to the layer that the cedant retains. For example, if the coinsurance value is .05, then the cedant retains 5 percent of the losses. Insurer’s coinsurance is not applicable for catastrophe bond programs. | float | 9 | | |||
| Reinstatement | The maximum number of times the risk limit can be reinstated after the application of a loss amount during the coverage period, where 0 represents no reinstatements and 999 represents unlimited reinstatements. | smallint | 2 | |