Stores information about reinsurance treaties included in reinsurance programs.
Touchstone Re 2022 Database Reference
tReinsuranceTreaty 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 | |
|---|---|---|---|---|---|---|---|
 | ReinsuranceTreatySID | Unique system-generated sequential identifier for the reinsurance treaty. | int | 4 | |||
| ReinsuranceProgramSID | Unique system-generated sequential identifier for a reinsurance program. For a complete list of records, see tReinsuranceProgram Table. | int | 4 |  | |||
| AppliesToAreaSID | Unique system-generated sequential identifier for the user-specified area associated with the reinsurance treaty. For a complete list of records, see tAppliesToArea Table. | int | 4 | | |||
| ReinsuranceTypeCode | Code that indicates the type of the reinsurance treaty. For a complete list of codes, see tReinsuranceType Table. | varchar | 10 | ||||
| ReinsuranceID | User-specified identifier for the reinsurance treaty. | varchar | 100 | ||||
| SubmitStatusCode | Code that represents the submission status of the reinsurance treaty. For a complete list of codes, see tStatus Table. | varchar | 10 | ||||
| PerilSetCode | Numeric code for the single peril or set of perils associated with the reinsurance treaty. For a complete list of codes, see tPerilSet Table. | int | 4 | ||||
| TriggerTypeCode | Code that represents when or how the reinsurance treaty is applied. For a complete list of codes, see tTriggerType Table. | varchar | 10 | | |||
| ReinsTargetTypeCode | Code that represents the type of the reinsurance treaty target. For a complete list of codes, see tReinsTargetType Table. | varchar | 10 | | |||
| PreferredExposureTypeCode | Code that represents the preferred exposure type. For a complete list of codes, see tPreferredExposureType Table. | varchar | 10 | | |||
| CedantName | Name of the primary insurer or insurance company that purchased reinsurance. | varchar | 60 | | |||
| ReinsurerName | Name of the insurer or reinsurer who assumes the cedant's risk under the reinsurance treaty. | varchar | 60 | | |||
| InceptionDate | Inception date of the reinsurance program, which is also referred to as the Effective From date. | date | 8 | | |||
| ExpirationDate | Expiration date of the reinsurance program, which is also referred to as the Effective To date. | date | 8 | | |||
| CurrencyCode | ISO 3-character code for the currency. For a complete list of codes, see tCurrency Table. | char | 3 | | |||
| RiskLimit | For per-risk programs, the maximum loss that can be incurred by the layer for one occurrence. | float | 9 | | |||
| RiskRetention | For per-risk programs, the value below which the total losses are not assumed by the layer. | float | 9 | | |||
| OccurrenceLimit | Maximum loss that the treaty can incur from a single occurrence. | float | 9 | | |||
| OccurrenceRetention | The value below which the total losses are not assumed by the layer. | float | 9 | | |||
| AggregateLimit | Maximum amount payable under the reinsurance treaty that provides overall loss limitation. | float | 9 | | |||
| AggregateRetention | Additional dollar amount or percentage of risk retained by the ceding company under a reinsurance treaty. | float | 9 | | |||
| CededAmount | Ceded percentage expressed as a decimal, for example .3, which corresponds to 30%.
CededPercent appears as a percentage in the user interface but is stored in the database as a decimal.
| float | 9 | | |||
| PlacedAmount | Percentage of the treaty placed with the reinsurer, for example 1, which corresponds to 100%.
PlacedAmount appears as a percentage in the user interface but is stored in the database as a decimal.
| float | 9 | | |||
| IndustryLossMinimum | Minimum amount of industry loss. | float | 9 | | |||
| IndustryLossMaximum | Maximum amount of industry loss. | float | 9 | | |||
| CompanyLossMinimum | Minimum amount of company loss. | float | 9 | | |||
| CompanyLossMaximum | Maximum amount of company loss. | 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 | | |||
| PremiumMinimum | The minimum premium paid for coverage of the reinsurance treaty per reinstatement. | float | 9 | | |||
| PremiumEstimated | The estimated premium paid for coverage of the reinsurance treaty per reinstatement. | float | 9 | | |||
| LossesPaid | User-provided amount of losses paid on the account. | float | 9 | | |||
| ParticipationNet | Net participation amount or percentage. | float | 9 | | |||
| ParticipationGross | Gross participation amount or percentage. | float | 9 | | |||
| LossModificationFactor | User-specified factor used to modify losses in the reinsurance treaty. | float | 9 | | |||
| StartingEventNumber | Event number at which the reinsurance treaty was applied. | int | 4 | | |||
| 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 | | |||
| ReinstProvisionalAmount | Handling of reinstatement premium payments based on loss amount, for example, 100%, 75%, 50%, or Pro Rata. 100% specifies that the total premium amount (PremiumEstimated) is paid for the reinstatement. Pro Rata specifies that the reinstatement premium amount paid is in proportion to the percent of the occurrence limit that is exhausted. | float | 9 | | |||
| ReinstProvisionalTime | Handling of reinstatement premium payments based on time of loss, for example, 100%, 75%, 50%, or Pro Rata. 100% specifies that the total premium amount (PremiumEstimated) is paid for the reinstatement adjusted only for Reinstatement Premiums by Amount. Pro Rata specifies that the reinstatement 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 | | |||
| IsMatchLossToLimit | Indicates whether the loss is set to match the limit. For example, if the loss is set to match the limit for a treaty that specifies an occurrence retention of $100 and an occurrence limit of $500, and the company incurs a loss of $101, then the treaty loss is the full $500 . If the loss is not set to match the limit, then the treaty loss would be $1.
| bit | 1 | | |||
| ReinsAppliesToLOB | Lines of business associated with the reinsurance treaty. | varchar | 4000 | | |||
| ReinsAppliesToEvent | Reserved for future use. | varchar | 4000 | | |||
| InuringSequenceNumber | Inuring order of the reinsurance treaty. | int | 4 | | |||
| Description | User-specified description of the reinsurance treaty. | varchar | 4000 | | |||
| EnteredDate | Date and time the reinsurance treaty was created. | datetime | 4 | ||||
| EditedDate | Date and time the reinsurance treaty was last edited. | datetime | 4 | ||||
| Premium | Premium amount. A value of less than or equal to 1 indicates a percentage. | float | 9 | | |||
| ReinstatementPremium | Reinstatement premium. A value of less than or equal to 1 indicates a percentage. | float | 9 | | |||
| CusipID | Unique Committee on Uniform Security Identification Procedures (CUSIP) identifier. CusipID applies only to catastrophe bonds issued in the U.S. and Canada. | varchar | 15 | | |||
| PrincipalAmount | Principal amount. | float | 9 | | |||
| InvestmentAmount | Investment amount. | float | 9 | | |||
| PercentAnnualSpread | Coupon spread for the reinsurance treaty over LIBOR. | float | 9 | | |||
| StepLayerSequenceNumber | Code that represents the type of layer represented by the reinsurance treaty.
| int | 4 | | |||
| AggregateResetDay | For internal use by Touchstone Re. | int | 4 | | |||
| Participation3 | User-specified participation. | float | 9 | | |||
| Participation4 | User-specified participation. | float | 9 | | |||
| ReinsuranceTag | Reserved for future use. | varchar | 255 | |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
 | tAppliesToEventFilter | Table | Stores information about event filters. An event filter specifies that a reinsurance treaty applies only to events that meet certain criteria. You can create an event filter that includes event parameters, a latitude and longitude pair, or a list of areas. | 1 |
| tAppliesToEventFilterGeoXRef | Table | Stores information about event filters that include geographic areas. An event filter specifies that a reinsurance treaty applies only to events that meet certain criteria. You can create an event filter that includes event parameters, a latitude and longitude pair, or a list of areas. | 2 |
| tAppliesToEventFilterLatLong | Table | Stores information about event filters that include latitude and longitude pairs. An event filter specifies that a reinsurance treaty applies only to events that meet certain criteria. You can create an event filter that includes event parameters, a latitude and longitude pair, or a list of areas. | 2 |
| tAppliesToEventFilterRule | Table | Stores information about event filters that include event parameters, such as earthquake depth or hurricane central pressure. An event filter specifies that a reinsurance treaty applies only to events that meet certain criteria. You can create an event filter that includes event parameters, a latitude and longitude pair, or a list of areas. | 2 |
| tReinsuranceTreatyReinstatement | Table | Stores information about reinstatement treaties included in reinsurance programs. | 1 |
| tReinsuranceTreatyTerrorismOption | Table | Stores information about the terrorism coverage for each reinsurance treaty. | 1 |
| tReinsuranceTreatyUDCClassification_Xref | Table | Stores relationships between user-defined categories (UDCs) and reinsurance treaties. | 1 |
| 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 |