Location Terms Fields for Import

 

The table below lists all the Touchstone terms fields to which you can map comma-separated values (CSV) import data for primary or facultative property locations. In addition, this table lists the Touchstone user interface field and database field that correspond to each import field and provides a link to the description of and validation rules for each import field.

 

Please note that AIR ImportExpress rounds all imported monetary values to the nearest whole number if these values contain decimal places.

You can use define multiple coverage term sets for a location, each one based on a unique combination of peril, limits, and deductibles. Note that you can include a particular peril only once in the entire series of coverage term sets for a location. When you use AIR ImportExpress to import locations, you can define up to six coverage term sets for each location. This limit does not exist when you define coverage term sets for a location using the Touchstone user interface. To define multiple coverage term sets for a location, append a numeric suffix, such as "1" or "-1," at the end of each field in each set. For example, to import a location with two coverage term sets, you can specify "LocPerils1" in the first coverage term set and "LocPerils2" in the second coverage term set.

Import Field

User Interface Field

Database Field

Required

Location Perils

Perils

  To specify multiple perils in a single entry within an import file, separate the corresponding peril codes with a + symbol (e.g., PWH+PES).

tLocTerm.PerilSetCode

 

Limit Type

Limit Type

tLocTerm.LimitTypeCode

 

Limit Building

Limit Building

tLocTerm.Limit1

 

Limit Other

Limit Other

tLocTerm.Limit2

 

Limit Contents

Limit Contents

tLocTerm.Limit3

 

Limit Time

Limit Time

tLocTerm.Limit4

 

Participation (0-1) (primary) / Certificate Participation (facultative)

Participation 1 (0-1)

tLocTerm.Participation1 / tLocTerm.CededAmount

 

Participation 2 (0-1) (primary only)

Participation 2 (0-1) (Primary only)

tLocTerm.Participation2

 

Deductible Type

Deductible Type

tLocTerm.DeductibleTypeCode

 

Deductible Building

Deductible Building

tLocTerm.Deductible1

 

Deductible Other

Deductible Other

tLocTerm.Deductible2

 

Deductible Contents

Deductible Contents

tLocTerm.Deductible3

 

Deductible Time

Deductible Time

tLocTerm.Deductible4

 

Sublimit Area

Touchstone does not store locations with sublimit areas. Rather, the tLayerConditionLocationXref table contains the links between the sublimits and the locations.

 

Limit Physical Damage (primary offshore platforms only)

Limit Physical Damage

tLocTerm.Limit1

 

Limit Removal of Debris (primary offshore platforms only)

Limit Removal of Debris

tLocTerm.Limit2

 

Limit Operator's Extra Expense (primary offshore platforms only)

Limit Operator's Extra Expense

tLocTerm.Limit3

 

Limit Business Interruption (primary offshore platforms only)

Limit Business Interruption

tLocTerm.Limit4

 

Assured Interest (primary offshore platforms only)

Assured Interest

tLocTerm.Participation1

 

Working Interest (primary offshore platforms only)

Working Interest

tLocTerm.Participation2

 

 

© 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