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.

If you import Japanese exposures into Touchstone 5.1, and the First Floor Height, Custom Elevation, and Custom Flood Standard of Protection fields contain zeroes, Touchstone 5.1 calculates anomalous losses for those fields. This is because 5.1 treats those elevation values as true zeroes (therefore, as '0' feet). To resolve this, delete the zeroes from those fields before importing into Touchstone 5.1. You can also contact AIR for an SQL script that can update imported data when the fields are accidentally imported with zeroes in those fields.

 

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

 

 

© 2020 AIR Worldwide. All rights reserved.

Touchstone 7.0 Updated September 03, 2020