Touchstone 4.0 Database Documentation
tCLFIndustryLOB Table
Description
Stores the Industry Line of Business data; its order in the CLF file is 1) country, 2) peril, and 3) INF version.
Properties
Creation Date3/5/2014 4:29 PM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows2823
Data Space Used112.00 KB
Index Space Used16.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key CountryCode

ISO 2-character code for the country. 

For a complete list of codes, see tCountry Table.

VarChar15   
Primary Key CTPerilSetCodeCATRADER code for the peril set.Integer4   
Primary Key INFVersionVersion of the INF file.UnsignedTinyInt1   
Primary Key IndustryLineOfBusinessCode

Code that represent the Industry's Line of Business.

For a complete list of codes, see tIndustryLineOfBusiness Table.

UnsignedTinyInt1   
 IndustryLOBOrderColumn order for the Industry Line of Business CLF file.UnsignedTinyInt1   
Objects that tCLFIndustryLOB depends on
 Database ObjectObject TypeDescriptionDep Level
tCountry tabletCountryTableStores information about the county in regards to whether it is modeled or an offshore location.1
tIndustryLineOfBusiness tabletIndustryLineOfBusinessTable

Stores the possible the industry Line of Business types.

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.