Column heading automapping for location .csv files

Use this topic to map location exposure data correctly for use in Touchstone.

In the table below, the Touchstone Column Name column identifies the default location-related column names available in the Touchstone user interface, while the Acceptable .csv column names column identifies alternative column names. If you use any of these acceptable alternative column names in your .csv import files, Touchstone recognizes and automaps the corresponding columns correctly. The table also identifies the policy type to which each column applies. Touchstone column names may vary by contract type or country.
Section in list of Touchstone column names Touchstone column name Acceptable .csv column names Primary Property (PP) contract type Primary Workers' Compensation (PWC) contract type Facultative Property (FP) contract type Facultative Workers' Compensation (FWC) contract type
Policy (for Primary policies); Certificate (for Facultative policies) Contract ID ContractID, PolicyID, or CertificateID X X
Certificate ID CertificateID, ContractID, or PolicyID X X
Location ID LocationID X X X X
Location Name LocationName X X X X
Location Group Name LocationGroup X X X X
Primary Location IsPrimary, IsPrimaryLocation X X X X
Tenant Location IsTenant X X X X
ISOBIN ISOBIN X X X X
Inception Date InceptionDate X X X X
Expiration Date ExpirationDate X X X X
Address Street Street X X X X
City City X X X X
Subarea (County Name) SubArea, County X X X X
Subarea2 (County) SubArea2 X X X X
Area (State Name) Area, State X X X X
CRESTA Zone CRESTA X X X X
Postal PostalCode, Postal X X X X
Country (ISO Code) COUNTRYISO, Country X X X X
Latitude Latitude X X X X
Longitude Longitude X X X X
User Geocode Match Level UserGeoMatchLevel, GeocodeMatchLevel X X X X
Values Replacement Value Building BuildingValue, RepValBldg X X
Replacement Value Other OtherValue, RepValOther X X
Replacement Value Contents ContentsValue, RepValCont X X
Replacement Value Time TimeElementValue, RepValTime X X
Replacement Value Days Covered DaysCovered X X
Currency Currency X X X X
Number of Risks RiskCount X X X X
Number of Employees NumberOfEmployees X X
Annual Payroll AnnualPayroll X X
Average Annual Wage AverageAnnualWage X X
Percent Day Shift (0-1) PctDayShift X X
Percent Evening Shift (0-1) PctEveningShift X X
Percent Night Shift (0-1) PctNightShift X X
Premium LocPremium X X X X
Replacement Value Physical Damage PhysicalDamageValue X X
Injury Rate Medical and Indemnity Minor AveragePaymentMinor X X
Medical and Indemnity Moderate AveragePaymentModerate X X
Medical and Indemnity Major AveragePaymentMajor X X
Medical and Indemnity Fatality AveragePaymentFatal X X
Basic Building Construction Code Type ConstructionCodeType X X X X
Construction Building ConstructionCode X X X X
Construction Other ConstructionOther X X X X
Occupancy Code Type OccupancyCodeType X X X X
Occupancy Code OccupancyCode X X X X
Year Built YearBuilt, YearInstalled X X X X
Stories Stories, NumberOfStories X X X X
Gross Area GrossArea X X X X
Gross Area Unit Code GrossAreaUnit X X X X
Territory Territory X X X X
ISO Construction ISOConstructionCode, ISO Construction Code X X
ISO Occupancy ISOOccupancyCode, ISO Occupancy Code X X
Building Height BuildingHeight X X X X
Building Height Unit Code BuildingHeightUnits, BuildingHeightUnitCode X X X X
Terms 1 Location Perils LocPerils X X X X
Limit Type LocLimitType X X
Limit Building LimitBldg, LimitPhysicalDamage, PDLimit X X
Limit Other LimitOther, LimitRemovalofDebris, RoDLimit X X
Limit Contents LimitContent, LimitOperatorsExtraExpense, OEELimit X X
Limit Time LimitTime, LimitBusinessInterruption, BILimit X X
Participation 1) Participation1, AssuredInterest, AssuredsInterest, AI X
Participation 2) Participation2, WorkingInterest X
Certificate Participation CertificateParticipation, CertificatePart X
Deductible Type DeductType X X
Deductible Building DeductBldg, Deductible1 X X
Deductible Other DeductOther, Deductible2 X X
Deductible Contents DeductContent, Deductible3 X X
Deductible Time DeductTime, Deductible4 X X
Sublimit Area SublimitArea X X X X
Building Detail Floor of Interest FloorOfInterest X X X X
Floor Area FloorArea X X X X
Floor Area Unit FloorAreaUnit, FloorAreaUnitCode X X X X
Floors Occupied FloorsOccupied X X X X
Building Condition BuildingCondition X X X X
Building Shape BuildingShape X X X X
Torsion Torsion X X X X
Soft Story SoftStory X X X X
Structural Irregularity ShapeIrregularity X X X X
Special Earthquake-Resistive Systems SpecialConstruction X X X X
Retrofit Measures Retrofit X X X X
Short Column ShortColumn X X X X
Ornamentation Ornamentation X X X X
Water Heater WaterHeater X X X X
Redundancy Redundancy X X X X
Tall One Story TallOneStory X X X X
Equipment Equipment X X X X
Seal of Approval SealofApproval X X X X
Extra Data
IS Value Type IsValueType X X X X
Lattice Type LatticeType X X X X
Multi Story Hall Type MultiStoryHallType X X X X
Welding Detail Welding X X X X
Basement Level Count BasementLevelCount X X X X
Basement Finish Type BasementFinishType X X X X
First Floor Height FirstFloorHeight X X X X
Service Equipment Protection ServiceEquipmentProtection X X X X
FIRM Compliance FIRMCompliance X X X X
Content Vulnerability ContentVulnerability X X X X
Certified Structures (IBHS) Certified Structures (IBHS), IBHSFortifiedCode, IBHSFortified, IBHS X X X X
Fire Sprinklers Fire Sprinklers, FireSprinklerAvailable, FireSprinklers, Sprinklers X X
Roof Detail Roof Geometry RoofGeometry X X X X
Roof Pitch RoofPitch X X X X
Roof Covering RoofCover X X X X
Roof Deck RoofDeck X X X X
Roof Covering Attachment RoofCoverAttachment X X X X
Roof Deck Attachment RoofDeckAttachment X X X X
Roof Anchorage RoofAnchorage X X X X
Roof Year Built RoofYearBuilt X X X X
Tank Tank X X X X
Roof Hail Impact Resistance RoofHailImpactResistance X X X X
Chimney Chimney X X X X
Wall Detail Wall Type WallType X X X X
Wall Siding WallSiding X X X X
Glass Type GlassType X X X X
Glass Percentage GlassPercent X X X X
Window Protection WindowProtection X X X X
Exterior Doors ExternalDoors X X X X
Building Exterior Opening BuildingExteriorOpenings X X X X
Brick Veneer BrickVeneer X X X X
Connection Detail Roof Attached Structure RoofAttachedStructure X X X X
Transition in SRC Type TransitionInSRC X X X X
Cold Formed Tube Type ColdFormedtube X X X X
Column Basement Type ColumnBasement X X X X
Foundation Connection FoundationConnection X X X X
Foundation Type FoundationType X X X X
Internal Partition InternalPartition X X X X
Wall Attached Structure AttachedStructures, WallAttachedStructure X X X X
Appurtenant Structure AppurtenantStructures X X X X
Surrounding Detail Pounding Pounding X X X X
Tree Exposure TreeExposure X X X X
Small Debris SmallDebris X X X X
Large Missile LargeMissile X X X X
Terrain Roughness TerrainRoughness X X X X
Adjacent Building Height AdjacentBuildingHeight X X X X
Custom Flood Standard of Protection CustomFloodSOP X X X X
Custom Flood Zone CustomFloodZone X X X X
Custom Elevation CustomElevation X X X X
Base Flood Elevation BaseFloodElevation X X X X
Defensible Space DefensibleSpace X X X X
Firewise Community Participation FirewiseCommunityParticipation X X X X
Platform Details (Offshore) Federal/State/Waters (Area) FederalStateWaters, Waters X X
Protraction/Area (Subarea) ProtractionArea, Protraction X X
Block (Postal) Block X X
AIR Structure ID AIRStructureID, AIRID X X
PBN Definition PBNDefinition X X
MMS Complex ID MMSComplexID X X
MMS Structure ID MMSStructureNumber X X
Topside Cost TopsideCost X X
Gas Production Rate DailyGasProdudtionRate X X
Oil Production Rate DailyOilProductionRate X X
Deck Height DeckHeight, Deck Height X X
Slot Count SlotCount X X
Slot Drill Count SlotDrillCount X X
Leg Count LegCount X X
Deck Count DeckCount X X
Trans Frame Type TransverseFrameTypeCode X X
Manned Flag Manned X X
Company Size CompanySizeCode X X
Well Count WellCount X X
Non-Catastrophe Exposure
Note:

