Primary Property or Workers' Compensation Contract Policy Fields for Import |
The table below lists the Touchstone policy fields to which you can map comma-separated values (CSV) import data for primary property or primary workers' compensation contracts. 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.
Import Field |
User Interface Field |
Database Field |
Required |
||
Contract ID |
tContract.ContractID |
Required |
|||
Insured Name |
tContract.InsuredName |
Required |
|||
Producer Name |
tContract.ProducerName |
|
|||
Underwriter |
tContract.Underwriter |
|
|||
Branch Name |
tContract.Branch |
|
|||
ID of Expiring Contract |
tContract.ExpiringContractID |
|
|||
Status |
tContract.SubmitStatusCode |
|
|||
Currency |
tContract.CurrencyCode |
|
|||
Inception Date |
tContract.InceptionDate |
|
|||
Expiration Date |
tContract.ExpirationDate |
|
|||
Perils |
|
tContract.PerilSetCode |
|
||
Line of Business |
tContract.UserLineofBusiness |
|
|||
Policy Form |
tContract.PolicyForm |
|
|||
User Defined Field 1 (UDF 1) |
tContract.UserDefined1 |
|
|||
User Defined Field 2 (UDF 2) |
tContract.UserDefined2 |
|
|||
User Defined Field 3 (UDF 3) |
tContract.UserDefined3 |
|
|||
User Defined Field 4 (UDF 4) |
tContract.UserDefined4 |
|
|||
User Defined Field 5 (UDF 5) |
tContract.UserDefined5 |
|
© 2019 AIR Worldwide. All rights reserved. Touchstone 5.0 Updated July 09, 2019 |