Stores information about the standard demand surge curves that are available in Touchstone.
For information about the custom, user-specified demand surge function, see tDemandSurgeFunction Table.
| Creation Date | 4/4/2022 3:02 AM |
| File Group | PRIMARY |
| Text File Group | |
| System Object |  |
| Published for Replication | |
| Rows | 81 |
| Data Space Used | 8.00 KB |
| Index Space Used | 72.00 KB |
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
 | DemandSurgeSID | Unique system-generated sequential identifier for the demand surge record. | smallint | 2 | |||
| BusinessUnitSID | Unique system-generated sequential identifier for the business unit associated with the demand surge curves. | int | 4 | ||||
| DemandSurgeRegionCode | Code that represents the demand surge region. For a complete list of codes, see tDemandSurgeRegion Table. | smallint | 2 | ||||
| CurrencyCode | ISO 3-character code for the currency. For a complete list of codes, see tCurrency Table. | char | 3 |  | |||
| UnitCode | Code for the unit of measure used to express the monetary amount, for example, MIL for million. For a complete list of codes, see tUnit Table. | varchar | 10 | | |||
| Points | Monetary value used to increment the industry loss range. For example, if the industry loss range begins at $0 and ends at $10 billion and the Increment value is $2 billion, then the steps in the industry loss range are $0, $2 billion, $4 billion, $6 billion, $8 billion, and $10 billion. Consequently, the application applies one set of demand surge factors to industry losses between $0 and $1,999,999,999 and a different set to losses between $2 billion and $3,999,999,999, and so on. | smallint | 2 | | |||
| IsAIRStandard | Indicates whether the curve is designated as the standard curve for the region. There can be only one standard and one custom curve per region.
| bit | 1 | ((0)) | |||
| IsUsageDefault | Indicates whether the curve is included with the default curves on the user interface.
| bit | 1 | ((1)) | |||
| IsLatestModel | bit | 1 | ((0)) |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
 | tDemandSurgeFunction | Table | Stores information about custom, administrator-specified demand surge functions. For information about the AIR-provided demand surge curves, see tDemandSurge Table. | 1 |