Touchstone 4.0 Database Documentation
tDemandSurge Table
Description

Stores information about the standard demand surge curves that are available in Touchstone. 

Information regarding the custom, user-defined demand surge function is available in tDemandSurgeFunction Table.

Properties
Creation Date5/31/2016 9:46 AM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows54
Data Space Used8.00 KB
Index Space Used72.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key DemandSurgeSIDUnique system-generated sequential identifier for the demand surge record.SmallInt2   
 BusinessUnitSID

Unique system-generated sequential identifier for the business unit record.

Integer4   
 DemandSurgeRegionCode

Code that represents the demand surge region.

For a complete list of codes, see tDemandSurgeRegion Table.

SmallInt2   
 CurrencyCode

ISO 3-character code for the currency.

For a complete list of codes, see tCurrency Table.

Char3   
 UnitCode

Code for the unit of measure used to express the monetary amount, as in MIL for million.

For a complete list of codes, see tUnit Table.

VarChar10   
 Points

The monetary value by which each step in the industry loss range is incremented.

For example, if the range starts at $0 and ends at $10 billion and the Increment value is $2 billion, the steps in the industry loss range will be $0, $2 billion, $4 billion, $6 billion, $8 billion, and $10 billion. This means that one set of demand surge factors will be applied to industry losses between $0 and $1,999,999,999, another set between $2 billion and $3,999,999,999, and so on.

SmallInt2   
 IsAIRStandard

Indicates whether the curve has been designated as the  "standard" curve for the region. Note there can be only one standard and one custom curve per region.

  • 1 = Yes (standard
  • 0 = No (not standard)
Boolean1 
((0))
 
 IsUsageDefault

Indicates whether the curve is included with the default curves on the user interface.  

  • 1 = Yes (included)
  • 0 = No (not included)
Boolean1 
((1))
 
Check Constraints
NameDescriptionExpression
CKC_ISAIRSTANDARD_TDEMANDS 
([IsAIRStandard]>=(0) AND [IsAIRStandard]<=(1))
CKC_ISUSAGEDEFAULT_TDEMANDS 
([IsUsageDefault]>=(0) AND [IsUsageDefault]<=(1))
Objects that depend on tDemandSurge
 Database ObjectObject TypeDescriptionDep Level
tDemandSurgeFunction tabletDemandSurgeFunctionTable

Stores information about the custom, user-defined demand surge functions.

Information regarding the AIR-provided demand surge curves is available in tDemandSurge Table.

1
See Also

Related Objects

AIRUserSetting Database

 

 


AIR Client Confidential

© 2016. AIR Worldwide is a registered trademark. Touchstone is a registered trademark of AIR Worldwide.

Please contact AIR Worldwide with questions or comments. For database questions. For documentation comments.