Touchstone 2022 Database Reference
tConvertEDCOccupancy Table
AIRReference Database : tConvertEDCOccupancy Table
Description

Stores information about the occupancy class codes used in the exposure data conversion tool (EDC).

Touchstone uses the information to convert RMS occupancy class codes to Touchstone occupancy class codes.

Properties
Creation Date3/1/2013 11:16 AM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows5287
Data Space Used360.00 KB
Index Space Used352.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key OCCSCHEME

Code that represents the source of the occupancy code.

  • RMSIND = RMS Industrial Facility codes
  • SIC = Standard Industrial Classification codes
  • ATC = ATC codes
  • EURO = EURO codes
  • EURO_FR = EURO France codes
  • IBC = IBC codes
  • NAICS = North American Industry Classification System codes
  • NCCI = National Council on Compensation Insurance codes
  • WCOCC = Workers' Compensation Occupancy codes (RMS specific)
varchar10   
Primary Key OCCTYPE

Code for the occupancy class as provided by the source.

int4   
Primary Key CountryCode

Code for the country to which this occupancy class applies.

For a complete list of codes, see tCountry Table.

varchar15   
 AIROccupancyCode

Code for the AIR occupancy class.

For a complete list of codes, see tAIROccupancy Table.

smallint2  
 AIRConstructionCode

Code for the corresponding AIR construction class.

For a complete list of codes, see tAIRConstruction Table.

smallint2  
 RMSDescriptionRMS description of the occupancy class code.varchar1024  
Objects that tConvertEDCOccupancy depends on
 Database ObjectObject TypeDescriptionDep Level
tAIRConstruction tabletAIRConstructionTableStores information about AIR construction class codes.1
tAIROccupancy tabletAIROccupancyTableStores information about AIR occupancy class codes.1
See Also

Related Objects

AIRReference Database

 

 

Verisk Analytics Client Confidential

© 2022. AIR Worldwide is now Extreme Event Solutions. AIR Worldwide is a registered trademark. Touchstone is a registered trademark of AIR Worldwide.

Please contact Verisk Analytics with questions or comments.