Contract List

The following table details the validation rules for Touchstone fields related to contracts:

Field

Description

Validation Rules

Default Value

Contract ID

Unique, required, user-defined contract identifier

•       Required if you are creating a new record or editing an existing record

•       Contract IDs must be unique.

•       Cannot begin with a space or contain commas or semicolons

•       Can contain up to 100 characters

 

Contract Type

One of the following contract types:

•       Primary Property

•       Facultative Property

•       Primary Workers' Compensation

•       Facultative Workers' Compensation

Defaults to a value in the Touchstone user interface

Primary Property

Exposure Set

Unique identifier for the exposure set to which this contract belongs

Read only

 

Insured Name

Name of the insured party

•       Optional

•       Must be unique for the Book

•       Can contain up to 60 characters

 

Producer Name

Name of the producer

•       Optional

•       Can contain up to 60 characters

 

Underwriter

Name of the underwriter

•       Optional

•       Can contain up to 60 characters

 

Branch

Name of the branch

•       Optional

•       Can contain up to 60 characters

 

ID of Expiring Contract

ID of the expiring contract

•       Optional

•       Can contain up to 100 characters

 

Terms Currency

Base currency for this contract

 

For analysis at the contract level, Touchstone converts all locations to this base currency.

 

See the list of valid currency codes.

Defaults to a value in the Touchstone user interface

US Dollar (USD)

Currency Exchange Rate

Currency exchange rate

Read only

 

Inception Date

Date of the first day on which coverage is effective

 

When importing data, use one of the following formats and select this format in the Options tab of AIR ImportExpress:

•       MM/DD/YYYY

•       DD/MM/YYYY

•       YYYYMMDD

•       YYYY-MM-DD

•       Required if you are creating a new record or editing an existing record

•       Defaults to a value in the Touchstone user interface

•       Date format is specific to locale of end user

•       Must be less than the expiration date

 

For inception and expiration dates, and other in-force dates, you must specify a date value between 01/01/1970 and 12/31/2038, inclusive, for dates based on US regional settings. If you are not using US regional settings, use a date value other than 01/01/1970, such as 01/01/1990.

1/1/[current year]

Expiration Date

Date of the last day on which coverage is effective

 

When importing data, use one of the following formats and select this format in the Options tab of AIR ImportExpress:

•       MM/DD/YYYY

•       DD/MM/YYYY

•       YYYYMMDD

•       YYYY-MM-DD

•       Required if you are creating a new record or editing an existing record

•       Defaults to a value in the Touchstone user interface

•       Date format is specific to locale of end user

•       Must be greater than the inception date

 

For inception and expiration dates, and other in-force dates, you must specify a date value between 01/01/1970 and 12/31/2038, inclusive, for dates based on US regional settings. If you are not using US regional settings, use a date value other than 01/01/1970, such as 01/01/1990.

12/31/[current year]

Status

One of the following contract submission statuses:

•       Bound

•       Cancelled

•       Expired

•       Quoted

•       Rejected

•       Renewal

•       Submitted

Defaults to a value in the Touchstone user interface

Submitted

Perils

Perils insured under this contract

 

See the list of valid peril codes.

  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).

Defaults to a value in the Touchstone user interface

All perils (PAL)

Policy Form

User defined policy form assigned to this contract

•       Defaults to a value in the Touchstone user interface

•       Can contain up to 60 characters

Unknown

Line of Business

User-specified line of business

•       Defaults to a value in the Touchstone user interface

•       Lines of business should be unique between property and workers' compensation if you need to see data separately for property and workers' compensation.

•       Can contain up to 60 characters

Unknown

Location Count

Number of locations in this contract

Read only

 

Layer Count

Number of layers in this contract

Read only

  

Layer Level Reinsurance Count

Number of reinsurance treaties in the layer(s) for this contract

Read only

  

Location Level Reinsurance Count

Number of reinsurance treaties associated with the location(s) that this contract covers

Read only

  

Step Function

One of the following values to Indicate whether this contract includes a step function:

•       Yes

•       No

Read only

  

Total Replacement Value

Total replacement value for each contract

•       Defaults to a value in the Touchstone user interface, provided that an exposure summary has been generated for the exposure view.

•       The TRV changes if you change the Display Currency settings on the Project ribbon.

  

TRV Currency

The currency used to calculate the TRV

•       Defaults to the currency selected when the exposure view was created.

•       Touchstone dynamically converts all location TRVs using the exposure view currency and conversion rate; it does not store these values in the database.

 

User Defined Field (UDF) 1

User defined field #1

 

Used for purposes of aggregation

•       Optional

•       May be alphanumeric and may include hyphens and underscores

•       Can contain up to 60 characters

 

User Defined Field (UDF) 2

User defined field #2

 

Used for purposes of aggregation

•       Optional

•       May be alphanumeric and may include hyphens and underscores

•       Can contain up to 60 characters

 

User Defined Field (UDF) 3

User defined field #3

 

Used for purposes of aggregation

•       Optional

•       May be alphanumeric and may include hyphens and underscores

•       Can contain up to 60 characters

 

User Defined Field (UDF) 4

User defined field #4

 

Used for purposes of aggregation

•       Optional

•       May be alphanumeric and may include hyphens and underscores

•       Can contain up to 60 characters

 

User Defined Field (UDF) 5

User defined field #5

 

Used for purposes of aggregation

•       Optional

•       May be alphanumeric and may include hyphens and underscores

•       Can contain up to 60 characters

 

 

© 2019 AIR Worldwide. All rights reserved.

Touchstone 5.0 Updated July 09, 2019