Minimum required fields for import

ImportExpress requires a minimum set of fields in exposure data import files.

The minimum set of fields allows you to import data successfully into Touchstone. When you use ImportExpress to import comma-separated values (.csv) data, Touchstone indicates the required fields in the Required Fields area of each Field Mapping tab.

Note: We recommend that you include additional fields in your import files and map them to Touchstone fields. The more risk-specific information you import, the more accurate your loss results will be.
See Required fields in import files for more information.
Policy type Record type Required fields
Primary Policy Contract
  • Contract ID
  • Insured Name
  • Layer ID
  • Total Limit (Limit 1)
Location
  • Contract ID
  • Location ID
  • Address Information 1
  • Replacement Values
Reinsurance
  • Contract ID
  • Reinsurance ID
  • Exposure ID
Step Function (for Japanese property exposures only)
  • Contract ID
Facultative Property Contract
  • Certificate ID
  • Insured Name
  • Layer ID
  • Participating Layer Amount
  • 100% Layer Amount
Location
  • Certificate ID
  • Location ID
  • Replacement Values
Primary Workers' Compensation Contract
  • Contract ID
  • Insured Name
  • Layer ID
  • Total Limit (Limit 1)
Location
  • Contract ID
  • Location ID
  • Number of Employees / Annual Payroll
  • Address Information1
Reinsurance
  • Contract ID
  • Reinsurance ID
  • Exposure ID
Facultative Workers' Compensation Contract
  • Certificate ID
  • Insured Name
  • Layer ID
  • Participating Amount
  • 100% Layer Amount
Location
  • Contract ID
  • Location ID
  • Number of Employees / Annual Payroll
  • Address Information1
1 Address information can include any combination of country, address, city, area/state, county, postal code, and/or CRESTA zone.