Touchstone 4.0 Database Documentation
tIndustryLineOfBusiness Table
Description

Stores the possible the industry Line of Business types.

Properties
Creation Date3/14/2011 11:10 AM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows24
Data Space Used8.00 KB
Index Space Used8.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key IndustryLineOfBusinessCode

Code that represents the industry Line of Business.

  • 1 = Residential Buildings
  • 2 = Commercial
  • 3 = Mobile Home
  • 4 = Auto
  • 5 = Residential
  • 6 = Commercial Building
  • 7 = Industrial
  • 8 = Agriculture
  • 9 = Greenhouse
  • 10 = Forestry
  • 11 = Residential Contents
  • 12 = Apartment Buildings
  • 13 = Commercial Contents
  • 14 = Agriculture - No Greenhouses
  • 15 = Business Interruption
  • 16 = CAR/EAR
  • 17 = Commercial & Industrial
  • 18 = Debris Removal
  • 19 = Operator Extra Expense
  • 20 = Physical Damage
  • 21 = Workers' Compensation
  • 22 = Residential Building & Contents
  • 23 = Commercial and Industrial Buildings
  • 24 = Commercial and Industrial Contents
UnsignedTinyInt1   
 IndustryLineOfBusiness

Name of the industry Line of Business.

Corresponds to the code in IndustryLineofBusinessCode.

VarChar40   
 Description

Description of the industry Line of Business.

VarChar1024  
 IsEnabled

Indicates whether the industry Line of Business is enabled for use.

  • 1 = Yes (enabled)
  • 0 = No (disabled)
Boolean1dbo.D_0 
Objects that depend on tIndustryLineOfBusiness
 Database ObjectObject TypeDescriptionDep Level
tCLFIndustryLOB tabletCLFIndustryLOBTableStores the Industry Line of Business data; its order in the CLF file is 1) country, 2) peril, and 3) INF version.1
tCountryIndustryLOBXref tabletCountryIndustryLOBXrefTableSystem reference table used to map the Industry Line of Business to a county.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.