CEDE 7.0 Database Reference
tStepFunctionDetail Table
| AIRExposure Database : tStepFunctionDetail Table |
| Creation Date | 6/19/2019 8:45 PM |
| 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 |