Column Heading Automapping for Location CSV Files

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

Country (CLASIC/2 Code)

COUNTRYCL2

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

Note:

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 AIR 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 tabs, 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.

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

Tanks

Tanks

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

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

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

 

 

© 2020 AIR Worldwide. All rights reserved.

Touchstone 7.0 Updated September 03, 2020