Workers' compensation address fields for import
In ImportExpress, you map workers' compensation address fields in .csv import files to valid Touchstone fields.
Note: 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 |