CEDE 7.0 Database Reference
tReinsAppliesToExp Table
| AIRExposure Database : tReinsAppliesToExp Table |
Stores information about facultative certificates and surplus share treaties that are applied to exposures such as locations, contracts, and layers.
| Creation Date | 6/19/2019 8:45 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 | |
|---|---|---|---|---|---|---|---|
 | 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 | ||||
| RowVersion | Used for version stamping. | timestamp | 8 |