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 |