Stores layer conditions, such as sublimit and policy restrictions.
Stores layer conditions, such as sublimit and policy restrictions.
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 | |
---|---|---|---|---|---|---|---|
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. | 1 | |
tExposureSet | Table | Stores information about exposure sets. An exposure set is a collection of contracts, locations, and other related information. | 2 | |
tLayer | Table | Stores primary contract layer information. | 1 |