Facultative property or workers' compensation contract certificate fields for import

In ImportExpress, you map .csv import data to valid Touchstone fields for facultative property or workers' compensation contract certificate fields.

This table lists the import field and the Touchstone user interface field and database field that correspond to each import field. Import fields are in italic font because the field name is variable.

Import field User interface field Database field Required?
Certificate ID Contract ID tContract.ContractID Required
Insured Name Insured Name tContract.InsuredName Required
Status Status tContract.SubmitStatusCode
Currency Currency tContract.CurrencyCode
Inception Date Inception Date tContract.InceptionDate
Expiration Date Expiration Date tContract.ExpirationDate
Perils Perils
Note: To specify multiple perils in a single entry within an import file, separate the corresponding peril codes with a Plus (+) symbol. For example: PWH+PES.
tContract.PerilSetCode
Line of Business Line of Business tContract.UserLineofBusiness
User Defined Field 1 (UDF 1) User Defined Field (UDF) 1 tContract.UserDefined1
User Defined Field 2 (UDF 2) User Defined Field (UDF) 2 tContract.UserDefined2
User Defined Field 3 (UDF 3) User Defined Field (UDF) 3 tContract.UserDefined3
User Defined Field 4 (UDF 4) User Defined Field (UDF) 4 tContract.UserDefined4
User Defined Field 5 (UDF 5) User Defined Field (UDF) 5 tContract.UserDefined5