Touchstone 4.0 Database Documentation
tEventFilterHawaiiCondition Table
Description

Stores information for the types of event filters that can be applied to perils in Hawaii.

Properties
Creation Date1/18/2013 2:22 PM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows2
Data Space Used8.00 KB
Index Space Used8.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key EventFilterHawaiiConditionCode

Code that represents the peril.

  • 0 = Tropical Storms
  • 1 = Hurricanes
VarChar10   
 EventFilterHawaiiConditionType

Name of the peril.

Corresponds to the code in EventFilterHawaiiConditionType.

VarChar255  
 EventFilterHawaiiConditionValue

Indicates whether the filter condition applies.

  • 1 = Yes (applies)
  • 0 = No (does not apply)
Boolean1dbo.D_0 
 DescriptionDescription of the peril.VarChar1024  
Check Constraints
NameDescriptionExpression
CKC_EVENTFILTERHAWAII_TEVENTFI 
([EventFilterHawaiiConditionValue] IS NULL OR [EventFilterHawaiiConditionValue]>=(0) AND [EventFilterHawaiiConditionValue]<=(1))
See Also

Related Objects

AIRReference 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.