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.
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 |