Stores information for the types of event filters that can be applied to perils in Hawaii.
Touchstone Re 2022 Database Reference
tEventFilterHawaiiCondition Table
Stores information for the types of event filters that can be applied to perils in Hawaii.
| Creation Date | 1/18/2013 2:22 PM |
| File Group | PRIMARY |
| Text File Group | |
| System Object |  |
| Published for Replication | |
| Rows | 2 |
| Data Space Used | 8.00 KB |
| Index Space Used | 8.00 KB |
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
 | EventFilterHawaiiConditionCode | Code that represents the peril.
| varchar | 10 | |||
| EventFilterHawaiiConditionType | Name of the peril. Corresponds to the code in EventFilterHawaiiConditionType. | varchar | 255 |  | |||
| EventFilterHawaiiConditionValue | Indicates whether the filter condition applies.
| bit | 1 | | dbo.D_0 | ||
| Description | Description of the peril. | varchar | 1024 | |
| Name | Description | Expression |
|---|---|---|
| CKC_EVENTFILTERHAWAII_TEVENTFI | ([EventFilterHawaiiConditionValue] IS NULL OR [EventFilterHawaiiConditionValue]>=(0) AND [EventFilterHawaiiConditionValue]<=(1)) |