Touchstone 4.0 Database Documentation
tStepFunction Table
Contains general information for each step function SID, including the contract in which the step function is used.
Creation Date5/31/2016 9:46 AM
Text File Group
System Object
Published for Replication
Data Space Used0.00 KB
Index Space Used0.00 KB
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key StepFunctionSIDUnique system-generated sequential identifier for the step function record.Integer4   

Unique system-generated sequential identifier for the contract record.

For a complete list of records, see tContract Table.

 StepFunctionNameUser-defined name for the step function.VarChar255  
 RowVersionUsed for version stamping.Binary8   

Numeric code for the single peril or set of perils.

For a complete list of codes, see tPerilSet Table.


Code that represents how, and for which coverages, payouts are triggered.

For a complete list of codes, see tStepTriggerType Table

Objects that depend on tStepFunction
 Database ObjectObject TypeDescriptionDep Level
tLocStepFunctionXref tabletLocStepFunctionXrefTableSystem reference table used to determine the step functions that are associated with a location.1
tStepFunctionDetail tabletStepFunctionDetailTableContains detailed information for each step function SID.1
Objects that tStepFunction depends on
 Database ObjectObject TypeDescriptionDep Level
tContract tabletContractTable

Contains records for primary insurance policies.

tExposureSet tabletExposureSetTableContains exposure set information. An exposure set is a collection of contracts, locations, and other related information.3
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.