Touchstone 4.0 Database Documentation
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.

Integer4   
Primary Key PerilSetCode

Numeric code for the single peril or set of perils.

For a complete list of codes, see tPerilSet Table.

Integer4   
 IsExcluded

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.

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.