Minimum Required Fields for Import

The following table lists the minimum set of fields that you must include in your exposure data files to import contract and exposure data successfully into Touchstone. When you use AIR ImportExpress to import comma-separated values (CSV) data, Touchstone indicates these required fields in the Required Fields area of each Field Mapping tab in the AIR ImportExpress window.

 

AIR recommends that you also include additional fields in your import files and map these import fields to Touchstone fields. The more risk-specific information you import, the more accurate your loss results will be.

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

       Replacement Values

 

Address information can include any combination of country, address, city, area/state, county, postal code, and/or CRESTA zone.

Reinsurance

       Contract ID

       Reinsurance ID

       Exposure ID

Step Function

       Contract ID

Facultative Property

Contract

       Certificate ID

       Insured Name

       Layer ID

       Participating Layer Amount

       100% Layer Amount

Location

       Certificate ID

       Location ID

       Replacement Values

       Address Information

 

Address information can include any combination of country, address, city, area/state, county, postal code, and/or CRESTA zone.

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 Information

 

Address information can include any combination of country, address, city, area/state, county, postal code, and/or CRESTA zone.

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 Information

 

Address information can include any combination of country, address, city, area/state, county, postal code, and/or CRESTA zone.

 

 


© 2020 AIR Worldwide. All rights reserved.

Touchstone 7.0 Updated September 03, 2020