Touchstone 4.0 Database Documentation
tEventSet Table
Description

Stores the event sets that are available in Touchstone. 

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

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

Integer4   
 EventSetTypeCode

Code that represents the event set type.

For a complete list of codes, see tEventSetType Table.

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

Numeric code for the single peril or set of perils.

For a complete list of codes, see tPerilSet Table.

Integer4  
 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  
 PerilTag

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

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

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. 

VarChar255  
 EnteredDateDate and time when the event set was created.VarWChar10 
(getutcdate())
 
 EditedDateDate and time when the event set was last modified.VarWChar10 
(getutcdate())
 
 DescriptionDescription of the event set.VarChar4000  
 StatusCode

Code that represents the status.

For a complete list of codes, see tStatus Table.

VarChar10 
('A')
 
 EventSetProductVersion

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.

VarChar10 
('3.0.0')
 
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. 

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