CEDE 9.0 Database Reference
tStepFunction Table
AIRExposure Database : tStepFunction Table
Description
Stores general information about step functions, including the contract associated with each step function.
Properties
Creation Date4/12/2021 11:26 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 Unique system-generated sequential identifier for the step function record.int4   
 

Unique system-generated sequential identifier for the contract record.

For a complete list of records, see tContract Table.

int4   
 User-defined name for the step function.varchar255  
 Used for version stamping.timestamp8   
 

Numeric code for the single peril or set of perils.

For a complete list of codes, see tPerilSet Table.

int4   
 

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

For a complete list of codes, see tStepTriggerType Table

tinyint1   
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 tabletStepFunctionDetailTableStores detailed information about step functions.1
Objects that tStepFunction depends on
 Database ObjectObject TypeDescriptionDep Level
tContract tabletContractTable

Stores records for primary insurance policies.

1
tExposureSet tabletExposureSetTable

Stores information about exposure sets.

An exposure set is a collection of contracts, locations, and other related information.

2
See Also

Related Objects

AIRExposure Database