Touchstone 4.0 Database Documentation
tIndustryOccupancy Table
Description

Stores the possible the industry occupancy types.

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

Code that represents the industry occupancy types.

  • 1 = Single Family
  • 2 = Commercial Habitational
  • 3 = General Commercial
  • 4 = Retail trade
  • 5 = Wholesale trade
  • 6 = Personal and repair services
  • 7=  Professional, technical and business services
  • 8 = Health care services
  • 9 = Entertainment and recreation
  • 10 = Parking
  • 11 = Heavy fabrication and assembly
  • 12 = General Industrial
  • 13 = Light fabrication and assembly
  • 14 = Food and drug processing
  • 15 = Chemical processing
  • 16 = Metal and minerals processing
  • 17 = Construction
  • 18 = Petroleum
  • 19 = Mining
  • 20 = General Services
  • 21 = Universities, colleges and technical schools
  • 22 = Agriculture
  • 23 = Other
  • 24 = Occupancy Auto
  • 25 = Green House
  • 26 = Forestry
  • 27 = Apartments/Condos
SmallInt2   
 IndustryOccupancy

Name of the industry occupancy type.

Corresponds to the code in IndustryOccupancyCode.

VarChar60   
 Description

Description of the industry occupancy type.

VarChar1024  
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.