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

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

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

Properties
Creation Date1/13/2021 2:15 PM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows33
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 limit was applied.   

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

Code that represents the CLASIC/2 limit type.

  • 0 = Unknown/ undefined (X)
  • 1 = No limit (X)
  • 2 =Blanket Limit (B)
  • 3 = Excess Limit (E)
  • 4 = Limit by Coverage (C)
  • 5 = Combined with Time Separate (CB)
  • 6 = Combined Single Limit 100% participation (CSL100)
  • 7 = Combined Single Limit Assured Interest (CSLAI)
  • 8 = Limit by Coverage 100% Participation (C100)
  • 9 = Limit by Coverage with Assured Interest (CAI)
varchar10   
 OldLimitType

Name for the CLASIC/2 limit type.

Corresponds to the code in OldLimitTypeCode.

varchar40  
Primary Key UPXLimitType

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

Corresponds to the code in OldLimitTypeCode.

varchar10   
 NewTable

Touchstone database table where this limit type is saved.

sysname128  
 NewColumn

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

sysname128  
 NewCode

Code that represents the limit type in Touchstone.

For a complete list of codes, see tLimitType Table.

varchar10  
 DescriptionDescription of the limit type.varchar1024  
 IsDefault

Indicates whether the limit type is available as a default.

  • 1 = Yes (default)
  • 0 = No (not default)
bit1   
See Also

Related Objects

AIRReference Database

 

 

Verisk Analytics Client Confidential

© 2022. AIR Worldwide is now Extreme Event Solutions. AIR Worldwide is a registered trademark. Touchstone is a registered trademark of AIR Worldwide.

Please contact Verisk Analytics with questions or comments.