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 |
|
tLocTerm.PerilSetCode |
|
||
Limit Type |
tLocTerm.LimitTypeCode |
|
|||
Limit Building |
tLocTerm.Limit1 |
|
|||
Limit Other |
tLocTerm.Limit2 |
|
|||
Limit Contents |
tLocTerm.Limit3 |
|
|||
Limit Time |
tLocTerm.Limit4 |
|
|||
Participation 1 (primary) / Certificate Participation (facultative) |
tLocTerm.Participation1 / tLocTerm.CededAmount |
|
|||
Participation 2 (primary only) |
tLocTerm.Participation2 |
|
|||
Deductible Type |
tLocTerm.DeductibleTypeCode |
|
|||
Deductible Building |
tLocTerm.Deductible1 |
|
|||
Deductible Other |
tLocTerm.Deductible2 |
|
|||
Deductible Contents |
tLocTerm.Deductible3 |
|
|||
Deductible Time |
tLocTerm.Deductible4 |
|
|||
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) |
tLocTerm.Limit1 |
|
|||
Limit Removal of Debris (primary offshore platforms only) |
tLocTerm.Limit2 |
|
|||
Limit Operator's Extra Expense (primary offshore platforms only) |
tLocTerm.Limit3 |
|
|||
Limit Business Interruption (primary offshore platforms only) |
tLocTerm.Limit4 |
|
|||
Assured Interest (primary offshore platforms only) |
tLocTerm.Participation1 |
|
|||
Working Interest (primary offshore platforms only) |
tLocTerm.Participation2 |
|
© 2020 AIR Worldwide. All rights reserved. Touchstone 7.0 Updated September 03, 2020 |