Touchstone 4.0 Database Documentation
tEventSetPerilExclusion Table

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.

Creation Date6/22/2012 5:15 PM
Text File Group
System Object
Published for Replication
Data Space Used8.00 KB
Index Space Used24.00 KB
 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.

Primary Key PerilSetCode

Numeric code for the single peril or set of perils.

For a complete list of codes, see tPerilSet Table.


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

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

Stores the possible perils sets that are available for use in Touchstone.

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.