CEDE 8.0 Database Reference
tLocTerm Table
| AIRExposure Database : tLocTerm Table |
Stores information about location terms.
| 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 | |
|---|---|---|---|---|---|---|---|
 | 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. | 2 |
| tExposureSet | Table | Stores information about exposure sets. An exposure set is a collection of contracts, locations, and other related information. | 3 |
| 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 |