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 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, 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 |