Stores codes that represent types of location, layer, and sublimit deductibles.
Stores codes that represent types of location, layer, and sublimit deductibles.
| Creation Date | 11/3/2011 11:42 PM |
| File Group | PRIMARY |
| Text File Group | |
| System Object | ![]() |
| Published for Replication | ![]() |
| Rows | 16 |
| Data Space Used | 8.00 KB |
| Index Space Used | 8.00 KB |
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
| DeductibleTypeCode | Code that represents the location, layer, and sublimit deductible type Location Deductibles:
Layer Deductibles:
Sublimit Deductibles:
| varchar | 10 | |||
| DeductibleType | Name of the deductible type. Corresponds to the code in DeductibleTypeCode. | varchar | 40 | ||||
| Description | Description of the deductible type. | varchar | 1024 | ![]() | |||
| Deductible1Label | Identifies how the Deducible 1 value is applied during the analysis. For example, when the deducible type is Combined – Including Time, the value for Deducible 1 applies to Deductible A. Note that Deductible 1 is referred to as Deductible A on the user interface. | varchar | 40 | ![]() | |||
| Deductible2Label | Identifies how the Deducible 2 value is applied during the analysis. For example, when the deducible type is Combined – Including Time, the value for Deducible 2 applies to Deductible B. Note that Deductible 2 is referred to as Deductible B on the user interface. | varchar | 40 | ![]() | |||
| Deductible3Label | Identifies how the Deducible 3 value is applied during the analysis. For example, when the deducible type is Combined – Including Time, the value for Deducible 3 applies to Deductible C. Note that Deductible 3 is referred to as Deductible C on the user interface. | varchar | 40 | ![]() | |||
| Deductible4Label | Identifies how the Deducible 4 value is applied during the analysis. For example, when the deducible type is Combined – Including Time, the value for Deducible 4 applies to Deductible D. Note that Deductible 4 is referred to as Deductible D on the user interface. | varchar | 40 | ![]() | |||
| ValidForLocation | Indicates whether the deductible is a location deductible.
| bit | 1 | dbo.d_0 | |||
| ValidForLayer | Indicates whether the deductible is a layer deductible.
| bit | 1 | dbo.d_0 | |||
| ValidForSublimit | Indicates whether the deductible is a sublimit deductible.
| bit | 1 | dbo.d_0 |