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

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

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

Properties
Creation Date12/24/2014 11:47 AM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows1191
Data Space Used72.00 KB
Index Space Used160.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key 

Code that represents the source of the construction code.

  • ATC = ATC codes
  • EURO = EURO codes
  • FIRE = ISO Fire codes
  • ISO = ISO codes
  • JPBLDG = Japan Building codes
  • RMS =  RMS codes
  • RMSIND = RMS Industrial Facility codes
  • USER = User codes
varchar10   
Primary Key 

Code for the construction class as provided by the source.

varchar5   
Primary Key 

Code for the country to which this occupancy class applies.

For a complete list of codes, see tCountry Table.

varchar15   
 

Code for the corresponding AIR construction class.

For a complete list of codes, see tAIRConstruction Table.

smallint2  
 

Code for the AIR occupancy class.

For a complete list of codes, see tAIROccupancy Table.

smallint2  
 RMS description of the construction class code.varchar1024  
Objects that tConvertEDCConstruction 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