Home
Import
Import exposure data from external sources into Verisk databases.
China disaggregation
Use the China Disaggregation tool to import exposures and programs for mainland China.
Import China programs
Import and disaggregate China agriculture programs into Touchstone Re.

Introduction
Introduction to the Touchstone Re application.
Companies
A company is unique entity in Touchstone Re.
Company data (exposures)
Companies are associated with exposure data.
Programs
A program is integral to a company and it's exposure data in Touchstone Re.
Portfolios
A portfolio is a group of treaties selected from across companies.
Import
Import exposure data from external sources into Verisk databases.
- Exposures
  Import exposures.
- Import company loss file
  The default import type is "Company Loss File (CLF)".
- Import a company
  You can import a company or set of companies to a shared network location that is accessible to Touchstone Re.
- File types
  You can import a number of file types into Touchstone Re.
- China disaggregation
  Use the China Disaggregation tool to import exposures and programs for mainland China.
  - Import China exposure
    Import China exposures for disaggregation.
  - China exposure disaggregation
    China exposure disaggregation takes exposure at province or city resolution down to county resolution using a weighted average by line of business from the Industry Exposure Database.
  - Import China programs
    Import and disaggregate China agriculture programs into Touchstone Re.
  - China program disaggregation
    China program disaggregation imports only programs for mainland China that include the agriculture peril.
- AM Best premiums
  AM Best premiums can be imported into Touchstone Re as a single data file.
- Import ALERT data
  Import ALERT data into Touchstone Re.
Export
Export exposure data, results, reports, and companies out of Touchstone Re.
Loss results
The Loss Results pane for a company lists all loss analyses that have been executed for the company.
Analysis
An analysis in Touchstone Re is a probabilistic analysis of your aggregated loss or exposure data.
Tools
Tools to manage Touchstone Re and its data.
Administration console
The Administration Console enables authorized users to manage a suite of administrative tasks.
Reference
Supporting information on various topics associated with Touchstone Re.

Import China programs

Import and disaggregate China agriculture programs into Touchstone Re.

Import > China Disaggregation > Programs

Procedure

From the Touchstone Re global menu, select Import > China Disaggregation.
Select Program and then:
1. Enter the name and network (UNC) location of the target input file, or click , navigate to the shared network location containing the input file, select the file, and then click Open.
2. Verify that the peril is set to MPCI (Agri); other selections are not valid for China Disaggregation.
3. Select a data type: Sums Insured,Premiums, or Risks.
In the Destination area, enter a company name or select one from the list.
Optionally, clear the Close after Import check box if you want to continue importing items.
Click Verify to check the data.

If a warning message appears, click it for information.
Click Import.

All valid rows are disaggregated to county level when Disaggregate = 1 in the source file; a message box displays the number of counties added to the database.
If applicable, click Close to exit ImportExpress.

Results

The task appears in the Activity Monitor queue.