Primary property step function detail fields for import

In ImportExpress, you map step function .csv import data to valid Touchstone fields.

This table lists the import field, for primary property exposures, and the Touchstone user interface step function field and database field that correspond to each step function import field. Import fields are in italic font because the field name is variable.

Users can enter values in the ContentStart and ContentEnd fields in the exposure data for import into Touchstone. The values are then visible in the Trigger by Amount section in the Content Start and Content End fields for trigger type 4 (Building, then Contents). This enables users to specify contents amount steps in addition to building amount steps for building damage, not just percentage and amount steps.

Note:

ImportExpress rounds all imported monetary values to the nearest whole number if these values contain decimal places.

Import Field

User Interface Field

Database Field

Required

Trigger Start Building

Building Start (percent or monetary value)

tStepFunctionDetail.StartTriggerBuilding

Trigger End Building

Building End (percent or monetary value)

tStepFunctionDetail.EndTriggerBuilding

Deductible Building

Building Deductible (percent or monetary value)

tStepFunctionDetail.DeductibleBuilding

Payout Building

Building Payout (percent or monetary value)

tStepFunctionDetail.PayOutBuilding

Trigger Start Content

Content Start (percent or monetary value)

tStepFunctionDetail.StartTriggerContent

Trigger End Content

Content End (percent or monetary value)

tStepFunctionDetail.EndTriggerContent

Deductible Content

Content Deductible (percent or monetary value)

tStepFunctionDetail.DeductibleContent

Payout Content

Content Payout (percent or monetary value)

tStepFunctionDetail.PayOutContent

Trigger Start Building And Content

Building Content Start (percent or monetary value)

tStepFunctionDetail.StartTriggerBuildingContent

Trigger End Building And Content

Building Content End (percent or monetary value)

tStepFunctionDetail.EndTriggerBuildingContent

Deductible Building And Content

Total Deductible (percent or monetary value)

tStepFunctionDetail.DeductibleBuildingContent

Payout Building And Content

Total Payout (percent or monetary value)

tStepFunctionDetail.PayoutBuildingContent

Minimum TIV

Minimum TIV (percent or monetary value)

tStepFunctionDetail.MinimumTIV

Scale Factor

Scale Factor (percent or monetary value)

tStepFunctionDetail.ScaleFactor

Limit At Damage

Limit At Damage (percent or monetary value)

tStepFunctionDetail.IsLimitAtDamage