Touchstone 4.0 Database Documentation
tAIRLineOfBusiness Table
Description
Defines the AIR Line of Business types.
Properties
Creation Date2/16/2011 6:00 PM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows10
Data Space Used8.00 KB
Index Space Used8.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key 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)
VarChar10   
 LineOfBusinessCategory

Categorization for the Line of Business.

VarChar40   
 AIRLineOfBusiness

Name of the Line of Business.

Corresponds to the code in AIRFloodZoneCategoryCode.

VarChar40   
 Description

Name of the Line of Business.

Corresponds to the code in AIRFloodZoneCategoryCode.

VarChar1024  
 IsActive

Indicates whether the Line of Business is available for use.

  • 1 = Yes (available)
  • 0 = No (not available)
Boolean1dbo.D_1 
Check Constraints
NameDescriptionExpression
CKC_ISACTIVE_TAIRLINE 
([IsActive] IS NULL OR [IsActive]>=(0) AND [IsActive]<=(1))
Objects that depend on tAIRLineOfBusiness
 Database ObjectObject TypeDescriptionDep Level
tAIROccupancyRegionXref tabletAIROccupancyRegionXrefTable

System reference table that is used to group occupancy and region information.

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.