Stores special AIR construction and occupancy class codes for each region.
| Creation Date | 10/24/2013 6:03 PM |
| File Group | PRIMARY |
| Text File Group | |
| System Object | ![]() |
| Published for Replication | ![]() |
| Rows | 13 |
| Data Space Used | 8.00 KB |
| Index Space Used | 8.00 KB |
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
| AIRConstOccRegionCode | Code that represents the region. For a complete list of codes, see tAIRConstOccRegion Table. | varchar | 10 | |||
| CountryCode | ISO 2-character code for the country. For a complete list of codes, see tCountry Table. | varchar | 15 | |||
| TypeCode | Identifies the type of class code. For a complete list of codes, see tAIROccConSpecial Table. | varchar | 10 | |||
| Code | Construction class or occupancy class code. Depending on the entry provided in TypeCode,
| smallint | 2 |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
![]() | tAIRConstOccRegion | Table | Stores codes that represent geographic regions. | 1 |
![]() | tAIROccConSpecialType | Table | Stores the definitions of the terms CON and OCC used in tAIROccConSpecial Table. | 1 |
![]() | tCountry | Table | Stores the supported country codes and indicates whether each country is modeled and an offshore location. | 1 |