Facultative Property or Workers' Compensation Contract Layer Fields for Import

The table below lists the Touchstone layer fields to which you can map comma-separated values (CSV) import data for facultative property or primary workers' compensation contracts. 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

Layer ID

Layer ID

tLayer.LayerID

Required only if you are using layers

Layer Perils

Perils

Note:

To specify multiple perils in a single entry within an import file, separate the corresponding peril codes with a Plus (+) symbol, such as, PWH+PES).

tLayer.PerilSetCode

Assumed Amount

Not shown in the user interface

Used for calculating the value for the tLayer.OccParticipation field, as follows:

OccParticipation = Assumed Amount / 100% Layer Amount

Participating Layer Amount

Participation Limit (Limit 2 / Limit B)

tLayer.OccParticipation

Required only if you are using layers

100% Layer Amount

Total Limit (Limit 1 / Limit A)

tLayer.OccTotalLimit

Required only if you are using layers

Facultative Attachment Amount

Attachment Point

tLayer.AttachmentPoint

Deductible Type

Deductible Type

tLayer.DeductibleTypeCode

Deductible Amount 1

Deductible 1

tLayer.Deductible1

Deductible Amount 2

Deductible 2

tLayer.Deductible2

Premium

Premium

tLayer.Premium