Workers' Compensation Values Fields for Import

The table below lists 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.

Note:

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