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 |
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 |
|
Content Vulnerability |
Content Vulnerability |
tLocFeature.ContentVulnerabilityCode |
|
Certified Structures (IBHS) |
Certified Structures (IBHS) |
tLocFeature.IBHSFortifiedCode |
|
Fire Sprinklers Note:
AIR has retired non-catastrophe loss analyses in Touchstone 2021 (9.0). Therefore, these fields do not affect losses. |
IsFireSprinklerAvailable |
tLocFeature.IsFireSprinklerAvailable |