Stores primary contract layer information.
Stores primary contract layer information.
Creation Date | 4/12/2021 11:26 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 | ||||
AttachmentPoint2 | Value of the second attachment point. | float | 9 | ||||
AttachmentPoint3 | Value of the third attachment point. | float | 9 | ||||
AttachmentPoint4 | Value of the fourth 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 | 0 | ||||
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.
Sublimits are generally applied to layers based on filter criteria, such as a list of locations or perils.
| 1 | |
tLayerConditionLocationXref | Table | System reference table used to map the location to the layer condition. | 2 |
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 |