Column Heading Automapping for Contract CSV Files

In the table below, the Touchstone Column Name column identifies the default contract-related column names available in the Touchstone user interface, while the Acceptable CSV Column Names column identifies alternative column names. If you use any of these acceptable alternative column names in your CSV import files, Touchstone recognizes and automaps the corresponding columns correctly. The table also identifies the policy type to which each column applies. Touchstone column names may vary by contract type or country.

Click here for information about policies and certificates.

Section in List of Touchstone Column Names

Touchstone Column Name

Acceptable CSV Column Names

Primary Property (PP) Contract

Primary Workers' Compensation (PWC) Contract

Facultative Property (FP) Contract

Facultative Workers' Compensation (FWC) Contract

Policy (for Primary policies); Certificate (for Facultative policies)

Contract ID

ContractID, PolicyID, or CertificateID

X

X

Certificate ID

CertificateID, PolicyID, or ContractID

X

X

Insured Name

InsuredName

X

X

X

X

Producer Name

Producer, ProducerName

X

X

Underwriter

Underwriter

X

X

Branch Name

Branch

X

X

ID of Expiring Contract

ExpiringContract

X

X

Status

Status, SubmitStatusCode

X

X

X

X

Currency

Currency

X

X

X

X

Inception Date

InceptionDate, EffectiveDate

X

X

X

X

Expiration Date

ExpirationDate

X

X

X

X

Perils

Perils

X

X

X

X

Line of Business

LOB

X

X

X

X

Policy Form

Form

X

X

User-Defined Field 1 (UDF 1)

UDF1

X

X

X

X

User-Defined Field 2 (UDF 2)

UDF2

X

X

X

X

User-Defined Field 3 (UDF 3)

UDF3

X

X

X

X

User-Defined Field 4 (UDF 4)

UDF4

X

X

X

X

User-Defined Field 5 (UDF 5)

UDF5

X

X

X

X

Layer

Note:

Limits A, B, C, and D are for offshore locations only and are converted to XML format during import. The values in these limits fields indicate the priority of the exhaustion sequence.

Layer ID

LayerID

X

X

X

X

Layer Perils

LayerPerils

X

X

X

X

Limit Type

LimitType

X

X

X

X

Total Limit (Limit 1)

Limit1, Total Limit., 100LayerAmt

X

X

X

X

Participation Limit (Limit 2)

Limit2, Participation Limit, PartLayerAmt, Participation Limit

X

X

X

X

Deductible Type

DedType, Deductible Type

X

X

X

X

Deductible Amount 1

DedAmt1, Deductible Amount 1

X

X

X

X

Deductible Amount 2

DedAmt2, Deductible Amount 2

X

X

X

X

Attachment Amount

AttachmentAmt

X

X

Facultative Attachment Amount

FacAttachAmt

X

X

Premium

Premium

X

X

X

X

AssumedAmount

AssumedAmt

X

X

Limit A

LimitA

X

X

Limit B

LimitB

X

X

Limit C

LimitC

X

X

Limit D

LimitD

X

X

Attachment Point A

AttachmentPtA, AttachmentA

X

Attachment Point B

AttachmentPtB, AttachmentB

X

Attachment Point C

AttachmentPtC, AttachmentC

X

Attachment Point D

AttachmentPtD, AttachmentD

X

Currency

Currency

Sublimit

Perils

SublimitPerils

X

X

X

X

Sublimit Area

SublimitArea

X

X

X

X

Limit Type

SubLimitLimitType

X

X

X

X

Sublimit Total Limit (Limit 1)

SubLimitOcc

X

X

X

X

Sublimit Participation Limit (Limit 2)

SublimitPart

X

X

X

X

Total Limit Building

SublimitLimitA

X

X

Total Limit Other

SublimitLimitB

X

X

Total Limit Contents

SublimitLimitC

X

X

Total Limit Time

SublimitLimitD

X

X

Deductible Type

SublimitDedType

X

X

X

X

Deductible Amount 1

SublimitDedAmt1

X

X

X

X

Deductible Amount 2

SublimitDedAmt2

X

X

X

X

Attachment Point Amount

SublimitAttachAmt

Attachment Point Building

SublimitAttachA

X

X

X

Attachment Point Other

SublimitAttachB

X

X

X

Attachment Point Contents

SublimitAttachC

X

X

X

Attachment Point Time

SublimitAttachD

X

X

X

Assumed Amount

SublimitAssumedAmt

X

Participating Layer Amount

SublimitPartLayerAmt

X

X

100% Layer Amount

Sublimit100LayerAmt

X

X

Facultative Attachment Amount

SublimitAttachA, SublimitAttachAmt

X

X