CEDE 8.0 Database Reference
tLayerCondition Table
| AIRExposure Database : tLayerCondition Table |
Stores layer conditions, such as sublimit and policy restrictions.
 |
Sublimits are generally applied to layers based on filter criteria, such as a list of locations or perils. |
| Creation Date | 5/19/2020 4:04 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 | |
|---|---|---|---|---|---|---|---|
 | LayerConditionSID | Unique system-generated sequential identifier for the layer term record. | int | 4 | |||
| LayerSID | Unique system-generated sequential identifier for the layer record. For a complete list of records, see tLayer Table. | int | 4 | ||||
| ContractSID | Unique system-generated sequential identifier for the contract record. For a complete list of records, see tContract Table. | int | 4 | ||||
| LayerConditionTypeCode | Code for the layer condition type. For a complete list of codes, see tLayerConditionType 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 | ||||
| AppliesToTag | User-defined condition key. | varchar | 255 |  | |||
| OccLimitTypeCode | Code for the occurrence limit type. For a complete list of codes, see tOccLimitType Table. | varchar | 10 | ||||
| OccLimit1 | Limit 1 amount. | float | 9 | | |||
| OccLimit2 | Limit 2 amount. | float | 9 | | |||
| OccLimit3 | Limit 1 amount. | float | 9 | | |||
| OccLimit4 | Limit 2 amount. | float | 9 | | |||
| DeductibleTypeCode | Code for the layer deductible type. For a complete list of codes, see tDeductibleType Table. | varchar | 10 | ||||
| Deductible1 | Deductible 1 amount. | float | 9 | | |||
| Deductible2 | Deductible 2 amount. | float | 9 | | |||
| Attachment1 | Attachment point 1 amount. | float | 9 | | |||
| Attachment2 | Attachment point 2 amount. | float | 9 | | |||
| Attachment3 | Attachment point 3 amount. | float | 9 | | |||
| Attachment4 | Attachment point 4 amount. | float | 9 | | |||
| InuringSequenceNumber | Layer sequence order. | smallint | 2 | | |||
| ParentLayerConditionSID | Unique system-generated sequential identifier for the layer condition for the parent record. | int | 4 | | |||
| Deductible3 | Deductible 3 amount. | float | 9 | | |||
| Deductible4 | Deductible 4 amount. | float | 9 | | |||
| AggregateLimitTypeCode | Code for the aggregate limit. | varchar | 10 | | |||
| AggregateLimit | Aggregate limit amount. | float | 9 | | |||
| AggregateAttachmentPoint | Aggregate attachment point amount. | float | 9 | | |||
| AggregateDeductibleTypeCode | Code for the aggregate deductible type. | varchar | 10 | | |||
| AggregateDeductible | Aggregate deductible amount. | float | 9 | | |||
| LayerConditionName | Stores the name of layer condition. | varchar | 255 | | |||
| LayerConditionTier | Stores the tier details of layer condition. | smallint | 2 | | |||
| RowVersion | Used for version stamping. | timestamp | 8 |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
 | 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 |
| tLayer | Table | Stores primary contract layer information. | 2 |