Touchstone 2022 Database Reference
tEventSetInfo Table
AIRUserSetting Database : tEventSetInfo Table
Description

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

Properties
Creation Date4/4/2022 3:02 AM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows27914
Data Space Used1,264.00 KB
Index Space Used1,720.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 ModelCode

Code that represents the model in Touchstone.

For a complete list of codes, see tModel Table.

smallint2   
Primary Key CountryCode

ISO 2-character code for the country in which the location resides. 

For a complete list of codes, see tCountry Table.

varchar15   
 YearYear the event set for the model and country was released.smallint2  
 SequenceSequence order.tinyint1  
 Type

Type of event set.

  • STD = Standard
  • ALT = Alternate
  • NEA = Near Term
  • HTI = HERP Time Independent
  • HIS = Historical
  • RDS = Realistic Disaster Scenarios
varchar10   
Objects that tEventSetInfo depends on
 Database ObjectObject TypeDescriptionDep Level
tEventSet tabletEventSetTable

Stores the event sets that are available in Touchstone. 

1
See Also

Related Objects

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