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.

Touchstone 5.0 Updated July 09, 2019