CEDE 9.0 Database Reference
tDeductibleType Table
AIRReference Database : tDeductibleType Table
Description

Stores codes that represent types of location, layer, and sublimit deductibles.

Properties
Creation Date11/3/2011 11:42 PM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows16
Data Space Used8.00 KB
Index Space Used8.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key 

Code that represents the location, layer, and sublimit deductible type

Location Deductibles:

  • AA = Florida Annual Amount
  • C = Deductible By Coverage
  • CB = Combined - Excluding Time
  • CT = Combined - Including Time
  • FR = Franchise Deductible
  • ML = Max of Deductible Amount or Percent Loss 
  • MP = Mini Policy Deductible
  • PL = Percent of Loss
  • S = Site Deductible
  • N = No Deductible        

Layer Deductibles: 

  • AP = Attachment Point
  • B = Blanket Deductible
  • FR = Franchise Deductible
  • MA = Maximum Deductible Amount
  • MI = Minimum Deductible Amount
  • MM = Minimum and Maximum
  • PL = Percent of Loss
  • N = No Deductible

Sublimit Deductibles:

  • MA = Maximum Deductible Amount
  • MI = Minimum Deductible Amount
  • MM = Minimum and Maximum
  • N = No Deductible
varchar10   
 

Name of the deductible type.

Corresponds to the code in DeductibleTypeCode.

varchar40   
 

Description of the deductible type.

varchar1024  
 

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.

varchar40  
 

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.

varchar40  
 

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.

varchar40  
 

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.

varchar40  
 

Indicates whether the deductible is a location deductible.

  • 1 = Yes (location deductible)
  • 0 = No (not a location deductible)
bit1 dbo.D_0 
 

Indicates whether the deductible is a layer deductible.

  • 1 = Yes (layer deductible)
  • 0 = No (not a layer deductible)
bit1 dbo.D_0 
 

Indicates whether the deductible is a sublimit deductible.

  • 1 = Yes (sublimit deductible)
  • 0 = No (not a sublimit deductible)
bit1 dbo.D_0 
See Also

Related Objects

AIRReference Database