tAIRLineOfBusiness Table

Touchstone 2022 Database Reference

tAIRLineOfBusiness Table

Collapse All

AIRReference Database : tAIRLineOfBusiness Table

Description

Defines the AIR Line of Business types.

Properties

Creation Date	2/16/2011 6:00 PM
File Group	PRIMARY
Text File Group
System Object
Published for Replication
Rows	10
Data Space Used	8.00 KB
Index Space Used	8.00 KB

Columns

	Column Name	Description	Datatype	Length	Allow Nulls	Default	Formula
	AIRLineOfBusinessCode	Code that represents the Line of Business. AUT = Auto CAI = Commercial and Industrial COM = Commercial COND = Condo (apartment building) MOB = Mobile Home RB = Residential Buildings RC = Residential Contents RENT = Renters (apartment contents) SFH = Single Family Home TEN = Tenant (commercial contents)	varchar	10
	LineOfBusinessCategory	Categorization for the Line of Business.	varchar	40
	AIRLineOfBusiness	Name of the Line of Business. Corresponds to the code in AIRFloodZoneCategoryCode.	varchar	40
	Description	Name of the Line of Business. Corresponds to the code in AIRFloodZoneCategoryCode.	varchar	1024
	IsActive	Indicates whether the Line of Business is available for use. 1 = Yes (available) 0 = No (not available)	bit	1		dbo.D_1

Check Constraints

Name	Description	Expression
CKC_ISACTIVE_TAIRLINE		([IsActive] IS NULL OR [IsActive]>=(0) AND [IsActive]<=(1))

Objects that depend on tAIRLineOfBusiness

	Database Object	Object Type	Description	Dep Level
	tAIROccupancyRegionXref	Table	System reference table that stores the geography and line of business associated with each AIR occupancy class code.	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.