CEDE 7.0 Database Reference
tPeril Table
Description

Stores codes that represent the perils supported by the application.

Properties
Creation Date2/16/2011 6:00 PM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows23
Data Space Used8.00 KB
Index Space Used24.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key PerilCode

Code that represents the peril type.

  • AG = Multi-peril Crop
  • CF=  Coastal Flood
  • CH = Crop Hail
  • EQ = Earthquake Shake
  • FF = Fire Following
  • HL = Hail
  • IF = Inland Flood
  • LS = Landslide
  • LQ = Liquefaction
  • NC = NonCat
  • PD = Property Damage (Cyber)
  • PF = Precipitation Flood
  • PN = Pandemic Flu
  • SB = Security Breach (Cyber)
  • SL = Sprinkler Leakage
  • ST = Severe Thunderstorm
  • SU = Storm Surge
  • TC = Wind
  • TD = Tornado
  • TR = Terrorism
  • TS = Tsunami
  • WF = Wildfire/Bushfire
  • WS = Winter Storm
varchar10   
 Peril

Name of the peril.

Corresponds to the code in PerilCode.

varchar40   
 Description

Description of the peril.

varchar1024  
 PerilSetCode

Numeric code for the single peril or set of perils.

For a complete list of codes, see tPerilSet Table.

int4   
 PerilDisplayGroup

Name of the group under which the peril is categorized on the user interface, when applicable

For example, Earthquake is the display group for Fire Following and Tropical Cyclone is the display group for Wind.

varchar50  
 IsEnabled

Indicates whether the peril is available for use, for example, whether you can select the peril in the Exposure Set pane.

  • 1 = Yes (available)
  • 0 = No (not available)
bit1 dbo.D_0 
 ModRulePerilSetCode

Numeric code for the single peril or set of perils that can be used as a filter in a loss modification template rule.

int4  
 IsReinsurance

Indicates whether the peril is supported in Touchstone Re.

  • 1 = Yes (supported)
  • 0 = No (not supported)
bit1  
 UIOrderOrder of the peril in the user interface. The order specifies where the peril appears in configuration screens.tinyint1  
Objects that tPeril depends on
 Database ObjectObject TypeDescriptionDep Level
tPerilSet tabletPerilSetTable

Stores codes that represent the perils sets 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.