Touchstone 4.0 Database Documentation
tEventSet Table

Stores the event sets that are available in Touchstone. 

Creation Date5/31/2016 9:46 AM
Text File Group
System Object
Published for Replication
Data Space Used64.00 KB
Index Space Used96.00 KB
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key EventSetSIDUnique system-generated sequential identifier for the event set record.Integer4   

Unique system-generated sequential identifier for the business unit record.


Code that represents the event set type.

For a complete list of codes, see tEventSetType Table.

 EventSetName of the event set as presented on the user interface.VarChar1000   
 EventSetStandardNameAlias name of the event set; used by API clients.VarChar1000   

Numeric code for the single peril or set of perils.

For a complete list of codes, see tPerilSet Table.

 EventSetMaxYearTagMaximum number of simulated years in the event set.  For example, 10K represents 10,000 years.VarChar255  
 RegionTagName of the region to which the event set applies.VarChar255  

Represents the perils included within the event set. Note the following:

  • AP = All perils
  • EQ = Earthquake
  • TC = Tropical Cyclone
 HistoricalTagIndicates the historical event sets.VarChar255  
 ReleaseYearTagYear the event set was released.VarChar255  
 CatalogTypeTagRepresents the type of catalog.VarChar255  

Name of the person or company that created the event set. 

Note that the author of event sets provided as part of your company licenses is AIR, Inc. 

 EnteredDateDate and time when the event set was created.VarWChar10 
 EditedDateDate and time when the event set was last modified.VarWChar10 
 DescriptionDescription of the event set.VarChar4000  

Code that represents the status.

For a complete list of codes, see tStatus Table.


Product version associated with the event set.

This enables users to view results generated from previous version of Touchstone,  even when the models are updated.

Note that for old model results, event description are not accessible because catalog files no longer exist in the Touchstone system.

Objects that depend on tEventSet
 Database ObjectObject TypeDescriptionDep Level
tEventSetCatalogXref tabletEventSetCatalogXrefTableSystem reference table used to identify the events sets that are associated with specific catalogs.1
tEventSetInfo tabletEventSetInfoTable

Stores information about the event sets that are available in Touchstone. 

See Also

Related Objects

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