Facultative Property or Workers' Compensation Contract Certificate Fields for Import
The table below lists the Touchstone certificate fields to which you can map comma-separated values (CSV) import data for facultative 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 |
|---|---|---|---|
|
Certificate ID |
tContract.ContractID |
Required |
|
|
Insured Name |
tContract.InsuredName |
Required |
|
|
Status |
tContract.SubmitStatusCode |
||
|
Currency |
tContract.CurrencyCode |
||
|
Inception Date |
tContract.InceptionDate |
||
|
Expiration Date |
tContract.ExpirationDate |
||
|
Perils |
Note:
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). |
tContract.PerilSetCode |
|
|
Line of Business |
tContract.UserLineofBusiness |
||
|
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 |