Touchstone 4.0 Database Documentation
tAIRConstruction Table
Description
Stores AIR construction class information.
Properties
Creation Date4/12/2012 4:41 PM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows196
Data Space Used40.00 KB
Index Space Used16.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key AIRConstructionCode

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
  • 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
  • 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, XY: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   
 ConstructionCategory

Categorization for the construction class.

VarChar40   
 AIRConstruction

Name of the construction class.

Corresponds to the code in AIRConstructionCode.

VarChar40   
 DescriptionDescription of the construction class.VarChar1024  
 IsScoringEnabled

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

  • 1 = Yes
  • 0 = No
Boolean1 dbo.D_1 
Check Constraints
NameDescriptionExpression
CKC_ISSCORINGENABLED_TAIRCONS 
([IsScoringEnabled]>=(0) AND [IsScoringEnabled]<=(1))
Objects that depend on tAIRConstruction
 Database ObjectObject TypeDescriptionDep Level
tAIRConstOccRegionConstXref tabletAIRConstOccRegionConstXrefTable

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

1
tConvertEDCConstruction tabletConvertEDCConstructionTable

Stores information regarding the construction class codes when using the exposure data conversion tool (EDC). This information is used when using the EDC to convert RMS construction class codes for use in Touchstone.

1
tConvertEDCCountrySpecificConstruction tabletConvertEDCCountrySpecificConstructionTable

Stores information regarding the region-specific construction codes when using the exposure data conversion tool (EDC). This information is used when using the EDC to convert RMS construction codes for use in Touchstone.

1
tConvertEDCOccupancy tabletConvertEDCOccupancyTable

Stores information regarding the occupancy class codes when using the exposure data conversion tool (EDC). This information is used when using the EDC to convert RMS occupancy class codes for use in Touchstone.

1
tUserConstruction tabletUserConstructionTable

Stores the possible user-supplied construction class 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.