Primary 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 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.

 

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 Plus (+) symbol, such as, 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. 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

If the value in this column is less than or equal to 1, AIR 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 (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

 

 


© 2019 AIR Worldwide. All rights reserved.

Touchstone 5.0 Updated January 17, 2019