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

 

 


© 2020 AIR Worldwide. All rights reserved.

Touchstone 7.0 Updated September 03, 2020