CEDE 9.0 Database Reference
tAIRConstruction Table
AIRReference Database : tAIRConstruction Table
Description
Stores information about AIR construction class codes.
Properties
Creation Date4/12/2012 4:41 PM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows219
Data Space Used40.00 KB
Index Space Used16.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key 

Code that represents the AIR construction class.

  • 100 = Unknown
  • 101 = Wood, Wood frame
  • 102 = Wood, Light wood frame
  • 103 = Wood, Masonry veneer
  • 104 = Wood, Heavy timber
  • 105  = Wood, Okabe
  • 106 = Wood, Shinkabe
  • 107 = Wood, Lightweight Cladding
  • 108 = Wood, Hawaii indigenous material
  • 111 = Masonry, Masonry
  • 112 = Masonry, Adobe
  • 113 = Masonry, Rubble stone masonry
  • 114 = Masonry, Un-reinforced masonry bearing wall
  • 115 = Masonry, Un-reinforced masonry bearing frame
  • 116 = Masonry, Reinforced masonry
  • 117 = Masonry, Reinforced masonry shear wall with mrf
  • 118  = Masonry, Reinforced masonry shear wall w/o mrf
  • 119 = Masonry, Joisted masonry
  • 120 = Masonry, Confined Masonry
  • 121 = Masonry, Cavity Double Brick
  • 131 = Concrete, Reinforced concrete
  • 132 = Concrete, Reinforced concrete shear wall w/ mrf
  • 133 = Concrete, Reinforced concrete shear wall w/o mrf
  • 134 = Concrete, Reinforced concrete mrf ductile
  • 135 = Concrete, Reinforced concrete mrf non-ductile
  • 136 = Concrete, Tilt-up
  • 137 = Concrete, Pre-cast concrete
  • 138 = Concrete, Pre-cast concrete w/ shear wall
  • 139 = Concrete, Reinforced concrete mrf
  • 140 = Concrete, Reinforced concrete mrf with URM
  • 141 = Concrete, Reinforced concrete frame with 2nd story wood frame or URM addition       
  • 151 = Steel, Steel
  • 152 = Steel, Light metal
  • 153 = Steel, Braced steel frame
  • 154 = Steel, Steel mrf perimeter
  • 155 = Steel, Steel mrf distributed
  • 156 = Steel, Steel mrf
  • 157 = Steel, Steel frame w/ URM
  • 158 = Steel, Steel frame w/ concrete shear wall
  • 159 = Steel, Steel reinforced concrete
  • 160 = Steel, Steel long span
  • 161 = Composite, FM – Fire res RC Apt. Masonry dwellings
  • 162 = Composite, FT – Fire res non-apt dwl RC mas/stl
  • 163 = Composite, FH – Dwellings other than FM, FT
  • 164 =Composite,  F1 – Fire res RC and masonry bldg
  • 165 = Composite, F2 – Semi-fire res and steel bldg
  • 166 Composite, F3 – Buildings other than F1,F2
  • 171 = Composite, A: Fire-resistive dwellings
  • 172 = Composite, B: Semi-fire-resistive dwellings
  • 173  = Composite, C: Slow-burning dwellings
  • 174 = Composite, D: Dwelling other than A, B or C
  • 175 = Composite, Sp: Fire-resistive concrete buildings
  • 176 = Composite, 1: Fire-resistive buildings other
  • 177 = Composite, 2: Semi-fire-resistive buildings
  • 178 = Composite, 3: Slow-burning buildings
  • 179 = Composite, 4: Other than Sp, 1, 2, or 3
  • 181 = Special, Long-span
  • 182 = Special, Semi-wind resistive
  • 183 = Special, Wind resistive
  • 185 = Special, Unknown glass
  • 186 = Special, Safety glass
  • 187 = Special, Impact resistance glass
  • 191 = Mobile Homes, Mobile Homes
  • 192 = Mobile Homes, Mobile homes no tie down
  • 193 = Mobile Homes, Mobile homes part tie down
  • 194 = Mobile Homes, Mobile homes full tie down
  • 201 = Bridges, Conventional multiple span bridges
  • 202 = Bridges, Conventional continuous bridges
  • 203 = Bridges, Major bridges
  • 204 = Pavements, Railroads
  • 205 = Pavements, Highways
  • 206 = Pavements, Runways
  • 211 = Dams, Concrete dams
  • 212 = Dams, Earthfill dams
  • 213 = Tunnels, Alluvium tunnels
  • 214 = Tunnels, Rock tunnels
  • 215 = Tunnels, Cut and cover tunnels
  • 221 = Storage Tanks, Underground liquid tanks
  • 222 = Storage Tanks, Underground solid tanks
  • 223 = Storage Tanks, On ground liquid tanks
  • 224 = Storage Tanks, On ground solid tanks
  • 225 = Storage Tanks, Elevated liquid tanks
  • 226  = Storage Tanks, Elevated solid tanks
  • 227 = Pipelines Underground pipelines
  • 228 = Pipelines, At-grade pipelines
  • 231 = Chimneys, Masonry chimneys
  • 232 = Chimneys, Concrete chimneys
  • 233 = Chimneys, Steel chimneys
  • 234 =Towers,  Electrical transmission conventional
  • 235 = Towers, Electrical transmission major
  • 236 = Towers, Broadcast towers
  • 237 = Towers, Observation towers
  • 238 = Towers, Offshore towers
  • 239 = Onshore wind turbines
  • 240 = Offshore wind turbines
  • 241 = Equipment, Residential equipment
  • 242 = Equipment, Office equipment
  • 243 = Equipment, Electrical equipment
  • 244 = Equipment, Mechanical equipment
  • 245 = Equipment, High-technology equipment
  • 246 = Equipment, Trains, trucks, airplanes etc.
  • 247 = Equipment, Thermal Power Plant
  • 250 = Miscellaneous, Railway Property
  • 251 = Miscellaneous, Pumping Station
  • 252 = Miscellaneous, Compressor stations
  • 253 = Miscellaneous, Cranes
  • 254 = Miscellaneous, Conveyor systems
  • 255 = Miscellaneous, Canals
  • 256 = Miscellaneous, Earth retaining structures
  • 257 = Miscellaneous, Waterfront structures
  • 258 = Miscellaneous, Offshore structures
  • 259 = Miscellaneous, Transit Warehouse
  • 260 = Miscellaneous, Marine Hull
  • 261 = Automobiles, Automobiles
  • 262 = Automobiles, 4 Wheeler
  • 263 = Automobiles, 2 Wheeler
  • 265 = Marine Craft, Pleasure Boats & Yachts
  • 266 = Marine Craft, Pleasure Boats & Yachts - Power Boats
  • 267 = Marine Craft, Pleasure Boats & Yachts - Sail Boats
  • 270 = Marine Cargo, Carpool
  • 271 = Marine Cargo, General and Containerized Cargo
  • 272 = Marine Cargo, Heavy Cargo
  • 273 = Marine Cargo, Refrigerated Cargo
  • 274 = Marine Cargo, Dry Bulk Cargo
  • 275 = Marine Cargo, Liquid Bulk Cargo
  • 276 = Marine Cargo, New unknown marine cargo code
  • 280 = Marine Cargo, Combustible: Carpool
  • 281 = Marine Cargo, Combustible: General and Containerized
  • 282 = Marine Cargo, Combustible: Heavy Cargo
  • 283 = Marine Cargo, Combustible: Refrigerated Cargo
  • 284 = Marine Cargo, Combustible: Dry Bulk Cargo
  • 285 = Marine Cargo, Combustible: Liquid Bulk Cargo
  • 286 = Marine Cargo, Combustible: Unknown Cargo
  • 290 = Marine Cargo, Non-Combustible: Carpool
  • 291 = Marine Cargo, Non-Combustible: General and Container
  • 292 = Marine Cargo, Non-Combustible: Heavy Cargo
  • 293 = Marine Cargo, Non-Combustible: Refrigerated Cargo
  • 294 = Marine Cargo, Non-Combustible: Dry Bulk Cargo
  • 295 = Marine Cargo, Non-Combustible: Liquid Bulk Cargo
  • 296 = Marine Cargo, Non-Combustible: Unknown Cargo
  • 700 = Uninsurable construction, used only in Research model code (internal use only)
  • 800 = Offshore, Unknown
  • 801 = Offshore, Caisson
  • 802 = Offshore, Compliant Tower
  • 803 = Offshore, Fixed Jacket Platform
  • 804 = Offshore, Jack-up
  • 805 = Offshore, Mini Tension Leg Platform
  • 806 = Offshore, Drill Rig
  • 807 = Offshore, Semi Submersible Floating Production
  • 808 = Offshore, Drill Ship
  • 809 = Offshore, SPAR Floating Production System
  • 810 = Offshore, Submersible Production System
  • 811 = Offshore, Underwater Production Units, Completion
  • 812 = Offshore, Tension Leg Platform
  • 813 = Offshore, Well Protector 
  • 2010 = Bridges, Unknown Bridge
  • 2011 = Bridges, Multispan simply supported CONCRETE
  • 2012 = Bridges, Multispan simply supported STEEL
  • 2013 = Bridges, Single Span Bridge
  • 2015 = Bridges, General Concrete
  • 2016 = Bridges, General Steel
  • 2021 = Bridges, Multispan continuous CONCRETE
  • 2022 = Bridges, Multispan continuous STEEL
  • 2031 = Bridges, Major Bridge
  • 2131 = Tunnels, Alluvium Tunnels
  • 2132 = Tunnels, Alluvial Bored  Tunnels
  • 2141 = Tunnels, Rock Tunnels
  • 2142 = Tunnels, Rock Bored Tunnels
  • 2150 = Tunnels, Unknown Tunnel
  • 2151 = Tunnels, Rock Cut and Cover Tunnels
  • 2152 = Tunnels, Alluvial Cut and Cover Tunnels
  • 2210 = Tanks, Unknown Tanks
  • 2211 = Tanks, Underground Liquid Tanks
  • 2221 = Tanks, Underground Solid Tanks
  • 2231 = Tanks, On Ground Liquid Tanks
  • 2232 = Tanks, On Ground Steel liquid Tanks
  • 2233 = Tanks, On Ground Concrete  liquid Tanks
  • 2241 = Tanks, On Ground Solid Tanks
  • 2242 = Tanks, On Ground Steel solid Tanks
  • 2243 = Tanks, On Ground Concrete solid  Tanks
  • 2251 = Tanks, Elevated  Liquid Tanks
  • 2252 = Tanks, Elevated Steel liquid Tanks
  • 2253 = Tanks, Elevated Concrete liquid Tanks
  • 2261 = Tanks, Elevated Solid Tanks
  • 2262 = Tanks, Elevated Steel solid Tanks
  • 2263 = Tanks, Elevated Concrete solid  Tanks
  • 2270 = Pipelines, Unknown Pipeline
  • 2271 = Pipelines, General Underground Pipelines
  • 2272 = Pipelines, Underground Cast Iron Pipelines
  • 2273 = Pipelines, Underground Asbestos Cement Pipelines
  • 2274 = Pipelines, Underground Concrete Pipelines
  • 2275 = Pipelines, Underground PVC Pipelines
  • 2276 = Pipelines, Underground Ductile Iron Pipelines
  • 2281 = Pipelines, General At Grade Pipelines
  • 2282 = Pipelines, At Grade Cast Iron Pipelines
  • 2283 = Pipelines, At Grade Asbestos Cement Pipelines
  • 2284 = Pipelines, At Grade Concrete Pipelines
  • 2285 = Pipelines, At Grade PVC Pipelines
  • 2286 = Pipelines, At Grade Ductile Iron Pipelines            
smallint2   
 

Categorization for the construction class.

varchar40   
 

Name of the construction class.

Corresponds to the code in AIRConstructionCode.

varchar70  
 Description of the construction class.varchar1024  
 

Indicates whether the construction class can be scored as part of a Data Quality analysis.

  • 1 = Yes
  • 0 = No
bit1 dbo.D_1 
Objects that depend on tAIRConstruction
 Database ObjectObject TypeDescriptionDep Level
tAIRConstOccRegionConstXref tabletAIRConstOccRegionConstXrefTable

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

1
See Also

Related Objects

AIRReference Database