Workers' Compensation Values Fields for Import

 

The table below lists all the Touchstone values 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.

  Please note that AIR ImportExpress rounds all imported monetary values to the nearest whole number if these values contain decimal places.

Import Field

User Interface Field

Database Field

Required

Currency

You can select the Display Currency.

tLocation.CurrencyCode

 

Number of Risks

Number of Risks

tLocation.RiskCount

 

Number of Employees

Number of Employees

tLocWC.Employees

 

Annual Payroll

Annual Payroll

tLocWC.AnnualPayroll

 

Average Annual Wage

Average Annual Wage

tLocWC.AverageAnnualPay

 

Percent Day Shift (0-1)

Percent Day Shift

tLocWC.PercentDayShift

 

Percent Evening Shift (0-1)

Percent Evening Shift

tLocWC.PercentEveningShift

 

Percent Night Shift (0-1)

Percent Night Shift

tLocWC.PercentNightShift

 

Premium

Premium

tLocation.Premium

 

 

© 2016 AIR Worldwide. All rights reserved.

Click here for information about AIR Worldwide, including copyright, trademarks, confidentiality, and contact information.

Touchstone V3.0 Updated December 01, 2016