Touchstone 4.0 Database Documentation
tConvertCL2ConditionLimitType Table
Description

Stores information regarding the limit types used in CLASIC/2. This information is used to convert CLASIC/2 limit types to Touchstone limit types.

Properties
Creation Date9/1/2011 2:17 PM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows30
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  
 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.

VarWChar128  
 NewColumn

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

VarWChar128  
 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)
Boolean1 dbo.D_1 
Check Constraints
NameDescriptionExpression
CKC_ISDEFAULT_TConditionLimit 
([IsDefault]>=(0) AND [IsDefault]<=(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.