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

Stores the industry line of business data by country used by Touchstone to generate company loss files (CLFs).

Industry LOB data appears in a CLF in the following order: country, peril, and INF version.

Properties
Creation Date3/5/2014 4:29 PM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows3498
Data Space Used104.00 KB
Index Space Used16.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key 

ISO 2-character code for the country. 

For a complete list of codes, see tCountry Table.

varchar15   
Primary Key CATRADER code for the peril set.int4   
Primary Key Version of the INF file.tinyint1   
Primary Key 

Code that represent the industry line of business.

For a complete list of codes, see tIndustryLineOfBusiness Table.

tinyint1   
 Column order for the industry line of business CLF file.tinyint1   
Primary Key 

Indicates whether the industry line of business corresponds to the current or previous version of the AIR models.

  • 1 = Yes (previous version)
  • 0 = No (current version) 
bit1 
((0))
 
Objects that tCLFIndustryLOB depends on
 Database ObjectObject TypeDescriptionDep Level
tCountry tabletCountryTableStores the supported country codes and indicates whether each country is modeled and an offshore location.1
tIndustryLineOfBusiness tabletIndustryLineOfBusinessTable

Stores the possible the industry Line of Business types.

1
See Also

Related Objects

AIRReference Database