Touchstone 2022 Database Reference
tCLFINFVersion Table
AIRReference Database : tCLFINFVersion Table
Description
Stores information that Touchstone uses to define the INF version during a company loss file export.
Properties
Creation Date3/5/2014 4:29 PM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows119
Data Space Used8.00 KB
Index Space Used8.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key CatalogTypeCode

Code that represents the catalog type.

For a complete list of codes, see tCatalogType Table.

varchar10   
Primary Key CatalogSizeYearMax value in the catalog.int4   
Primary Key ModelCode

Code that represents the model as presented in Touchstone.

For a complete list of codes, see tModel Table.

smallint2   
Primary Key INFVersionVersion of the INF file.tinyint1   
 IndustryLOBCountTotal number of Industry Line of Business codes for a model/catalog/INFVersion combination.tinyint1   
Primary Key IsPreviousVersionModel

Indicates whether the INF file corresponds to the current or previous  version of the AIR models.

  • 1 = Yes (previous version)
  • 0 = No (current version) 
bit1 
((0))
 
Objects that tCLFINFVersion depends on
 Database ObjectObject TypeDescriptionDep Level
tCatalogType tabletCatalogTypeTable

Stores the possible catalogs that can be used during a Loss analysis.

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.