Location Terms Fields for Import

The table below lists 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.

 

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

You can define multiple coverage term sets for a location, each one based on a unique combination of peril, limits, and deductibles. 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. When importing locations, you can define multiple coverage term sets for a location by appending a numeric suffix, such as "1" or "-1," at the end of each field in each term 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.

You can add term sets from the Terms tab located at the bottom of the Locations tab. To add one or more term sets, open a contract, select the Terms tabs, and then click Add Term Set. Touchstone adds the term set columns at the far right of the Terms tab. As you scroll, you will see the identifier for each set of terms: Term 2, Term 3, Term 4, Term 5, and Term 6. You cannot add a new term set if any location in the grid has six term sets. If, however, a location has less than six terms while another location in the same contract has six terms, you can add a new term set by clicking a location ID and manually adding terms in the Terms grid in the Location Details pane.

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 Plus (+) symbol, such as, 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

 

 


© 2019 AIR Worldwide. All rights reserved.

Touchstone 5.0 Updated January 17, 2019