tIndustryLineOfBusiness Table

CEDE 8.0 Database Reference

tIndustryLineOfBusiness Table

Collapse All

AIRReference Database : tIndustryLineOfBusiness Table

Description

Stores the possible the industry Line of Business types.

Properties

Creation Date	3/14/2011 11:10 AM
File Group	PRIMARY
Text File Group
System Object
Published for Replication
Rows	25
Data Space Used	8.00 KB
Index Space Used	8.00 KB

Columns

	Column Name	Description	Datatype	Length	Allow Nulls	Default	Formula
	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 25 = Residential Land	tinyint	1
	IndustryLineOfBusiness	Name of the industry Line of Business. Corresponds to the code in IndustryLineofBusinessCode.	varchar	40
	Description	Description of the industry Line of Business.	varchar	1024
	IsEnabled	Indicates whether the industry Line of Business is enabled for use. 1 = Yes (enabled) 0 = No (disabled)	bit	1		dbo.D_0

Objects that depend on tIndustryLineOfBusiness

	Database Object	Object Type	Description	Dep Level
	tCountryIndustryLOBXref	Table	System reference table used to map the Industry Line of Business to a county.	1

See Also

Related Objects

AIRReference Database