Location Building Detail Fields for Import |
The table below lists 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 |
tLocFeature.FloorOfInterest |
|
|
Floor Area |
tLocFeature.FloorArea |
|
|
Floor Area Unit |
tLocFeature.FloorAreaUnitCode |
|
|
Floors Occupied |
tLocFeature.FloorsOccupied |
|
|
Building Condition |
tLocFeature.BuildingConditionCode |
|
|
Building Shape |
tLocFeature.BuildingShapeCode |
|
|
Torsion |
tLocFeature.TorsionCode |
|
|
Soft Story |
tLocFeature.SoftStoryCode |
|
|
Structural Irregularity |
tLocFeature.ShapeIrregularityCode |
|
|
Special Earthquake-Resistive Systems |
tLocFeature.SpecialConstructionCode |
|
|
Retrofit Measures |
tLocFeature.RetrofitCode |
|
|
Short Column |
tLocFeature.ShortColumnCode |
|
|
Ornamentation |
tLocFeature.OrnamentationCode |
|
|
Water Heater |
tLocFeature.WaterHeaterCode |
|
|
Redundancy |
tLocFeature.RedundancyCode |
|
|
Tall One Story |
tLocFeature.TallOneStoryCode |
|
|
Equipment |
tLocFeature.EquipmentCode |
|
|
Seal of Approval |
tLocFeature.SealOfApprovalCode |
|
|
Extra Data |
tLocFeature.ExtraData |
|
|
IS Value Type |
tLocFeature.ISValueCode |
|
|
Lattice Type |
tLocFeature.LatticeCode |
|
|
Multi Story Hall Type |
tLocFeature.MultiStoryHallCode |
|
|
Welding Detail |
tLocFeature.WeldingCode |
|
|
Basement Level Count |
tLocFeature.BasementLevelCount |
|
|
Basement Finish Type |
tLocFeature.BasementFinishTypeCode |
|
|
First Floor Height |
tLocFeature.FirstFloorHeight |
|
|
First Floor Height Unit |
Not shown in the user interface |
tLocFeature.FirstFloorHeightUnitCode |
|
Service Equipment Protection |
tLocFeature.ServiceEquipmentProtectionCode |
|
|
Content Vulnerability |
tLocFeature.ContentVulnerabilityCode |
|
|
Certified Structures (IBHS) |
tLocFeature.IBHSFortifiedCode |
|
|
Fire Sprinklers |
tLocFeature.IsFireSprinklerAvailable |
© 2020 AIR Worldwide. All rights reserved. Touchstone 7.0 Updated September 03, 2020 |