Location Basic Building Fields for Import

The table below lists the Touchstone basic building fields to which you can map comma-separated values (CSV) import data for primary or facultative property locations. In addition, this table lists the Touchstone user interface field and database field that correspond to each import field and provides a link to the description of and validation rules for each import field.

Import Field

User Interface Field

Database Field

Required

Construction Code Type

Construction Code Type

tLocation.UserConstructionSchemeCode

 

Construction Building

Construction Building

tLocation.UserConstructionCodeA

 

Construction Other

Construction Other Structures

tLocation.UserConstructionCodeB

 

Occupancy Code Type

Occupancy Code Type

tLocation.UserOccupancySchemeCode

 

Occupancy Code

Occupancy Code

tLocation.UserOccupancyCode

 

Year Built

Year Built

tLocation.YearBuilt

 

Stories

Stories

tLocation.Stories

 

Gross Area

Gross Area

tLocation.GrossArea

 

Gross Area Unit Code

Gross Area Units

tLocation.GrossAreaUnitCode

 

Territory

Territory

tLocation.Territory

 

Building Height

Building Height

tLocation.BuildingHeight

 

Building Height Unit Code

Building Height Units

tLocation.BuildingHeightUnitCode

 

ISO Occupancy Code

ISO Occupancy Code

tLocFeature.ISOOccupancyCode

 

ISO Construction Code

ISO Construction Code

tLocFeature.ISOConstructionCode

 
  If you want to import non-AIR construction class codes, make sure that you either include specific data for both the Construction Building field and the Construction Other Structures field in your Locations import file, or, do not map the Construction Other Structures field to a Touchstone field during the import process.
 

Touchstone also supports non-AIR construction and occupancy class codes, although AIR always recommends translating non-AIR codes to AIR codes wherever possible before importing your data. For more information, see Non-AIR Construction Class Codes and Non-AIR Occupancy Class Codes.

 

 


© 2020 AIR Worldwide. All rights reserved.

Touchstone 7.0 Updated September 03, 2020