Touchstone 4.0 Database Documentation
tStepFunction Table
Description
Contains general information for each step function SID, including the contract in which the step function is used.
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 StepFunctionSIDUnique system-generated sequential identifier for the step function record.Integer4   
 ContractSID

Unique system-generated sequential identifier for the contract record.

For a complete list of records, see tContract Table.

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

Numeric code for the single peril or set of perils.

For a complete list of codes, see tPerilSet Table.

Integer4   
 StepTriggerTypeCode

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

For a complete list of codes, see tStepTriggerType Table

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

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