Location Building Detail Fields for Import

 

The table below lists all the Touchstone building detail 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

Floor of Interest

Floor of Interest

tLocFeature.FloorOfInterest

 

Floor Area

Floor Area

tLocFeature.FloorArea

 

Floor Area Unit

Floor Area Units

tLocFeature.FloorAreaUnitCode

 

Floors Occupied

Floor Occupied

tLocFeature.FloorsOccupied

 

Building Condition

Building Condition

tLocFeature.BuildingConditionCode

 

Building Shape

Building Shape

tLocFeature.BuildingShapeCode

 

Torsion

Torsion

tLocFeature.TorsionCode

 

Soft Story

Soft Story

tLocFeature.SoftStoryCode

 

Structural Irregularity

Structural Irregularity

tLocFeature.ShapeIrregularityCode

 

Special Earthquake-Resistive Systems

Special Earthquake-Resistive Systems

tLocFeature.SpecialConstructionCode

 

Retrofit Measures

Retrofit Measures

tLocFeature.RetrofitCode

 

Short Column

Short Column

tLocFeature.ShortColumnCode

 

Ornamentation

Ornamentation

tLocFeature.OrnamentationCode

 

Water Heater

Water Heater

tLocFeature.WaterHeaterCode

 

Redundancy

Redundancy

tLocFeature.RedundancyCode

 

Tall One Story

Tall One Story

tLocFeature.TallOneStoryCode

 

Equipment

Equipment

tLocFeature.EquipmentCode

 

Seal of Approval

Seal Of Approval

tLocFeature.SealOfApprovalCode

 

Extra Data

Extra Data

tLocFeature.ExtraData

 

IS Value Type

IS Value Type

tLocFeature.ISValueCode

 

Lattice Type

Lattice Type

tLocFeature.LatticeCode

 

Multi Story Hall Type

Multi Story Hall Type

tLocFeature.MultiStoryHallCode

 

Welding Detail

Welding Detail

tLocFeature.WeldingCode

 

Basement Level Count

Basement Level Count

tLocFeature.BasementLevelCount

 

Basement Finish Type

Basement Finish Type

tLocFeature.BasementFinishTypeCode

 

First Floor Height

First Floor Height

tLocFeature.FirstFloorHeight

 

First Floor Height Unit

Not shown in the user interface

tLocFeature.FirstFloorHeightUnitCode

 

Service Equipment Protection

Service Equipment Protection

tLocFeature.ServiceEquipmentProtectionCode

 

FIRM Compliance

FIRM Compliance

tLocFeature.FIRMComplianceCode

 

Content Vulnerability

Content Vulnerability

tLocFeature.ContentVulnerabilityCode

 

Certified Structures (IBHS)

Certified Structures (IBHS)

tLocFeature.IBHSFortifiedCode

 

Fire Sprinklers

IsFireSprinklerAvailable

tLocFeature.IsFireSprinklerAvailable

 

 

© 2016 AIR Worldwide. All rights reserved.

Click here for information about AIR Worldwide, including copyright, trademarks, confidentiality, and contact information.

Touchstone V3.0 Updated December 01, 2016