Touchstone 4.0 Database Documentation
tConvertISOOccupancy Table
Description

Stores information regarding the ISO occupancy codes. This information is used to convert ISO occupancy codes to Touchstone occupancy codes.

Properties
Creation Date11/26/2013 9:19 AM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows99
Data Space Used8.00 KB
Index Space Used8.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key ISOOccupancyCode

Code that represents the ISO occupancy codes.

  • 0074 = Boarding and Lodging Houses, Rooming Houses, Fraternities and Sororities, Dormitories - Up to 10 Units
  • 0075 = Boarding and Lodging Houses, Rooming Houses, Fraternities and Sororities, Dormitories - 11 to 30 Units
  • 0076 = Boarding and Lodging Houses, Rooming Houses, Fraternities and Sororities, Dormitories - Over 30 Units
  • 0077 = Convents, Monasteries and Rectories, Orphan Homes, Nurses. Homes, Sisters. Homes - Up to 10 Units
  • 0078 = Convents, Monasteries and Rectories, Orphan Homes, Nurses. Homes, Sisters. Homes - 11 to 30 Units
  • 0079 = Convents, Monasteries and Rectories, Orphan Homes, Nurses. Homes, Sisters. Homes - Over 30 Units
  • 0196 = Dwellings Written in Conjunction with Commercial Risks from the Commercial Lines Manual - 1 Family
  • 0197 = Dwellings Written in Conjunction with Commercial Risks from the Commercial Lines Manual - 2 Family
  • 0198 = Dwellings Written in Conjunction with Commercial Risks from the Commercial Lines Manual - 3 and 4 Family
  • 0311 = Apartments without Mercantile Occupancies - Up to 10 Units
  • 0312 = Apartments without Mercantile Occupancies - 11 to 30 Units
  • 0313 = Apartments without Mercantile Occupancies - Over 30 Units
  • 0321 = Apartments with Mercantile Occupancies - Up to 10 Units
  • 0322 = Apartments with Mercantile Occupancies - 11 to 30  Units
  • 0323 = Apartments with Mercantile Occupancies - Over 30 Units
  • 0331 = Residential Condominiums without Mercantile Occupancies - Up to 10 Units
  • 0332 = Residential Condominiums without Mercantile Occupancies - 11 to 30 Units
  • 0333 = Residential Condominiums without Mercantile Occupancies - Over 30 Units
  • 0341 = Residential Condominiums with Mercantile Occupancies - Up to 10 Units
  • 0342 = Residential Condominiums with Mercantile Occupancies - 11 to 30  Units
  • 0343 = Residential Condominiums with Mercantile Occupancies - Over 30 Units
  • 0511 = Risks Having Low Susceptibility Personal Property, NOC
  • 0512 = Tire, Battery and Accessory Dealers Without Tire Recapping and Vulcanizing
  • 0520 =Wearing Apparel, Textiles, Shoes
  • 0531 = Alcoholic Beverages other than Bars
  • 532 = Food Products including Retail Bakeries (no baking and no cooking on premises; sales only); Beverages other than Alcohol
  • 0533 = Retail Bakeries - Baking on Premises (No delivery to other outlets)
  • 0534 = Food Products with Limited Cooking, Excluding Bakeries
  • 0541 = Bars and Taverns
  • 0545 = Restaurants with Limited Cooking
  • 0550 = Motor Vehicle (Auto, Aircraft, Marine) Sales, No Repair
  • 0561 = Boat and Marine Supply Dealers
  • 0562 = Drugs
  • 0563 = Electrical Goods, Hardware and Machinery
  • 0564 = Furniture and Home Furnishings other than Appliances
  • 0565 = Jewelry
  • 0566 = Sporting Goods
  • 0567 = Risks Having Moderate Susceptibility Personal Property, NOC
  • 0570 = Risks Having High Susceptibility Personal Property, NOC
  • 0580 = Greenhouses
  • 0581 = Multiple Occupancy Mercantile, Fire Class Rated, without furniture Occupant
  • 0582 = Multiple Occupancy Mercantile, Fire Class Rated, with furniture Occupant
  • 0701 = Governmental Offices
  • 0702 = Non-Governmental Offices and Banks
  • 0742 = Motels and Hotels with Restaurant - Up to 10 Units
  • 0743 = Motels and Hotels with Restaurant - 10 to 30 Units
  • 0744 = Motels and Hotels with Restaurant - Over 30 Units
  • 0745 = Motels and Hotels without Restaurant - Up to 10 Units
  • 0746 = Motels and Hotels without Restaurant - 10 to 30 Units
  • 0747 = Motels and Hotels without Restaurant - Over 30 Units
  • 0755 = Golf Clubs, Tennis Clubs and Similar Sports Facilities with Cooking
  • 0756 = Golf Clubs, Tennis Clubs and Similar Sports Facilities without Cooking
  • 0757 = Clubs, NOC, Including Fraternal and Union Halls
  • 0831 = Motion Picture Studios
  • 0832 = Theaters
  • 0833 = Drive-in Theaters
  • 0834 = Skating Rinks--Roller Rinks
  • 0841 = Bowling Alleys
  • 0843 = Halls and Auditoriums
  • 0844 = Recreational Facilities, NOC
  • 0845 = Boys. and Girls. Camps
  • 0846 = Dance Halls, Ballrooms & Discotheques
  • 0851 = Hospitals
  • 0852 = Nursing and Convalescent Homes
  • 0900 = Churches and Synagogues
  • 0911 = Dry Cleaner and Dyeing Plants, other than Self-Service
  • 0912 = Laundries, other than Self-Service
  • 0913 = Self-Service Laundries and Dry Cleaners
  • 0921 = Light Hazard Service Occupancies
  • 0922 = Services Occupancies, Other than Light Hazard, NOC
  • 0923 = Funeral Homes
  • 0931 = Auto Parking Garages, Car Washes
  • 0932 = Gasoline Service Stations
  • 0933 = Aircraft Hangars with Repairing, Motor Vehicle Repairing Including Auto Body Shops, with or without Sales
  • 0934 = Tire Recapping and Vulcanizing with or without Sales
  • 0940 = Aircraft Hangars without Repairing
  • 0951 = Gambling Casinos with Restaurants
  • 0952 = Gambling Casinos without Restaurants
  • 1000 = Penal Institutions
  • 1051 = Museums, Libraries, Art Galleries (non-profit)
  • 1052 = Schools, Academic
  • 1070 = Other Public Buildings, Fire Dept., Police, Water/Sewer
  • 1150 = Buildings Under Construction
  • 1211 = Freight Terminals
  • 1212 = General Storage Warehouses - Bailee
  • 1213 = Miscellaneous Products Storage - (other than Retail or Wholesale or Cold Storage)
  • 1220 = Household Goods Storage
  • 1230 = Cold Storage Warehouses
  • 1400 =Waste and Reclaimed Material, including Yards
  • 1650 = Building Supply Yards, including Retail Lumberyards, Coal and Coke Yards
  • 1700 = Mill Yards
  • 1751 = Oil Distributing, Oil Terminals and LPG Tank Farms, Including Stock
  • 1752 = Oil Distributing, Oil Terminals and LPG Tank Farms, Excluding Stock
  • 2200 = Bakeries and Bakery Products
  • 2350 = Beverages excluding Alcoholic Beverages
  • 2459 = Distilleries and Wineries
  • 2800 = Textile Mill Products - Natural and Synthetic
  • 3409 = Leather and Leather Products
  • 4809 = Printing
VarChar10   
 ISOOccupancy

Description of the ISO occupancy codes.

Corresponds to the code in ISOOccupancyCode.

VarChar255   
Primary Key AIROccupancyCode

Code that represents the AIR occupancy class code that corresponds to the ISO Occupancy Code.

For a complete list of codes, see tAIROccupancy Table.

SmallInt2   
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.