Primary property or workers' compensation policy layer fields for import

In ImportExpress, you map .csv import data to valid Touchstone fields for primary policies.

This table lists the import field and the Touchstone user interface field and database field that correspond to each import field. Import fields are in italic font because the field name is variable.

Note:

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
Limit Type Limit Type
Note: Touchstone does not support layers with C (Limit by Coverage) or CB (Combined, Including Time Separately) limit types. Therefore, if your import file contains a layer with either limit type (C or CB), Touchstone transfers the data from this layer to the sublimit to preserve the C or CB limit type.
tLayer.OccLimitTypeCode
Total Limit (Limit 1) Total Limit tLayer.OccTotalLimit Required only if you are using layers
Participation Limit (Limit 2) Participation Limit
Note:

If the value in this column is less than or equal to 1, ImportExpress displays the value in the user interface as a whole number percentage of the Total Limit value.

If the value is greater than or equal to "0" and less than or equal to "1", the value is saved as a percentage.

If the value is greater than "1", it is considered to be an amount. A percentage is calculated from the Total Limit and is saved as a percentage.
tLayer.OccParticipation

The value is stored as a percentage of the total limit.

Limit A This is converted to a sublimit in the user interface. tLayerCondition.OccLimit1
Limit B This is converted to a sublimit in the user interface. tLayerCondition.OccLimit2
Limit C This is converted to a sublimit in the user interface. tLayerCondition.OccLimit3
Limit D This is converted to a sublimit in the user interface. tLayerCondition.OccLimit4
Deductible Type Deductible Type tLayer.DeductibleTypeCode
Deductible Amount 1 Deductible 1 tLayer.Deductible1
Deductible Amount 2 Deductible 2 tLayer.Deductible2
Attachment Amount Attachment Point tLayer.AttachmentPoint
Attachment Point A This is converted to a sublimit in the user interface. tLayerCondition.Attachment1
Attachment Point B This is converted to a sublimit in the user interface. tLayerCondition.Attachment2
Attachment Point C This is converted to a sublimit in the user interface. tLayerCondition.Attachment3
Attachment Point D This is converted to a sublimit in the user interface. tLayerCondition.Attachment4
Premium Premium tLayer.Premium