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

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

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

Properties
Creation Date2/25/2011 4:19 PM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows17
Data Space Used8.00 KB
Index Space Used8.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key OldContractType

Code that represent the CLASIC/2 contract type.  

  • 10 =  PP (Primary policy for single record)
  • 20 = PP (Primary policy for multiple locations)
  • 30 = PP (Primary policy for excess)
  • 40 = N/A   
  • 50 = PWC (Primary contract record)
  • 100 = FAC (Reinsurance proportional facultative certificate)
  • 110 = FP (Primary facultative certificate)
  • 110 = FAC (Reinsurance non-proportional facultative certificate)
  • 120 = FWC (Facultative Treaty Workers’ Compensation)
  • 150 = QS (Quota Share + Losses occurring during)
  • 151 = QS (Quota Share + Risks attaching)
  • 160 = SS (Surplus Share + Losses occurring during)
  • 161 = SS (Surplus Share + Risks attaching)
  • 170 = XPR (Per-Risk Treaty + Losses occurring during)
  • 171 = XPR (Per-Risk Treaty + Risks attaching)
  • 180 = CATXOL (Catastrophe Excess of Loss + Losses occurring during)
  • 181 = CATXOL (Catastrophe Excess of Loss + Risks attaching)        
tinyint1   
Primary Key NewTable

Touchstone database table where the contract type is saved.

sysname128   
 ContractTypeCode

Code that represent the contract type.

Corresponds to the code in OldContractType.

varchar10  
 DescriptionDescription of the contract type.varchar1024  
 IsDefault

Indicates whether the contract type is available as a default.

  • 1 = Yes (default)
  • 0 = No (not default)
bit1dbo.D_1 
 TriggerTypeCode

Used for reinsurance contracts types, this column identifies the trigger that initiates the contract.

For a complete list of codes, see tTriggerType Table. 

varchar10  
Check Constraints
NameDescriptionExpression
CK__tConvertC__IsDef__61DB776A 
([IsDefault] IS NULL OR [IsDefault]>=(0) AND [IsDefault]<=(1))
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.