Constructing a .csv policy file

Follow these guidelines for creating a .csv policy (contracts) file.

Procedure

  1. Launch a spreadsheet program or open a text editor.
  2. Enter a row of data to represent a policy (contract or account).
    The file must contain at least one policy.
  3. [Optional] To add a layer to this policy, append the layer-specific fields to the same row that contains the policy data.
  4. To include additional layers for this policy, copy the policy data from the existing policy/layer row into a new row within the file, and then append the layer-specific fields for this new layer to the same row that contains the copied policy data.
    The copied policy data links the layer to the policy. Including the policy data in multiple layer rows in this way does not result in duplicate policies within Touchstone.
  5. Repeat the previous step for any additional layers that you want to include.
  6. [Optional] To add a sublimit for any layer within this policy, append the sublimit-specific fields to the same row that contains the policy and layer information.
  7. To include additional sublimits for any layer within this policy, copy the policy and layer data from the layer row into a new row within the file, and then append the sublimit-specific fields for this new sublimit to the same row that contains the copied policy and layer information.
    The copied policy and layer data links the sublimit to the layer and policy. Including the policy and layer data in multiple sublimit rows in this way does not result in duplicate policies or layers within Touchstone.
  8. [Optional] Repeat the previous step for any additional sublimits that you want to include.
  9. [Optional] To include multiple policies in this file, repeat this procedure for each additional policy that you want to include.

Sample contracts File

The following example shows an excerpt from a sample contracts file: