Touchstone 2022 Database Reference
tEventSetPerilExclusion Table
AIRReference Database : tEventSetPerilExclusion Table
Description

Stores information regarding the exclusion of a peril set in a specific event set This table is used when writing combined perils for all models in an event set to the AIRUserSetting Database.

Properties
Creation Date6/22/2012 5:15 PM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows22
Data Space Used8.00 KB
Index Space Used24.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key EventSetSID

Unique system-generated sequential identifier for the event set record.

For a complete list of records, see tEventSet Table.

int4   
Primary Key PerilSetCode

Numeric code for the single peril or set of perils.

For a complete list of codes, see tPerilSet Table.

int4   
 IsExcluded

Indicates whether the peril set is excluded in a specific event set.

  • 1 = Yes (excluded)
  • 0 = No (included)
bit1 dbo.D_1 
Objects that tEventSetPerilExclusion depends on
 Database ObjectObject TypeDescriptionDep Level
tPerilSet tabletPerilSetTable

Stores codes that represent the perils sets supported by the application.

1
See Also

Related Objects

AIRReference Database

 

 

Verisk Analytics Client Confidential

© 2022. AIR Worldwide is now Extreme Event Solutions. AIR Worldwide is a registered trademark. Touchstone is a registered trademark of AIR Worldwide.

Please contact Verisk Analytics with questions or comments.