Touchstone 2022 Database Reference
tAIRConstOccRegion Table
AIRReference Database : tAIRConstOccRegion Table
Description
Stores codes that represent geographic regions.
Properties
Creation Date10/24/2013 3:05 PM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows15
Data Space Used8.00 KB
Index Space Used8.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key 

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
  • KR = Korea
  • MEX = Mexico
  • NZ = New Zealand
  • SA = South America
  • SEA = South East Asia
  • US = United States
varchar10   
 

Name of the region.

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

System reference table that stores the AIR construction class codes supported for each geographic region.

1
tAIRConstOccRegionCountryXref tabletAIRConstOccRegionCountryXrefTable

System reference table that stores the countries supported for each region.

1
tAIRConstOccRegionOccXref tabletAIRConstOccRegionOccXrefTableSystem reference table that stores the AIR occupancy class codes supported for each region.1
tAIROccConSpecial tabletAIROccConSpecialTableStores special AIR construction and occupancy class codes for each region.1
See Also

Related Objects

AIRReference Database