Primary Property or Workers' Compensation Contract Layer Fields for Import

 

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

  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

Layer ID

Layer ID

tLayer.LayerID

Required only if you are using layers

Layer Perils

Perils

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

tLayer.PerilSetCode

 

Limit Type

Limit Type

  Touchstone does not support layers with C (Limit by Coverage) or CB (Combined, Including Time Separately) limit types. Consequently, if your import file contains a layer with a limit type of C (Limit By Coverage) or CB (Combined, Including Time Separately), Touchstone transfers the data from this layer to the sublimit in order 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

tLayer.OccParticipation (stored as a percentage of the total limit)

 

Limit A

Converted to sublimit in user interface

tLayerCondition.OccLimit1

 

Limit B

Converted to sublimit in user interface

tLayerCondition.OccLimit2

 

Limit C

Converted to sublimit in user interface

tLayerCondition.OccLimit3

 

Limit D

Converted to sublimit in 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

Converted to sublimit in user interface

tLayerCondition.Attachment1

 

Attachment Point B

Converted to sublimit in user interface

tLayerCondition.Attachment2

 

Attachment Point C

Converted to sublimit in user interface

tLayerCondition.Attachment3

 

Attachment Point D

Converted to sublimit in user interface

tLayerCondition.Attachment4

 

Premium

Premium

tLayer.Premium

 

 

© 2016 AIR Worldwide. All rights reserved.

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

Touchstone 3.0 Updated December 02, 2016