Understanding the CEDE Format, Touchstone 4.0
tPeril Table

Stores the possible perils that are available for use in Touchstone.

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

Code that represents the peril type.

  • AG = Multi-peril Crop
  • CF=  Coastal Flood
  • EQ = Earthquake Shake
  • FF = Fire Following
  • IF = Inland Flood
  • NC = NonCat
  • PF = Precipitation Flood
  • PN = Pandemic Flu
  • SL = Sprinkler Leakage
  • ST = Severe Thunderstorm
  • SU = Storm Surge
  • TC = Wind
  • TR = Terrorism
  • TS = Tsunami
  • WF = Wildfire/Bushfire
  • WS = Winter Storm

Name of the peril.

Corresponds to the code in PerilCode.


Description of the peril.


Numeric code for the single peril or set of perils.

For a complete list of codes, see tPerilSet Table.


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.


Indicates whether the peril is available for use.

  • 1 = Yes (available)
  • 0 = No (not available)
  • bit1 dbo.D_0 
    Objects that tPeril depends on
     Database ObjectObject TypeDescriptionDep Level
    tPerilSet tabletPerilSetTable

    Stores the possible perils sets that are available for use in Touchstone.

    See Also

    Related Objects

    AIRReference Database



    © 2016. 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.