Touchstone 4.0 Database Documentation
tConvertCL2ConditionDeductibleType Table
Description

Stores information regarding the deductible types used in CLASIC/2. This information is used 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
Rows36
Data Space Used8.00 KB
Index Space Used8.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key OldConditionTypeCode

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 OldDeductibleTypeCode

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   
 OldDeductibleType

Name for the CLASIC/2 deductible type.

Corresponds to the code in OldDeductibleTypeCode.

VarChar40   
 UPXDeductibleType

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

Corresponds to the code in OldDeductibleTypeCode.

VarChar10  
 NewTableTouchstone database table where this deductible type is saved.VarWChar128  
 NewColumn

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

VarWChar128  
 NewCode

Code that represents the deductible type in Touchstone.

For a complete list of codes, see tDeductibleType Table.

VarChar10  
 DescriptionDescription if the deductible type.VarChar1024  
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.