Stores information about facultative certificates and surplus share treaties that are applied to exposures such as locations, contracts, and layers.
CEDE 9.0 Database Reference
tReinsAppliesToExp Table
Stores information about facultative certificates and surplus share treaties that are applied to exposures such as locations, contracts, and layers.
| Creation Date | 4/12/2021 11:26 AM |
| 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 | |
|---|---|---|---|---|---|---|---|
 | ReinsAppliesToExpSID | Unique system-generated sequential identifier for the exposure to which the reinsurance applies record. | int | 4 | |||
| ExposureSetSID | Unique system-generated sequential identifier for the exposure set record. For a complete list of records, see tExposureSet Table. | int | 4 | ||||
| ReinsuranceID | Unique user-defined identifier for the reinsurance treaty. | varchar | 100 | ||||
| ReinsuranceTypeCode | Code that represents they type of reinsurance. For a complete list of codes, see tReinsuranceType 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 | ||||
| CedantName | Name of the cedant. | varchar | 60 |  | |||
| ReinsurerName | Name of the reinsurer. | varchar | 60 | | |||
| ReinsTargetTypeCode | Code that indicates the type of exposure to which the reinsurance treaty applies. For a complete list of codes, see tReinsTargetType Table. | varchar | 10 | ||||
| ReinsTargetSID | Unique system-generated sequential identifier for the reinsurance target record. | int | 4 | ||||
| AttachmentPoint | Value of the attachment point. Any values that are less than or equal to 1 will be interpreted as percentages (e.g., 0.12 as 12%). | float | 9 | ||||
| GrossLimit | Gross limit. Any values that are less than or equal to 1 will be interpreted as percentages (e.g., 0.12 as 12%). | 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 | ||||
| CurrencyCode | ISO 3-character code for the currency. For a complete list of codes, see tCurrency Table. | char | 3 | ||||
| RiskAggregateRetention | Risk aggregate retention expressed as an amount is the aggregate of risk retained within layer, contract, or location after which losses are not covered by the layer. Any values that are than or equal to 1 will be interpreted as percentages (e.g., 0.12 as 12%). | float | 9 | | |||
| RiskAggregateLimit | Maximum amount payable under the reinsurance program that provides overall loss limitation. Any values that are than or equal to 1 will be interpreted as percentages (e.g., 0.12 as 12%). | float | 9 | | |||
| RiskLimitReinstatement | 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. | int | 4 | | |||
| RowVersion | Used for version stamping. | timestamp | 8 |