Exporting Loss Results To Company Loss Files

You can export loss results to company loss files (CLFs) by line of business (LOB), area, and subarea, for each event included in an analysis. You can subsequently use the CLFs to run analyses in Touchstone Re if you license the applications.

You have three options for saving the exported CLF:

  1. Save the CLFs in a directory that is accessible to Touchstone.

  2. Save the CLF data in the AIRCompanyLoss database, which is accessible to both Touchstone and Touchstone Re.

  3. Do both 1 and 2.

Option 2 enables you to transfer CLFs directly to Touchstone Re rather than exporting and then importing the files.

A CLF comprises:

  • Two encoded files (*.clf and *.evt) and

  • A summary file (*.evi) that describes the data in the two encoded files

For each peril, model, and loss type combination in the loss results, Touchstone generates a one set of encoded files (*.clf and *.evt). Peril and model combinations share the summary *.evi files for each loss types.

The names of related files include a prefix that you specify.

CLFs are especially useful for analyzing non-standard books with unusually high deductibles or unique geographic concentrations, per risk and surplus share treaties, and facultative contracts.

You can export losses that were saved by layer & geography and by layer & location if the geographic resolution is equal to or finer than the sub area resolution.

If you selected the Maximum Any One Life (MAOL) option when you configured the loss analysis, Touchstone generates separate files for each selected MAOL limit.

You can view and export loss results from previous product versions. However, if the event IDs or LOBs have have changed since Touchstone generated the losses, the exported report does not include the IDs or LOBs. If the version of the product, catalog, and model appropriately marked and the event IDs have not changed, Touchstone Re can accept CLFs from the preceding version of a model.

Touchstone exports loss results in the *Saved Currency with one exception:

  • UF losses: You can import exposures coded as UF (Unidad de fomento) into Touchstone without issue. However, when you export a CLF, Touchstone converts UF to CLP, which is a currency supported in Touchstone Re. UF and CLP are different currencies. Therefore, you should consider consistency among the rates when you create currency tables.

Procedure

To export loss analysis results to a Company Loss File:

  1. On the global menu, click Export > Results > Company Loss File (CLF)/Associate Loss File.
  2. On the Source Results tab:
    1. Select the analysis to export.
    2. Optionally, in the Comments field, provide some information about the export job.
    3. In the Number of Cores fields, specify minimum and maximum number of cores to use.
      Note:

      AIR ExportExpress does not include results from deleted databases in the grid.

  3. On the Options tab:
    1. Select the financial perspectives and treaty losses to export.

      Touchstone generates a separate CLF for each perspective.

      You can scroll down the list to view additional options.

    2. If you included MAOL in the output, optionally select MAOL to include the MAOL data in the CLF.
    3. In the Target area, specify whether to export a CLF for 10,000 years, 50,000 years, or 500,000 years.
      Note:

      The Perils Detected in Analysis section displays the perils included in the analysis. You cannot use the perils as export filters.

  4. On the LOB Mapping tab, map each unrecognized, user-specified LOB in the loss results to an industry LOB:

    • To map all the user-specified LOBs to one industry LOB, select an LOB in the Set All Countries To field, and then click Apply.

      Touchstone applies the LOB you selected for all countries where the LOB is valid.

    • Alternatively, click each Industry LOB cell, and then select an LOB.

    Tip:

    You can select the row for a user-specified LOB, and then click the Expand icon to view more information about the LOB.

    Tip:

    You can copy and paste an industry LOB value by highlighting the value, right-clicking, and then selecting Copy or Paste on the shortcut menu.

    Ensure that any pasted value is valid for the corresponding country.

  5. [Optional] Select Associate Loss to Company and then specify the details of the Touchstone Re company to transfer the losses to.
  6. [Optional] select Save to CLF and then specify the destination path for the exported data.
  7. Enter a base file name, up to 260 characters.

    The export will fail if the base file name is greater than 260 characters.