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