Stores the event sets that are available in Touchstone.
Touchstone 2022 Database Reference
tEventSet Table
Stores the event sets that are available in Touchstone.
| Creation Date | 4/4/2022 3:02 AM |
| File Group | PRIMARY |
| Text File Group | PRIMARY |
| System Object |  |
| Published for Replication | |
| Rows | 640 |
| Data Space Used | 152.00 KB |
| Index Space Used | 176.00 KB |
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
 | EventSetSID | Unique system-generated sequential identifier for the event set record. | int | 4 | |||
| BusinessUnitSID | Unique system-generated sequential identifier for the business unit record. | int | 4 | ||||
| EventSetTypeCode | Code that represents the event set type. For a complete list of codes, see tEventSetType Table. | varchar | 10 | ||||
| EventSet | Name of the event set as presented on the user interface. | varchar | 1000 | ||||
| EventSetStandardName | Alias name of the event set used by API clients. | varchar | 1000 | ||||
| PerilSetCode | Numeric code for the single peril or set of perils. For a complete list of codes, see tPerilSet Table. | int | 4 |  | |||
| EventSetMaxYearTag | Maximum number of simulated years in the event set. For example, 10K represents 10,000 years. | varchar | 255 | | |||
| RegionTag | Name of the region to which the event set applies. | varchar | 255 | | |||
| PerilTag | Represents the perils included within the event set. Note the following:
| varchar | 255 | | |||
| HistoricalTag | Indicates the historical event sets. | varchar | 255 | | |||
| ReleaseYearTag | Year the event set was released. | varchar | 255 | | |||
| CatalogTypeTag | Represents the type of catalog. | varchar | 255 | | |||
| 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. | varchar | 255 | | |||
| EnteredDate | Date and time when the event set was created. | date | 8 | (getutcdate()) | |||
| EditedDate | Date and time when the event set was last modified. | date | 8 | (getutcdate()) | |||
| Description | Description of the event set. | varchar | 4000 | | |||
| StatusCode | Code that represents the status. For a complete list of codes, see tStatus Table. | varchar | 10 | ('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. | varchar | 10 | ('3.0.0') | |||
| IsPreviousVersionModel | Indicates whether the event set includes the current or previous version of the AIR models.
| bit | 1 | ((0)) | |||
| MetaData | XML string that temporarily logs event set details. | xml | 0 | | |||
| IsEligibleForNgm | bit | 1 | ((0)) |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
 | tEventSetCatalogXref | Table | System reference table used to identify the events sets that are associated with specific catalogs. | 1 |
| tEventSetInfo | Table | Stores information about the event sets that are available in Touchstone. | 1 |