Stores detailed information about step functions.
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. For a complete list of records, see tStepFunction Table. | int | 4 | ||||
StepNumber | Number between 1 and 7 that is used to sort the step function in the correct order | tinyint | 1 | ||||
StartTriggerBuilding | Starting value of the building (Coverage A) damage range over which the corresponding payout(s) should be made. | float | 9 | ||||
EndTriggerBuilding | Ending value of the building (Coverage A) damage range over which the corresponding payout(s) should be made. | float | 9 | ||||
DeductibleBuilding | Building deductible that can be used, for example, to account for fire policies before applying step functions. | float | 9 | ||||
PayOutBuilding | Payout that covers building (Coverage A) gross losses for this step. | float | 9 | ||||
StartTriggerContent | Starting value of the contents (Coverage C) damage range over which the corresponding payout(s) should be made. | float | 9 | ||||
EndTriggerContent | Ending value of the contents (Coverage C) damage range over which the corresponding payout(s) should be made. | float | 9 | ||||
DeductibleContent | Contents deductible that can be used, for example, to account for fire policies before applying step functions. | float | 9 | ||||
PayOutContent | Payout that covers contents (Coverage C) losses for this step. | float | 9 | ||||
StartTriggerBuildingContent | Starting value of the combined building and contents (Coverages A and C) damage range over which the corresponding payout(s) should be made. | float | 9 | ||||
EndTriggerBuildingContent | Ending value of the combined building and contents (Coverages A and C) damage range over which the corresponding payout(s) should be made. | float | 9 | ||||
DeductibleBuildingContent | Combined building and contents deductible that can be used, for example, to account for fire policies before applying step functions. | float | 9 | ||||
PayOutBuildingContent | Payout that covers combined building and contents (Coverages A and C) losses for this step. | float | 9 | ||||
MinimumTIV | Minimum replacement value for which payouts to the corresponding damage range will be allowed. | float | 9 | ||||
ScaleFactor | Percentage factor used to scale calculated losses. This value, entered as a decimal, should be the same for all steps for a contract and must be a value >0 and ≤1. For example, 0.12 for 12%. | real | 4 | ||||
IsLimitAtDamage | Indicates whether the payout is limited by the actual ground-up loss. | bit | 1 | ((0)) | |||
RowVersion | Used for version stamping. | timestamp | 8 |
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 | |
tStepFunction | Table | Stores general information about step functions, including the contract associated with each step function. | 1 |