Touchstone 4.0 Database Documentation
tDemandSurgeFunction Table
Description

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

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

Properties
Creation Date5/31/2016 9:46 AM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows13554
Data Space Used1,056.00 KB
Index Space Used192.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key DemandSurgeSID

Unique system-generated sequential identifier for the custom, user-defined demand surge record.

SmallInt2   
Primary Key DemandSurgePoint

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   
 IndustryLossTotal amount of industry loss.Double9   
 Factor_AThe factor by which the industry loss is multiplied for Coverage A.Numeric9 (20,15)   
 Factor_BThe factor by which the industry loss is multiplied for Coverage B.Numeric9 (20,15)   
 Factor_CThe factor by which the industry loss is multiplied for Coverage C.Numeric9 (20,15)   
 Factor_DThe factor by which the industry loss is multiplied for Coverage D.Numeric9 (20,15)   
Objects that tDemandSurgeFunction depends on
 Database ObjectObject TypeDescriptionDep Level
tDemandSurge tabletDemandSurgeTable

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.

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.