Touchstone 2022 Database Reference
tAIROccConSpecial Table
AIRReference Database : tAIROccConSpecial Table
Description
Stores special AIR construction and occupancy class codes for each region.
Properties
Creation Date10/24/2013 6:03 PM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows13
Data Space Used8.00 KB
Index Space Used8.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key 

Code that represents the region.

For a complete list of codes, see tAIRConstOccRegion Table.

varchar10   
Primary Key 

ISO 2-character code for the country. 

For a complete list of codes, see tCountry Table.

varchar15   
Primary Key 

Identifies the type of class code.

For a complete list of codes, see tAIROccConSpecial Table.

varchar10   
Primary Key 

Construction class or occupancy class code.

Depending on the entry provided in TypeCode,

smallint2   
Objects that tAIROccConSpecial depends on
 Database ObjectObject TypeDescriptionDep Level
tAIRConstOccRegion tabletAIRConstOccRegionTableStores codes that represent geographic regions.1
tAIROccConSpecialType tabletAIROccConSpecialTypeTableStores the definitions of the terms CON and OCC used in tAIROccConSpecial Table.1
tCountry tabletCountryTableStores the supported country codes and indicates whether each country is modeled and an offshore location.1
See Also

Related Objects

AIRReference Database