Workers' Compensation Address Fields for Import

The table below lists the Touchstone address fields to which you can map comma-separated values (CSV) import data for primary or facultative workers' compensation and personal accident exposures. 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.

 

Avoid the following special characters in your import files, especially in address-related data, such as street, city, area, etc.: $, +, -, ., \. These special characters may cause geocoding, validation, and import errors.

Import Field

User Interface Field

Database Field

Required

Street

Street

tLocation.Address

 

City

City

tLocation.City

 

Subarea (County Name)

Subarea (County Name)

tLocation.SubareaName

 

Subarea2 (County)

Subarea2 (County)

tLocation.Subarea2Name

 

Area (State Name)

Area (State Name)

tLocation.AreaName

 

CRESTA Zone

CRESTA Zone

tLocation.CrestaName

 

Postal

Postal

tLocation.PostalName or tLocation.Zip9

 

Country (ISO Code)

Country (ISO Code)

tLocation.CountryName

 

Country (CLASIC/2 Code)

Converted to Country (ISO Code) during geocoding process

For more information, see Using Geocoding in Touchstone, which is available on the AIR Client Portal.

tLocation.CountryName

 

Latitude

Latitude

tLocation.Latitude

 

Longitude

Longitude

tLocation.Longitude

 

 


© 2019 AIR Worldwide. All rights reserved.

Touchstone 5.0 Updated July 09, 2019