Verisk retired non-catastrophe loss analyses in Touchstone 2021 (9.0). Therefore, these fields do not affect losses.

Public Protection Class PPC Code, PPCCode, PPC X X
Ground-Up Non-Catastrophe Expected Losses NonCatGroundUpLoss X X
Builder Risk Project Completion ProjectCompletion X X X X
Project Phase Code ProjectPhaseCode X X X X
Location User Defined Fields User-Defined Field 1 (UDF 1) UDF1 X X X X
User-Defined Field 2 (UDF 2) UDF2 X X X X
User-Defined Field 3 (UDF 3) UDF3 X X X X
User-Defined Field 4 (UDF 4) UDF4 X X X X
User-Defined Field 5 (UDF 5) UDF5 X X X X
1 You can define multiple coverage term sets for a location, each one based on a unique combination of peril, limits, and deductibles. You can include a particular peril only once in the entire series of coverage term sets for a location. When you use ImportExpress to import locations, you can define up to six coverage term sets for each location; this limit does not exist when you define coverage term sets for a location using the Touchstone user interface. When importing locations, you can define multiple coverage term sets for a location by appending a numeric suffix, such as "1" or "-1," at the end of each field in each term set. For example, to import a location with two coverage term sets, you can specify LocPerils1 in the first coverage term set and LocPerils2 in the second coverage term set. You can add term sets from the Terms tab located at the bottom of the Locations tab. To add one or more term sets, open a contract, select the Terms tab, and then click Add Term Set. Touchstone adds the term set columns at the far right of the Terms tab. As you scroll, you will see the identifier for each set of terms: Term 2, Term 3, Term 4, Term 5, and Term 6. You cannot add a new term set if any location in the grid has six term sets. If, however, a location has less than six terms while another location in the same contract has six terms, you can add a new term set by clicking a location ID and manually adding terms in the Terms grid in the Location Details pane.