Stores codes that represent the perils sets supported by the application.
CEDE 9.0 Database Reference
tPerilSet Table
Stores codes that represent the perils sets supported by the application.
| 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. R Contact AIR Worldwide for a complete list of peril sets. | 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 |
| tPeril | Table | Stores codes that represent the perils supported by the application. | 1 |