Touchstone 4.0 Database Documentation
tDeductibleType Table
Description

Stores the possible location, layer, and sublimit deductibles types.

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

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   
 DeductibleType

Name of the deductible type.

Corresponds to the code in DeductibleTypeCode.

VarChar40   
 Description

Description of the deductible type.

VarChar1024  
 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.

VarChar40  
 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.

VarChar40  
 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.

VarChar40  
 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.

VarChar40  
 ValidForLocation

Indicates whether the deductible is a location deductible.

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

Indicates whether the deductible is a layer deductible.

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

Indicates whether the deductible is a sublimit deductible.

  • 1 = Yes (sublimit deductible)
  • 0 = No (not a sublimit deductible)
Boolean1 dbo.D_0 
Check Constraints
NameDescriptionExpression
CKC_VALIDFORLAYER_TDEDUCTI 
([ValidForLayer]>=(0) AND [ValidForLayer]<=(1))
CKC_VALIDFORLOCATION_TDEDUCTI 
([ValidForLocation]>=(0) AND [ValidForLocation]<=(1))
CKC_VALIDFORSUBLIMIT_TDEDUCTI 
([ValidForSublimit]>=(0) AND [ValidForSublimit]<=(1))
See Also

Related Objects

AIRReference Database

 

 


AIR Client Confidential

© 2016. AIR Worldwide is a registered trademark. Touchstone is a registered trademark of AIR Worldwide.

Please contact AIR Worldwide with questions or comments. For database questions. For documentation comments.