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. For information about the import fields, see Location Address Fields.
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.Zip0 |
|
Country (ISO Code) |
Country (ISO Code) |
tLocation.CountryName |
|
|
Latitude |
Latitude |
tLocation.Latitude |
|
|
Longitude |
Longitude |
tLocation.Longitude |