Stores information about the event sets that are available in Touchstone Re, including event sets associated with custom (user-defined) models.
| Creation Date | 4/4/2022 3:02 AM |
| File Group | PRIMARY |
| Text File Group | |
| System Object |  |
| Published for Replication | |
| Rows | 262 |
| Data Space Used | 40.00 KB |
| Index Space Used | 16.00 KB |
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
 | ReinsuranceEventSetSID | Unique system-generated sequential identifier for the event set. | int | 4 | |||
| BusinessUnitSID | Unique system-generated sequential identifier for the business unit associated with the event set. | int | 4 | ||||
| ILSPortfolio | Indicates whether the event set can be used during portfolio analyses.
| smallint | 2 |  | |||
| EventSetTypeCode | Code that represents the type of the event set.
| smallint | 2 | ||||
| EventSetFlagTypeCode | Indicates whether the event set is a system default event set.
| smallint | 2 | ||||
| ReinsuranceEventSetName | Name of the event set. | varchar | 100 | ||||
| Description | Description of the event set. | varchar | 255 | | |||
| Author | Name of the user that created the event set. | varchar | 255 | | |||
| EnteredDate | Date and time when the event set was created. | datetime | 4 | | |||
| PerilSetCode | Numeric code for the peril or set of perils associated with the event set. For a complete list of codes, see tPerilSet Table. | int | 4 | ||||
| IsCustom | Indicates whether the event set is a custom event set.
| bit | 1 | ||||
| IsActive | Indicates whether the event set is enabled.
| bit | 1 | ||||
| ParentreInsurancEventSetSID | Unique system-generated sequential identifier for the parent event set associated with the event set. | int | 4 | | |||
| IntOrder | Order of the event set. Used internally by Touchstone Re. | int | 4 | | |||
| CatalogTagTypeCode | Code that represents more details about the type of the event set. For a complete list of codes, see tCatalogTagType Table. | varchar | 10 | |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
 | tReinsuranceEventSetCatalogXRef | Table | System reference table that stores the event catalogs associated with each event set in Touchstone Re, including event sets associated with custom (user-defined) models.
You must license Custom Models and LOBs to use the custom models feature.
| 1 |
| tReinsuranceEventSetMapEx | Table | System reference table that stores the event sets associated with each parent event set. A parent event set is a superset of an event set. | 1 |