CEDE 7.0 Database Reference
tPerilSet Table
Description

Stores codes that represent the perils sets supported by the application.

Properties
Creation Date11/3/2011 11:46 PM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows4456454
Data Space Used1,064,808.00 KB
Index Space Used3,936.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key 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.

int4   
 PerilSet

Abbreviated code for the perils included in the peril set. 

For a complete list of codes, see tPeril Table.

varchar255   
 Description

Description of the perils included in the peril set.

varchar1024  
 CoversTropicalCyclone

Indicates whether the peril set includes tropical cyclone.

  • 1 = Yes (included)
  • 0 = No (not included)
bit1 dbo.D_0 
 CoversThunderstorm

Indicates whether the peril set includes thunderstorm.

  • 1 = Yes (included)
  • 0 = No (not included)
bit1 dbo.D_0 
 CoversEarthquakeShake

Indicates whether the peril set includes earthquake - shake.

  • 1 = Yes (included)
  • 0 = No (not included)
bit1 dbo.D_0 
 CoversEarthquakeFire

Indicates whether the peril set includes earthquake - fire.

  • 1 = Yes (included)
  • 0 = No (not included)
bit1 dbo.D_0 
 CoversCoastalFlood

Indicates whether the peril set includes coastal flood.

  • 1 = Yes (included)
  • 0 = No (not included)
bit1 dbo.D_0 
 CoversTerrorism

Indicates whether the peril set includes terrorism.

  • 1 = Yes (included)
  • 0 = No (not included)
bit1 dbo.D_0 
 CoversWinterStorm

Indicates whether the peril set includes winter storm.

  • 1 = Yes (included)
  • 0 = No (not included)
bit1 dbo.D_0 
 CoversEarthquakeSprinkler

Indicates whether the peril set includes earthquake - sprinkler.

  • 1 = Yes (included)
  • 0 = No (not included)
bit1 dbo.D_0 
 CoversStormSurge

Indicates whether the peril set includes storm surge.

  • 1 = Yes (included)
  • 0 = No (not included)
bit1 dbo.D_0 
 CoversWildfire

Indicates whether the peril set includes wildfire.

  • 1 = Yes (included)
  • 0 = No (not included)
bit1 dbo.D_0 
 CoversMultiPerilCrop

Indicates whether the peril set includes multi-peril crop.

  • 1 = Yes (included)
  • 0 = No (not included)
bit1 dbo.D_0 
 CoversInlandFlood

Indicates whether the peril set includes inland flood.

  • 1 = Yes (included)
  • 0 = No (not included)
bit1 dbo.D_0 
 CoversPrecipitationFlood

Indicates whether the peril set includes precipitation flood.

  • 1 = Yes (included)
  • 0 = No (not included)
bit1 dbo.D_0 
 CoversTsunami

Indicates whether the peril set includes tsunami.

  • 1 = Yes (included)
  • 0 = No (not included)
bit1 
((0))
 
 CoversPandemicFlu

Indicates whether the peril set includes pandemic flu.

  • 1 = Yes (included)
  • 0 = No (not included)
bit1 
((0))
 
 CoversNC

Indicates whether the peril set includes the non-catastrophe model.

  • 1 = Yes (included)
  • 0 = No (not included)
bit1 
((0))
 
 CoversLandslide

Indicates whether the peril set includes landslide.

  • 1 = Yes (included)
  • 0 = No (not included)
bit1 
((0))
 
 CoversCropHail

Indicates whether the peril set includes crop hail.

  • 1 = Yes (included)
  • 0 = No (not included)
bit1 
((0))
 
 CoversLiquefaction

Indicates whether the peril set includes liquefaction.

  • 1 = Yes (included)
  • 0 = No (not included)
bit1 
((0))
 
Objects that depend on tPerilSet
 Database ObjectObject TypeDescriptionDep Level
tPeril tabletPerilTable

Stores codes that represent the perils supported by the application.

1
See Also

Related Objects

AIRReference Database

 

 


© 2019. AIR Worldwide is a registered trademark. Touchstone is a registered trademark of AIR Worldwide.

Please contact AIR Worldwide with questions or comments. For database questions. For documentation comments.