Stores codes that represent the perils sets supported by the application.
Additional peril sets used by Touchstone Re are listed in tPerilSetCombined Table.
Touchstone Re 2022 Database Reference
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.
| Creation Date | 11/3/2011 11:46 PM |
| File Group | PRIMARY |
| Text File Group | |
| System Object |  |
| Published for Replication | |
| Rows | 16777216 |
| Data Space Used | 4,144,144.00 KB |
| Index Space Used | 15,472.00 KB |
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
 | PerilSetCode | Code that represents the single peril or set of perils. There are over 1,000 peril sets. Refer to the database for the complete list of codes . | int | 4 | |||
| PerilSet | Abbreviated code for the perils included in the peril set. For a complete list of codes, see tPeril Table. | varchar | 255 | ||||
| Description | Description of the perils included in the peril set. | varchar | 1024 |  | |||
| CoversTropicalCyclone | Indicates whether the peril set includes tropical cyclone.
| bit | 1 | dbo.D_0 | |||
| CoversThunderstorm | Indicates whether the peril set includes thunderstorm.
| bit | 1 | dbo.D_0 | |||
| CoversEarthquakeShake | Indicates whether the peril set includes earthquake - shake.
| bit | 1 | dbo.D_0 | |||
| CoversEarthquakeFire | Indicates whether the peril set includes earthquake - fire.
| bit | 1 | dbo.D_0 | |||
| CoversCoastalFlood | Indicates whether the peril set includes coastal flood.
| bit | 1 | dbo.D_0 | |||
| CoversTerrorism | Indicates whether the peril set includes terrorism.
| bit | 1 | dbo.D_0 | |||
| CoversWinterStorm | Indicates whether the peril set includes winter storm.
| bit | 1 | dbo.D_0 | |||
| CoversEarthquakeSprinkler | Indicates whether the peril set includes earthquake - sprinkler.
| bit | 1 | dbo.D_0 | |||
| CoversStormSurge | Indicates whether the peril set includes storm surge.
| bit | 1 | dbo.D_0 | |||
| CoversWildfire | Indicates whether the peril set includes wildfire.
| bit | 1 | dbo.D_0 | |||
| CoversMultiPerilCrop | Indicates whether the peril set includes multi-peril crop.
| bit | 1 | dbo.D_0 | |||
| CoversInlandFlood | Indicates whether the peril set includes inland flood.
| bit | 1 | dbo.D_0 | |||
| CoversPrecipitationFlood | Indicates whether the peril set includes precipitation flood.
| bit | 1 | dbo.D_0 | |||
| CoversTsunami | Indicates whether the peril set includes tsunami.
| bit | 1 | ((0)) | |||
| CoversPandemicFlu | Indicates whether the peril set includes pandemic flu.
| bit | 1 | ((0)) | |||
| CoversNC | Indicates whether the peril set includes the non-catastrophe model.
| bit | 1 | ((0)) | |||
| CoversLandslide | Indicates whether the peril set includes landslide.
| bit | 1 | ((0)) | |||
| CoversCropHail | Indicates whether the peril set includes crop hail.
| bit | 1 | ((0)) | |||
| CoversLiquefaction | Indicates whether the peril set includes liquefaction.
| bit | 1 | ((0)) | |||
| CoversHail | Indicates whether the peril set includes hail.
| bit | 1 | ((0)) | |||
| CoversTornado | Indicates whether the peril set includes tornado.
| bit | 1 | ((0)) | |||
| CoversStraightLineWinds | Indicates whether the peril set includes straight line winds.
| bit | 1 | ((0)) |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
 | tCountryPerilXref | Table | System reference table used to determine the perils that are associated with a country. | 1 |
| tEventSetPerilExclusion | Table | 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. | 1 |
| tPeril | Table | Stores codes that represent the perils supported by the application. | 1 |
| tPerilSetXref | Table | System reference table used to determine the individual perils that are associated with each peril set. This table is used extensively for geospatial analytics. | 1 |