Stores information about location terms.
Stores information about location terms.
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 | |
---|---|---|---|---|---|---|---|
LocTermSID | Unique system-generated sequential identifier for the location term record. | int | 4 | ||||
LocationSID | Unique system-generated sequential identifier for the location record. For a complete list of records, see tLocation Table. | int | 4 | ||||
ContractSID | Unique system-generated sequential identifier for the contract record. For a complete list of records, see tContract Table. | int | 4 | ||||
PerilSetCode | Numeric code for the single peril or set of perils. For a complete list of codes, see tPerilSet Table. | int | 4 | ||||
LimitTypeCode | Code that represents the type of limit applied to the location. For a complete list of codes, see tLimitType Table. | varchar | 10 | ||||
Limit1 | Insured limit for the building (Coverage A). | float | 9 | ||||
Limit2 | Insured limit for the appurtenant structures (Coverage B). | float | 9 | ||||
Limit3 | Insured limit for the contents (Coverage C). Note that if limit type is EE, this field may contain values less than 1.0. | float | 9 | ||||
Limit4 | Insured limit for the time element (Coverage D). | float | 9 | ||||
DeductibleTypeCode | Code that represents the type of deductible applied to the location. For a complete list of codes, see tDeductibleType Table. | varchar | 10 | ||||
Deductible1 | Deductible amount applied to Coverage A (building). Any values that are less than or equal to 1 will be interpreted as percentages (e.g., 0.12 as 12%). | float | 9 | ||||
Deductible2 | Deductible amount applied to Coverage B (appurtenant structures). Any values that are less than or equal to 1 will be interpreted as percentages (e.g., 0.12 as 12%). | float | 9 | ||||
Deductible3 | Deductible amount applied to Coverage C (contents). Any values that are less than or equal to 1 will be interpreted as percentages (e.g., 0.12 as 12%). | float | 9 | ||||
Deductible4 | Deductible amount applied to the Coverage D (time element). 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 | ||||
Participation1 | Percentage of the location layer losses assumed by the contract. Any values that are less than or equal to 1 will be interpreted as percentages (e.g., 0.12 as 12%). | real | 4 | ||||
Participation2 | Second percentage of location layer losses assumed by the contract. Any values that are less than or equal to 1 will be interpreted as percentages (e.g., 0.12 as 12%). | real | 4 | ||||
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 | ||||
MinMaxDeductibleTypeCode | Code for the minimum maximum deductible type. | varchar | 10 | ||||
MinimumDeductible | Minimum deductible amount. | float | 9 | ||||
MaximumDeductible | Maximum deductible amount. | 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 | ||||
RowVersion | Used for version stamping. | timestamp | 8 |
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 | |
tLocation | Table | Stores geographical attributes and primary risk characteristics for each location. The table serves as a reference point between Location and Contract entities.You can identify each location by the location sequential identifier (SID). | 1 |