Stores information about reinstatement treaties included in reinsurance programs.
Touchstone Re 2022 Database Reference
tReinsuranceTreatyReinstatement Table
| 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 | |
|---|---|---|---|---|---|---|---|
 | ReinsuranceTreatyReinstatementSID | Unique system-generated sequential identifier for the reinstatement treaty. | int | 4 | |||
| ReinsuranceTreatySID | Unique system-generated sequential identifier for the reinsurance treaty. | int | 4 | ||||
| ReinstatementID | User-specified identifier for the reinstatement treaty. | int | 4 | ||||
| ReinstatementPremium | Reinstatement premium. A value of less than or equal to 1 indicates a percentage. | float | 9 | ||||
| AmountProvision | 100%, 75%, 50% or Pro Rata handling of reinstatement premium payments based on loss amount. The value 100% specifies that the total reinstatement premium amount is paid for the reinstatement. The value Pro Rata specifies that the reinstatement premium amount paid is in proportion to the percent of the occurrence limit that is exhausted. | float | 9 | ||||
| TimeProvision | 100%, 75%, 50%, none, or prorated handling of reinstatement premium payments based on time of loss. The value 100% specifies that the total reinstatement premium amount is paid for the reinstatement adjusted only for Reinstatement Provisions by Amount. The value Pro Rata specifies that the premium amount paid is in proportion to the time remaining on the reinsurance treaty as of the day on which the layer loss occurred. | float | 9 |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
 | tAppliesToArea | Table | Stores the names of Applies to Area filters. An Applies to Area filter specifies that a reinsurance treaty applies only to a given geographic area. | 2 |
| tCompany | Table | Stores information about companies. | 3 |
| tReinsuranceProgram | Table | Stores information about reinsurance programs. | 2 |
| tReinsuranceTreaty | Table | Stores information about reinsurance treaties included in reinsurance programs. | 1 |