CEDE 8.0 Database Reference
tReinsurance Table
| AIRReinsurance Database : tReinsurance Table |
Stores information about reinsurance treaties.
A reinsurance program includes one or more related reinsurance treaties or layers. Reinsurance coverage applies to locations or treaties and not to reinsurance programs.
| Creation Date | 5/19/2020 4:05 AM |
| File Group | PRIMARY |
| Text File Group | PRIMARY |
| System Object |  |
| Published for Replication | |
| Rows | 9 |
| Data Space Used | 8.00 KB |
| Index Space Used | 40.00 KB |
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
 | ReinsuranceSID | Unique system-generated sequential identifier for the reinsurance treaty record. | int | 4 | |||
| ProgramSID | Unique system-generated sequential identifier for the reinsurance program record. For a complete list of records, see tProgram Table. | int | 4 | ||||
| ReinsuranceTypeCode | Code that represents the type of reinsurance. For a complete list of codes, see tReinsuranceType Table. | varchar | 10 | ||||
| ReinsuranceID | User-defined identifier for the reinsurance treaty. | varchar | 100 | ||||
| SubmitStatusCode | Code for the submission status. For a complete list of codes, see tSubmitStatus Table. | varchar | 10 | ||||
| PerilSetCode | Numeric code for the single peril or set of perils. For a complete list of codes, see tPerilSet Table. | int | 4 | ||||
| TriggerTypeCode | Code that represents when/how treaty coverage is applied. For a complete list of codes, see tTriggerType Table. | varchar | 10 | ||||
| ReinsTargetTypeCode | Code that represents the objects to which the reinsurance treaty is applied. For a complete list of codes, see tReinsTargetType Table. | varchar | 10 | ||||
| PreferredExposureTypeCode | Reserved for future use. Code that represents the preferred exposure type. For a complete list of codes, see tPreferredExposureType Table. | varchar | 10 |  | |||
| CedantName | Name of the primary insurer, which is the insurance company that purchases reinsurance. | varchar | 60 | | |||
| ReinsurerName | Name of the insurer or reinsurer who assumes the cedant’s risk under the contract (treaty). | varchar | 60 | | |||
| InceptionDate | Inception date of the reinsurance treaty. Also referred to as the Effective FROM Date. | date | 10 | ||||
| ExpirationDate | Reinsurance treaty expiration date. Also referred to as the Effective TO Date. | date | 10 | ||||
| CurrencyCode | ISO 3-character code for the currency. For a complete list of codes, see tCurrency Table. | char | 3 | ||||
| RiskLimit | Treaty limit for a single risk or layer. | float | 9 | | |||
| RiskRetention | Treaty retention per single risk, or per layer for policies including layers. | float | 9 | | |||
| OccurrenceLimit | Maximum loss that the treaty can occur from each occurrence. | float | 9 | | |||
| OccurrenceRetention | Deductible amount 1. The treaty does not assume losses below the specified value. | float | 9 | | |||
| AggregateLimit | Maximum amount payable under reinsurance treaty that provides overall maximum 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 amount expressed as an amount of percentage. Note that this value is provided on the user interface as a whole number percentage (e.g. 30.00) but is stored in the database as a decimal (e.g. 0.3). | float | 9 | ||||
| PlacedAmount | Placed percentage. | float | 9 | | |||
| IndustryLossMinimum | Minimum amount of industry loss. | float | 9 | | |||
| IndustryLossMaximum | Maximum amount of industry loss. | float | 9 | | |||
| PortfolioLossMinimum | Minimum amount of portfolio loss. | float | 9 | | |||
| PortfolioLossMaximum | Maximum amount of portfolio loss. | float | 9 | | |||
| CoinsuranceAmount | Amount of co-insurance. | float | 9 | ||||
| PremiumMinimum | The minimum premium paid for coverage of the layer per reinstatement. This value is not used during analysis. | float | 9 | | |||
| PremiumEstimated | The estimated premium paid for coverage of the layer per reinstatement. This value is used when the analysis calculates premiums net-of-estimated losses. | float | 9 | | |||
| LossesPaid | User-provided information regarding losses paid on the account. This value is not used during analysis. | float | 9 | | |||
| ParticipationNet | Net participation amount or percent. | real | 4 | | |||
| ParticipationGross | Gross participation amount or percent. | real | 4 | | |||
| LossModificationFactor | User-defined factor used to modify losses. | real | 4 | | |||
| StartingEventNumber | Event number at which the 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. | tinyint | 1 | | |||
| ReinstProvisionalAmount | Handling of reinstatement premium payments based on loss amount (100%, 75%, 50%, or Pro-Rata). The value 100% specifies that the total premium amount (Estimated Premium) 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 (100%, 75%, 50%, or Pro-Rata). The value 100% specifies that the total premium amount (Estimated Premium) is paid for the reinstatement adjusted only for Reinstatement Provisions by Amount. 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 | | |||
| IsMatchLossToLimit | Indicates whether the loss is matched to limits.
| bit | 1 | | |||
| ReinsAppliesToULOB | User's Lines of Business filter. | varchar | 16 | | |||
| ReinsAppliesToEvent | XML string that defines the event filter for the treaty. | Xml | 16 | | |||
| InuringSequenceNumber | Inuring order for the reinsurance treaty. | smallint | 2 | | |||
| Description | Description of the reinsurance treaty. | varchar | 4000 | | |||
| EnteredDate | Date and time when the reinsurance treaty was created. | datetime | 4 | (getutcdate()) | |||
| EditedDate | Date and time when the reinsurance treaty was last modified. | datetime | 4 | (getutcdate()) | |||
| RiskAggregateLimit | Risk aggregate limit amount for a single reinstatement. | float | 9 | | |||
| RiskAggregateRetention | Risk aggregate retention amount for a single reinstatement. | float | 9 | | |||
| RiskLimitReinstatement | Indicates whether the Risk Limit Reinstatement is applied to a reinsurance treaty. | tinyint | 1 | |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
 | tReinsAppliesToGeo | Table | Stores information about the geographic or area filter applied to each reinsurance treaty. Reinsurance treaty geographic filters are optional. | 1 |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
| tProgram | Table | Stores information about reinsurance programs. A reinsurance program includes one or more related reinsurance treaties or layers. Reinsurance coverage applies to locations or treaties and not to reinsurance programs. | 2 |