Touchstone 4.0 Database Documentation
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)
  • Boolean1 dbo.D_0 
    Objects that depend on tPeril
     Database ObjectObject TypeDescriptionDep Level
    tPerilSetXref tabletPerilSetXrefTableSystem reference table used to determine the individual perils that are associated with each peril set.  This table is used extensively for Geospatial analytics.1
    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



    AIR Client Confidential

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