Stores information regarding the exclusion of a peril set in a specific event set This table is used when writing combined perils for all models in an event set to the AIRUserSetting Database.
| Creation Date | 6/22/2012 5:15 PM |
| File Group | PRIMARY |
| Text File Group | |
| System Object |  |
| Published for Replication | |
| Rows | 22 |
| Data Space Used | 8.00 KB |
| Index Space Used | 24.00 KB |
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
 | EventSetSID | Unique system-generated sequential identifier for the event set record. For a complete list of records, see tReinsuranceEventSet Table. | int | 4 | |||
| | PerilSetCode | Numeric code for the single peril or set of perils. For a complete list of codes, see tPerilSet Table. | int | 4 | |||
| IsExcluded | Indicates whether the peril set is excluded in a specific event set.
| bit | 1 | dbo.D_1 |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
 | tPerilSet | Table | Stores codes that represent the perils sets supported by the application. Additional peril sets used by Touchstone Re are listed in tPerilSetCombined Table. | 1 |