Touchstone 4.0 Database Documentation
tPeril Table
Description

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

Properties
Creation Date2/16/2011 6:00 PM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows16
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
  • 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
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.

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

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

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