Touchstone 2022 Database Reference
tConvertCL2ConditionDeductibleType Table
AIRReference Database : tConvertCL2ConditionDeductibleType Table
Description

Stores information about the deductible types used in CLASIC/2.

Touchstone uses the information to convert CLASIC/2 deductible types to Touchstone deductible types.

Properties
Creation Date9/1/2011 2:17 PM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows42
Data Space Used8.00 KB
Index Space Used8.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key 

Code that represent the CLASIC/2 contract (condition) type to which the deductible was applied.

  • 10 = Blanket Layer
  • 20 = Sublimit
  • 30 = Excess Layer
varchar10   
Primary Key 

Code that represents the CLASIC/2 deductible type.

  • 0 = Unknown / undefined deductible (X)
  • 1 = No deductible (NO)
  • 2 = Attachment Point (AP)
  • 3 = Minimum and Maximum (MM)
  • 4 = Minimum Deductible Amount (MI)
  • 5 = Maximum Deductible Amount (MA)
  • 6 = Blanket Percent of Loss (PL)
  • 7 = Blanket Deductible (BL)
  • 8 = Franchise Deductible (FR)
  • 9 = Minimum and Maximum 2 (MM2)
  • 1 =0 Minimum Deductible Amount 2 (MI2)
  • 11 = Maximum Deductible Amount 2 (MA2)
varchar10   
 

Name for the CLASIC/2 deductible type.

Corresponds to the code in OldDeductibleTypeCode.

varchar40   
 

Code for the deductible type as used in a UPX record.

Corresponds to the code in OldDeductibleTypeCode.

varchar10  
 Touchstone database table where this deductible type is saved.sysname128  
 

Name of the column in the Touchstone database table where this deductible type is saved.

sysname128  
 

Code that represents the deductible type in Touchstone.

For a complete list of codes, see tDeductibleType Table.

varchar10  
 Description if the deductible type.varchar1024  
See Also

Related Objects

AIRReference Database