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.
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.
China exposure source file guidelines
The exposure source file is used to input China exposures.
China exposure data and format validation
The content of the China exposure source file must follow specific guidelines.

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.
    - China exposure source file guidelines
      The exposure source file is used to input China exposures.
      - China exposure data and format validation
        The content of the China exposure source file must follow specific guidelines.
      - Exposure disaggregation sample input file
        Simple input file for China agriculture exposures.
      - China exposure disaggregation options without exclusions
        Standard disaggregation of China exposure data without exclusions will occur as outlined in the table below.
  - 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.

China exposure data and format validation

The content of the China exposure source file must follow specific guidelines.

All content

All fields must be formatted as "text" regardless of content type.
The disaggregation process ignores: blank rows, case, spaces before and after data.

Header

The header row must be the first row following the currency specifications in the worksheet.
All header fields are mandatory; while disaggregation supports hidden columns, it does not support missing columns.
Column order and spelling are validated against the specifications in the Exposure Source File.

Include and exclude

Province and county are validated against names in the area code database; refer to the Touchstone Re Database Reference on Verisk's Developer Zone.
Include
- Field must contain valid data which must be one area only: province, city, or county.
- When it contains a city name the Disaggregate field must be set to 1 (disaggregate).
- Valid site names are listing in the posting Country Abbreviations on Client Portal.

Exclude
- Field must contain areas at higher resolution than the Include field if disaggregation is enabled.
- Supports semi-colons to list multiple areas.
- May contain mixed-resolution entries (e.g. a city and a county).
- May contain area that is two resolution levels away from the Include area.
- May contain overlapping areas.
- May contain a subset of the Include area.

Exposure

Only positive numeric values are valid.
At least one exposure field, relevant to the peril selected, must contain a value.

Disaggregate

Field must include either 0 (do not disaggregate) or 1 (disaggregate).
Field must be set to 1 (disaggregate) when Include field contains a city name.