Home
Tools
Tools to manage Touchstone Re and its data.
China agriculture custom ILFs
Tool to manage custom Industry Loss Files (ILFs).
China agriculture custom policy file format
A China agriculture custom ILF is generated from a custom client-supplied policy file, a CSV file of the following specific format.

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.
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.
- Activity monitor
  Use the Activity Monitor to view the status of and to manage Touchstone Re activities.
- Data source manager
  The Data Source Manager enables you to manage Touchstone Re databases.
- CLF combiner
  Steps to combine loss files.
- About the Company Loss Set Cleanup tool
  This tool can help manage your loss sets (CLF, CLA).
- Convert to binary ULF
  Steps to convert CSV loss files to binary ULF files.
- Convert event distribution
  Clients can now import event level losses (YELTs), received from their respective clients, into Touchstone Re.
- Convert EP to ULF
  Import one or more EP summary curves (with flexible geography and peril combinations) to create a loss file package based on catalogs that can then be attached to any program for analysis with reinsurance terms.
- China agriculture custom ILFs
  Tool to manage custom Industry Loss Files (ILFs).
  - China agriculture custom policy file format
    A China agriculture custom ILF is generated from a custom client-supplied policy file, a CSV file of the following specific format.
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 agriculture custom policy file format

A China agriculture custom ILF is generated from a custom client-supplied policy file, a CSV file of the following specific format.

Columns

These 19 column headers must exist in the first row with these exact titles:

Province
LOB
Crop-AllPerils-Franchise
Crop-AllPerils-Deductible
Drought-Franchise
Drought-Deductible
Flood-Franchise
Flood-Deductible
Wind-Franchise
Wind-Deductible
Frost-Franchise
Frost-Deductible
Heat-Franchise
Heat-Deductible
Livestock-Weather-Franchise
Livestock-Weather-Deductible
Livestock-Disease-Franchise
Livestock-Disease-Deductible
Livestock-Indemnity-Fraction-Culling

Rows

Province: must be a valid China province.
LOB: must be a supported crop, forest, or livestock type
Deductible: must be a number between 0 and 1, inclusive.

Required for each row

Province
LOB
If the LOB is a crop: one complete pair of terms for a crop sub-peril (e.g. Drought-Franchise + Drought-Deductible).
If the LOB is a livestock: one complete set of terms for a livestock sub-peril (e.g. Livestock-Weather-Franchise + Livestock-Weather-Deductible OR, Livestock-Disease-Franchise + Livestock-Disease-Deductible + Livestock-Indemnity-Fraction-Culling).

Optional for each row

If LOB is a crop: other franchise and deductible pairs (including AllPerils).
If LOB is a livestock: the other sub-peril terms .

Other validation rules

Must have at least one row.
Province + LOB combinations must be unique (e.g., cannot have two rows for Beijing corn).
Peril-specific deductibles must be in pairs for a given peril (e.g., if Drought-Franchise is present, the Drought-Deductible must be also be present).
- For Livestock-Disease, all three are required (Franchise, Deductible, and Culling Fraction).