Touchstone 4.0 Database Documentation
tConvertCL2ContractType Table

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

Creation Date2/25/2011 4:19 PM
Text File Group
System Object
Published for Replication
Data Space Used8.00 KB
Index Space Used8.00 KB
 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)        
Primary Key NewTable

Touchstone database table where the contract type is saved.


Code that represent the contract type.

Corresponds to the code in OldContractType.

 DescriptionDescription of the contract type.VarChar1024  

Indicates whether the contract type is available as a default.

  • 1 = Yes (default)
  • 0 = No (not default)

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

For a complete list of codes, see tTriggerType Table

Check Constraints
([IsDefault] IS NULL OR [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.