Touchstone 4.0 Database Documentation
tConvertEDCOccupancy Table
Description

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.

Properties
Creation Date3/1/2013 11:16 AM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows5363
Data Space Used528.00 KB
Index Space Used408.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.

Integer4   
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.VarChar255  
 AIRDescriptionAIR description of the occupancy class code.VarChar255  
Objects that tConvertEDCOccupancy depends on
 Database ObjectObject TypeDescriptionDep Level
tAIRConstruction tabletAIRConstructionTableStores AIR construction class information.1
tAIROccupancy tabletAIROccupancyTableStores AIR occupancy class information.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.