Touchstone 4.0 Database Documentation
tStepFunctionDetail Table
Description
Contains detailed information for each step function SID.
Properties
Creation Date5/31/2016 9:46 AM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows0
Data Space Used0.00 KB
Index Space Used0.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key StepFunctionSID

Unique system-generated sequential identifier for the step function record.

For a complete list of records, see tStepFunction Table.

Integer4   
Primary Key StepNumberNumber between 1 and 7 that is used to sort the step function in the correct orderUnsignedTinyInt1   
 StartTriggerBuildingStarting value of the building (Coverage A) damage range over which the corresponding payout(s) should be made.Double9  
 EndTriggerBuildingEnding value of the building (Coverage A) damage range over which the corresponding payout(s) should be made.Double9  
 DeductibleBuildingBuilding deductible that can be used, for example, to account for fire policies before applying step functions.Double9  
 PayOutBuildingPayout that covers building (Coverage A) gross losses for this step.Double9  
 StartTriggerContentStarting value of the contents (Coverage C) damage range over which the corresponding payout(s) should be made.Double9  
 EndTriggerContentEnding value of the contents (Coverage C) damage range over which the corresponding payout(s) should be made.Double9  
 DeductibleContentContents deductible that can be used, for example, to account for fire policies before applying step functions.Double9  
 PayOutContentPayout that covers contents (Coverage C) losses for this step.Double9  
 StartTriggerBuildingContentStarting value of the combined building and contents (Coverages A and C) damage range over which the corresponding payout(s) should be made.Double9  
 EndTriggerBuildingContentEnding value of the combined building and contents (Coverages A and C) damage range over which the corresponding payout(s) should be made.Double9  
 DeductibleBuildingContentCombined building and contents deductible that can be used, for example, to account for fire policies before applying step functions.Double9  
 PayOutBuildingContentPayout that covers combined building and contents (Coverages A and C) losses for this step.Double9  
 MinimumTIVMinimum replacement value for which payouts to the corresponding damage range will be allowed.Double9  
 ScaleFactorPercentage factor used to scale calculated losses. This value, entered as a decimal, should be the same for all steps for a contract and must be a value >0 and ≤1. For example, 0.12 for 12%.Single4   
 IsLimitAtDamageIndicates whether the payout is limited by the actual ground-up loss.Boolean1 
((0))
 
 RowVersionUsed for version stamping.Binary8   
Objects that tStepFunctionDetail depends on
 Database ObjectObject TypeDescriptionDep Level
tContract tabletContractTable

Contains records for primary insurance policies.

2
tExposureSet tabletExposureSetTableContains exposure set information. An exposure set is a collection of contracts, locations, and other related information.3
tStepFunction tabletStepFunctionTableContains general information for each step function SID, including the contract in which the step function is used.1
See Also

Related Objects

AIRExposure Database

 

 


AIR Client Confidential

© 2016. AIR Worldwide is a registered trademark. Touchstone is a registered trademark of AIR Worldwide.

Please contact AIR Worldwide with questions or comments. For database questions. For documentation comments.