CEDE 8.0 Database Reference
tLayer Table
| AIRExposure Database : tLayer Table |
Stores primary contract layer information.
| Creation Date | 5/19/2020 4:04 AM |
| File Group | PRIMARY |
| Text File Group | PRIMARY |
| 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 | |
|---|---|---|---|---|---|---|---|
 | LayerSID | Unique system-generated sequential identifier for the layer record. | int | 4 | |||
| ContractSID | Unique system-generated sequential identifier for the contract record. For a complete list of records, see tContract Table. | int | 4 | ||||
| LayerID | Unique user-defined identifier for the layer. | varchar | 100 | ||||
| PerilSetCode | Numeric code for the single peril or set of perils. For a complete list of codes, see tPerilSet Table. | int | 4 | ||||
| OccLimitTypeCode | Code for the occurrence limit type. For a complete list of codes, see tOccLimitType Table. | varchar | 10 | ||||
| OccTotalLimit | Occurence limit amount, used for facultative reinsurance treaties and primary insurance contracts. This column contains the user interface value provided in the 100% Layer Amount field on the Contracts tab. | float | 9 | ||||
| OccParticipation | Occurrence participation, used for facultative reinsurance treaties and primary insurance contracts. This column contains the user interface value provided in the Participating Layer Amount field on the Contracts tab. Note: In the database this value is stored as a percentage of the total limit; on the user interface it is presented using the same format as was imported. | float | 9 | ||||
| OccTotalParticipation | 100% participation amount, used for facultative reinsurance treaties and primary insurance contracts. This column contains the user interface value provided in the Assumed Amount field on the Contracts tab. Note: Any values that are less than or equal to 1 will be interpreted as percentages (e.g., 0.12 as 12%). | float | 9 |  | |||
| Limit3 | Limit 3 amount for by-coverage sublimits. Any value less than or equal to 1 will be intepreted as percentages (eg., 0.12 as 12%). | float | 9 | | |||
| Limit4 | Limit 4 amount for by-coverage and combined coverage sublimits. Any value less than or equal to 1 will be intepreted as percentages (eg., 0.12 as 12%). | float | 9 | | |||
| AttachmentPoint | Value of the attachment point. | float | 9 | | |||
| DeductibleTypeCode | Code for the layer deductible type, options. For a complete list of codes, see tDeductibleType Table. | varchar | 10 | ||||
| Deductible1 | Deductible 1 amount. Any value less than or equal to 1 will be changed to 0. | float | 9 | | |||
| Deductible2 | Deductible 2 amount. For example, the maximum deductible for deductible min/max. Any value less than or equal to 1 will be changed to 0. | float | 9 | | |||
| Premium | Premium amount. Any value less than or equal to 1 will be interpreted as percentages (e.g., 0.12 as 12%). | float | 9 | | |||
| ExhaustionSequence | Priority assignments for coverages, listed in the order in which losses by coverage should be applied against the limit. | Xml | 16 | | |||
| Deductible3 | Deductible 3 amount. Any value less than or equal to 1 will be interpreted as percentages (eg., 0.12 as 12%). | float | 9 | | |||
| Deductible4 | Deductible 4 amount. Any value less than or equal to 1 will be interpreted as percentages (eg., 0.12 as 12%). | float | 9 | | |||
| AggregateLimitTypeCode | Code that represents the aggregate limit type. | varchar | 10 | | |||
| AggregateLimit | Maximum amount payable under contract layer that provides overall maximum loss limitation. | float | 9 | | |||
| AggregateAttachmentPoint | Aggregate amount of all the attachment points under contract layer. Any value less than or equal to 1 will be interpreted as percentages (eg., 0.12 as 12%). | float | 9 | | |||
| AggregateDeductibleTypeCode | Code for the aggregate deductible type. | varchar | 10 | | |||
| AggregateDeductible | Maximum deductible amount payable under aggregate deductible limit. Any value less than or equal to 1 will be interpreted as percentages (eg., 0.12 as 12%). | float | 9 | | |||
| EnteredDate | Date and time when the contract was created. | datetime | 4 | (getutcdate()) | |||
| EditedDate | Date and time when the contract was modified. | datetime | 4 | (getutcdate()) | |||
| RowVersion | Used for version stamping. | timestamp | 8 |
| Database Object | Object Type | Description | Dep Level | |||
|---|---|---|---|---|---|---|
 | tLayerCondition | Table | Stores layer conditions, such as sublimit and policy restrictions.
| 1 | ||
| tLayerConditionLocationXref | Table | System reference table used to map the location to the layer condition. | 1 |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
| tContract | Table | Stores records for primary insurance policies. | 2 |
| tExposureSet | Table | Stores information about exposure sets. An exposure set is a collection of contracts, locations, and other related information. | 3 |
