Location terms fields for import

In ImportExpress, you map .csv import data to valid Touchstone fields for location terms fields.

This table lists the import field and the Touchstone user interface location field and database field that correspond to each location term import field, for primary or facultative property locations. Import fields are in italic font because the field name is variable.
Note:

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 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 in an import file, separate the corresponding peril codes with a plus symbol (+). For example, enter 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 1 Participation 1 tLocTerm.Participation1
Participation 2 (primary only) Participation 2 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
Note: Touchstone does not store locations with sublimit areas. Instead, tLayerConditionLocationXref contains links between sublimits and locations.
n/a n/a n/a
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