Column heading automapping for step function .csv Files

Use this topic to map step function exposure data correctly for use in Touchstone.

Touchstone supports the step function record only for primary property policies, not for facultative or workers' compensation policies. The record can be used to implement single-location residential endowment policies in Japan. It was developed to support the multi-step structure of Japanese earthquake policies. Rather than paying out a continuous amount for any damages that occur at a location, policies with step functions define ranges where any damages that fall between certain values will be paid out at a certain amount. You can also use step functions for any region, peril, or line of business. The record contains fields that detail the damage ratios in each of the steps that dictate when certain coverage-specific payouts are made.

In the table below, the Touchstone Column Name column identifies the default step function-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.

Section in list of Touchstone Column Names Touchstone Column Name Acceptable .csv solumn names Primary Property
Step Function Contract ID ContractID, PolicyID X
Name Name X
Perils Perils X
Trigger Type TriggerType X
Step Function Detail Trigger Start Building TriggerBuildingStart X
Trigger End Building TriggerBuildingEnd X
Deductible Building DeductibleBuilding X
Payout Building PayoutBuilding X
Trigger Start Content TriggerContentsStart X
Trigger End Content TriggerContentsEnd X
Deductible Content DeductibleContents X
Payout Content PayoutContents X
Trigger Start Building and Content TriggerBuilding+ContentsStart X
Trigger End Building and Contents TriggerBuilding+ContentsEnd X
Deductible Building and Content DeductibleBuilding+Contents X
Payout Building and Content PayoutBuilding+Contents X
Minimum TIV MinimumTIV X
Scale Factor ScaleFactor X
Limit At Damage LimitAtDamage X