Touchstone 4.0 Database Documentation
tAIROccupancy Table
Description
Stores AIR occupancy class information.
Properties
Creation Date2/16/2011 6:00 PM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows136
Data Space Used24.00 KB
Index Space Used16.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key AIROccupancyCode

Code that represents the AIR occupancy class.

  • 300 = Unknown
  • 301 = Residential, General residential
  • 302 = Residential, Permanent dwelling: single-family
  • 303 = Residential, Permanent dwelling: multi-family
  • 304 = Residential, Temporary lodging
  • 305 =  Residential, Group institutional housing
  • 306 = Residential, Apartment/Condo    
  • 307 = Residential, Terraced Housing
  • 311 = Commercial, General commercial
  • 312 = Commercial, Retail trade
  • 313 = Commercial, Wholesale trade
  • 314 = Commercial, Personal and repair services
  • 315 = Commercial, Professional, technical and business
  • 316 = Commercial, Health care services
  • 317 = Commercial, Entertainment and recreation
  • 318 = Commercial, Parking
  • 319 = Commercial, Golf Courses
  • 321 = Industrial, General industrial
  • 322 Industrial, Heavy fabrication and assembly
  • 323 = Industrial, Light fabrication and assembly
  • 324 = Industrial, Food and drug processing
  • 325 = Industrial, Chemical processing
  • 326 = Industrial, Metal and minerals processing
  • 327 = Industrial, High technology
  • 328 = Industrial, Construction
  • 329 = Industrial, Petroleum
  • 330 = Industrial, Mining
  • 331 = Restaurants, Restaurants
  • 335 = Mercantile, Gasoline Stations
  • 336 = Mercantile, Automotive repair services and carwash
  • 341 = Religion and Nonprofit Religion and nonprofit
  • 342 Religion and Nonprofit, Church
  • 343 = Government, General services
  • 344 = Government, Emergency services
  • 345 = Education, Universities, colleges and technical schools
  • 346 = Education, Primary and secondary schools 
  • 351 = Transportation, Highway
  • 352 = Transportation, Railroad
  • 353 = Transportation, Air
  • 354 = Transportation, Sea and inland waterways
  • 355 = Transportation, Aircraft Hangars
  • 356 Transportation, Aircrafts at ramps or boarding gates
  • 361 = Utilities, Electrical
  • 362 = Utilities, Water
  • 363 = Utilities, Sanitary sewer
  • 364 = Utilities, Natural gas
  • 365 Utilities, Telephone and telegraph
  • 366 = Commercial, Warehouse
  • 371 = Miscellaneous, Communication
  • 372 Flood control
  • 373 Agriculture
  • 374 Green House
  • 375Forestry
  • 381 = Miscellaneous, Construction/Erection Risks 
  • 382 = Residential, Construction/Erection Risks
  • 383 = Commercial, Construction/Erection Risks
  • 384 = Industrial, Construction/Erection Risks
  • 400 = Industrial Facilities Model, IFM: Unknown
  • 401 = Industrial Facilities Model, IFM: Heavy Fabrication and Assembly - General
  • 402 = Industrial Facilities Model, IFM: Automotive Manufacturing
  • 403 = Industrial Facilities Model, IFM: Fabricated Metal Products
  • 404 = Industrial Facilities Model, IFM: Industrial and commercial machinery and equipment
  • 405 = Industrial Facilities Model, IFM: Transportation Equipment Assembly
  • 406 Industrial Facilities Model, IFM: Pulp/Paper and Allied Products Manufacturing
  • 407 Industrial Facilities Model, IFM: Textile Mill Product
  • 408 = Industrial Facilities Model,  IFM: Lumber and wood products (excluding furniture)
  • 409 = Industrial Facilities Model, IFM: Stone/Clay/Glass/Ceramics products
  • 414 = Industrial Facilities Model, IFM: Light Fabrication and Assembly - General
  • 415 = Industrial Facilities Model, IFM: Furniture and Fixtures
  • 416 = Industrial Facilities  Model, IFM: Apparel and finished products from fabrics
  • 417 = Industrial Facilities Model, IFM: Print/Publishing and allied industry 
  • 418 Industrial Facilities Model, IFM: Rubber and miscellaneous plastics products
  • 419 = Industrial Facilities Model, IFM: Leather and Leather products
  • 420 = Industrial Facilities Model, IFM: Electronic and other electrical equipment (except computer equipment)
  • 421 = Industrial Facilities Model, IFM: Measuring analyzing and controlling instruments
  • 422 Industrial Facilities Model, IFM: Photographic medical and optical goods
  • 423 = Industrial Facilities Model, IFM: Watches and clocks
  • 424 = Industrial Facilities Model, IFM: Miscellaneous Light Manufacturing Industries
  • 425 = Industrial Facilities Model, IFM: Tire manufacturers
  • 429 = Industrial Facilities Model, IFM: Food and Drug Processing  - General
  • 430 = Industrial Facilities Model, IFM: Food and kindred products
  • 431 = Industrial Facilities Model, IFM: Tobacco products
  • 432 = Industrial Facilities Model, IFM: Pharmaceutical plants
  • 433 = Industrial Facilities Model, IFM: Biological Products  (except diagnostic) - Medicinals/Botanical/Biomedical
  • 434 = Industrial Facilities Model, IFM: Wineries
  • 438 = Industrial Facilities Model, IFM: Chemical Processing - General
  • 439 = Industrial Facilities Model, IFM: Chlorine plants       
  • 440 = Industrial Facilities Model, IFM: Vinyl plants
  • 441 = Industrial Facilities Model, IFM: Light hydrocarbon or aromatics plants
  • 442 = Industrial Facilities Model, IFM: Plastics plants
  • 443 = Industrial Facilities Model, IFM: Chlorhydrin plants
  • 444 Industrial Facilities Model, IFM: Fertilizer plants
  • 445 = Industrial Facilities Model, IFM: Cement plants/Cement Mills
  • 446 = Industrial Facilities Model, IFM: Other Chemical and Allied Products
  • 449 = Industrial Facilities Model, IFM: Metal and Minerals Processing  - General
  • 450 = Industrial Facilities Model, IFM: Primary metal industry
  • 451 Industrial Facilities Model, IFM: Steel Mills
  • 452 = Industrial Facilities Model, IFM: Smelters
  • 455 = Industrial Facilities Model, IFM: High Technology - General
  • 456 = Industrial Facilities Model, IFM: Semi-conductor and related devices
  • 457 = Industrial Facilities Model, IFM: Electronic computer devices
  • 458 = Industrial Facilities Model, IFM: Computer storage devices
  • 459 = Industrial Facilities Model, IFM: Electron tubes
  • 460 = Industrial Facilities Model, IFM: Printed circuit boards
  • 463 = Industrial Facilities Model, IFM: General building/ construction contractors
  • 464 = Industrial Facilities Model, IFM: Heavy Constructions
  • 465 = Industrial Facilities Model, IFM: Special Trade Contractors
  • 470 = Industrial Facilities Model, IFM: Mining - General
  • 471 = Industrial Facilities Model, IFM: Mining operations
  • 472 = Industrial Facilities Model, IFM: Metal mining
  • 473 = Industrial Facilities Model, IFM: Coal mining
  • 474 = Industrial Facilities Model, IFM: Mining /Quarrying - Non-metallic mineral (except fuels_
  • 475 = Industrial Facilities Model, IFM: Oil Refinery Systems - General
  • 476 = Industrial Facilities Model, IFM: Hydro-Electric Power Systems  - General
  • 477 = Industrial Facilities Model, IFM: Thermo-Electric Power Systems  - General
  • 478 = Industrial Facilities Model, IFM: Nuclear Power Systems All - General
  • 479 = Industrial Facilities Model, IFM: Electric Substation - General
  • 480 = Industrial Facilities Model, IFM: Potable water Systems - General
  • 481 = Industrial Facilities Model, IFM: Waste water treatment Systems  - General
  • 482 = Industrial Facilities Model, IFM: Gas Processing Systems - General
  • 483 = Industrial Facilities Model, IFM Communication Systems - General
  • 484 = Agriculture Systems - General
  • 485 = Industrial Facilities Model, IFM: Bus Systems - General
  • 486 = Industrial Facilities Model, IFM: Port Systems
  • 487 = Industrial Facilities Model, IFM: Ferry Systems
  • 488 = Industrial Facilities Model, IFM: Airport Systems - General
  • 900 = Offshore, Unknown
  • 901 = Offshore, Oil production only
  • 902 = Offshore, Gas production only
  • 903 = Offshore, No production
  • 904 = Offshore, Oil and gas production
  • 905 = Offshore, Drilling
  • 906 = Offshore, Workover
  • 907 = Offshore, Ready stacked
  • 908 = Offshore, Waiting on location
  • 909 = Offshore, Pipelines
SmallInt2   
 OccupancyCategory

Categorization for the occupancy class.

VarChar40   
 AIROccupancy

Name of the occupancy class.

Corresponds to the code in AIROccupancyCode.

VarChar40   
 Description

Description of the occupancy class.

VarChar1024  
Objects that depend on tAIROccupancy
 Database ObjectObject TypeDescriptionDep Level
tAIRConstOccRegionOccXref tabletAIRConstOccRegionOccXrefTableSystem reference table used to determine the geographic region associated with a specific AIR occupancy class.1
tAIROccupancyRegionXref tabletAIROccupancyRegionXrefTable

System reference table that is used to group occupancy and region information.

1
tAIROccupancyWeightTypeXref tabletAIROccupancyWeightTypeXrefTable

System reference table used to determine the weight type for each occupancy code.

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
tConvertEDCCountrySpecificOccupancy tabletConvertEDCCountrySpecificOccupancyTable

Stores information regarding the region-specific occupancy codes when using the exposure data conversion tool (EDC). This information is used when using the EDC to convert RMS occupancy 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
tUserOccupancy tabletUserOccupancyTable

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