Export exposure views to a database

You can export one or more exposure views to a single new or existing CEDE 2.0 database for further analysis or review.

Since exposure views can contain one or more exposure sets, this function enables you to merge the exposure sets in an exposure view into a single exposure set. For example, Exposure View A contains three exposure sets (1, 2, and 3) on database X. When you export Exposure View A to database Y, the copy of Exposure View A will contain a single exposure set, which contains all three exposure sets that are in Exposure View A.

Contract IDs must be unique in an exposure set. Therefore, if there are duplicate contracts in the exposure sets that you are exporting, the system appends a suffix to the contract ID. For example, "ContractID129383" becomes "ContractID129383_2". Changing the contract ID does not affect the contract's layers, sublimits, reinsurance, or locations.

The exported exposure views maintain the same structure as the source exposure views except that they reside on a single database. In addition, since Exposure to Database copies the exposure sets within the selected exposure views, any filters that were applied to the selected exposure views are reflected in the copied exposure sets.

Procedure

  1. Choose one of the following methods to run Exposure to Database:
    • On the global menu bar, select Export > Exposure > Exposure to Database.
    • In the Exposure Views grid, right-click on an exposure view and select Exposure to Database.
    ExportExpress opens. If you launched it from the exposure views grid, the exposure type and view are already selected. Note that ExportExpress does not include results from deleted databases in the grid. For more information, see About ExportExpress
  2. On the Source Exposure tab, select the exposure view to export.
  3. Under Broker Options, select the following options:
    OptionDescription
    Excluded Insured Name Excludes the name of the insured from the exported exposure view or views.
    Excluded Premium Excludes premium information from the exported exposure view or views.
    Export Exposure Views as Single Exposure Sets Export each selected exposure view as a single exposure set. The newly created single exposure sets will have the same name as the exported exposure views. If an exposure set already exists, Exposure to Database appends a unique numeric identifier to the name of the exposure set, as in "ExpViewA_2".
    Exclude User Defined Fields (UDFs) Removes all five contract and five location UDF fields. This enables brokers to make the data anonymous before sending it to reinsurers.
  4. Select the Options tab and then:
    1. In the Database Optimization area, to minimize the size of the target database, select the Shrink database and/or the Disable index on destination database options.
    2. In the Database Performance area, select Re-index database if you want to re-index the database.
      You must select this option if the target exposure database will reside on the same SQL instance. It is not necessary to re-index the database if you plan to use the target exposure database in a new or different Touchstone environment by using the feature in the Data Source Manager.
  5. Specify the destination for the exported data.
  6. [Optional] Clear the Close on Export check box to keep ExportExpress open after you submit the export job.
  7. Click Export.