Touchstone 4.0 Database Documentation
tAIRConstOccRegion Table
Description
A reference table used to determine the construction and occupancy class types that are associated with a region.
Properties
Creation Date10/24/2013 3:05 PM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows14
Data Space Used8.00 KB
Index Space Used8.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key AIRConstOccRegionCode

Code that represents the region.

  • AUS = Australia
  • CA = Central America
  • CAN = Canada
  • CAR = Caribbean
  • CH = China
  • EU = Europe
  • GOM = Gulf Of Mexico
  • IND = India
  • JAP =Japan
  • MEX = Mexico
  • NZ = New Zealand
  • SA = South America
  • SEA = South East Asia
  • US = United States
VarChar10   
 AIRConstOccRegion

Name of the activity type.

Corresponds to the code in AIRConstOccRegionCode.

VarChar255   
Objects that depend on tAIRConstOccRegion
 Database ObjectObject TypeDescriptionDep Level
tAIRConstOccRegionConstXref tabletAIRConstOccRegionConstXrefTable

System reference table used to determine the geographic region associated with a specific AIR construction class.

1
tAIRConstOccRegionCountryXref tabletAIRConstOccRegionCountryXrefTable

System reference table used to determine the construction and occupancy class types that are associated with a region and country.

1
tAIRConstOccRegionOccXref tabletAIRConstOccRegionOccXrefTableSystem reference table used to determine the geographic region associated with a specific AIR occupancy class.1
tAIROccConSpecial tabletAIROccConSpecialTableUsed to map Construction Occupancy Region codes to AIR Occupancy and Construction codes.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.