Importing Exposure Data


AIR ImportExpress™ has robust import capabilities that enable you to import contract and exposure data from external sources into AIR Touchstone databases, regardless of the format of the source. Touchstone supports the import of real and personal property exposure data and workers' compensation exposure data. When you import workers' compensation exposure data, you can analyze losses that result from earthquakes (U.S. Earthquake Model [M11]) or acts of terrorism (AIR Terrorism Loss Estimation Model [M01]) in the United States, and you can model Personal Accidents (PA) covered by the Japan Earthquake Model (M52). Click here for information about the differences between Property exposure data and Workers' Compensation exposure data.

  You must license Workers' Compensation if you want to include the workers' compensation exposure data in a loss analysis.

A key business need is to manage worldwide exposure with hazard and event data, regardless of whether there is a model for a particular region or peril. AIR ImportExpress supports the import of exposure data for non-modeled regions with CRESTA support, non-modeled regions without CRESTA data, and non-modeled perils—it preserves all user-provided geographic (including user-provided geocodes) and peril information. After importing non-modeled exposures, you can edit and save the exposure data. Click here for a table that lists ISO country codes supported by Touchstone; the table also notes which countries are modeled or not modeled in Touchstone.

AIR ImportExpress supports the following data formats:

         Almost any custom, client-specific data format saved as a text file

         AIR's open-source data formats, UNICEDE® (PX/FX)

         RMS-EDM exposure databases

         Standardized industry exposure data formats (ACORD Binding Authority) (Touchstone does not support ACORD reports of workers' compensation fields.)

       AIR CEDE 1.0 databases created for use with CLASIC/2

  There is a maximum file size of two gigabytes (GB) when you import UPX and CSV files.

AIR ImportExpress automatically geocodes any locations that have not been geocoded, that is, locations without latitude and longitude values. For more information, see Using Geocoding in Touchstone, which is available on the AIR Client Portal.

Construction and Occupancy Codes

Construction and occupancy codes are included in location-level exposure data. The loss analysis engine uses the codes to determine which damage functions to apply for each location. Therefore, it is important for the engine to use the correct set, or pair, of codes. AIR ImportExpress does not validate construction/occupancy pairs during import; even if a pair is invalid, AIR ImportExpress passes the codes to the Location database. However, AIR ImportExpress does validate individual construction and occupancy codes against valid AIR codes and does not import locations with those invalid codes. The rejection file for the import contains information about the locations that were not imported. Further, AIR ImportExpress determines whether individual construction and occupancy codes are valid for specific countries. If a code is invalid for the country associated with the exposure to which the code is assigned, AIR ImportExpress imports the location with the invalid code(s) and enters a warning in the Import log. The following example shows a sample log entry for three invalid codes, specified in the Business Errors section of the log:

ConstrA | Business Validation Warning: [Contract Id: US Loc ID: PharmacyX] Combination Construction Building '105' Country 'United States' is invalid

ConstrB | Business Validation Warning: [Contract Id: US Loc ID: PharmacyX] Combination Construction Other '105' Country 'United States' is invalid

Occupancy | Business Validation Warning: [Contract Id: US Loc ID: PharmacyX] Combination Occupancy Code '307' Country 'United States' is invalid

  For information about configuring the loss analysis engine to ignore invalid pairs or use the system default during a detailed loss analysis, see Invalid Construction/Occupancy Pairs.



© 2016 AIR Worldwide. All rights reserved.

Click here for information about AIR Worldwide, including copyright, trademarks, confidentiality, and contact information.

Touchstone V3.0 Updated December 01, 2016