Stores general information about step functions, including the contract associated with each step function.
Creation Date | 4/12/2021 11:26 AM |
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. | 1 | |
tExposureSet | Table | Stores information about exposure sets. An exposure set is a collection of contracts, locations, and other related information. | 2 |