Stores general information about step functions, including the contract associated with each step function.
Creation Date | 05-06-2025 01:54 |
File Group | PRIMARY |
Text File Group | |
System Object | ![]() |
Published for Replication | ![]() |
Rows | 0 |
Data Space Used | 0.00 KB |
Index Space Used | 0.00 KB |
Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
---|---|---|---|---|---|---|---|
![]() | StepFunctionSID | Unique system-generated sequential identifier for the step function record. | int | 4 | |||
ContractSID | Unique system-generated sequential identifier for the contract record. For a complete list of records, see tContract Table. | int | 4 | ||||
StepFunctionName | User-defined name for the step function. | varchar | 255 | ![]() | |||
RowVersion | Used for version stamping. | timestamp | 8 | ||||
PerilSetCode | Numeric code for the single peril or set of perils. For a complete list of codes, see tPerilSet Table. | int | 4 | ||||
StepTriggerTypeCode | Code that represents how, and for which coverages, payouts are triggered. For a complete list of codes, see tStepTriggerType Table. | tinyint | 1 |
Database Object | Object Type | Description | Dep Level | |
---|---|---|---|---|
![]() | tLocStepFunctionXref | Table | System reference table used to determine the step functions that are associated with a location. | 1 |
![]() | tStepFunctionDetail | Table | Stores detailed information about step functions. | 1 |
Database Object | Object Type | Description | Dep Level | |
---|---|---|---|---|
![]() | tContract | Table | Stores records for primary insurance policies. | 2 |
![]() | tExposureSet | Table | Stores information about exposure sets. An exposure set is a collection of contracts, locations, and other related information. | 3 |