CEDE 10.0 Database Reference
tSEQUELImpactSubPerilGroupingXRef Table
AIRReference Database : tSEQUELImpactSubPerilGroupingXRef Table
Description
Stores codes, descriptions, and groupings of the peril codes generated in Touchstone.
Properties
Creation Date10/20/2020 10:10 AM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows14
Data Space Used8.00 KB
Index Space Used8.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key SubPerilGroupingSIDRepresents a unique sequential identifier associated with the sub peril for grouping peril codes.int4   
 TouchstonePerilCode

Code that represents the peril codes generated in Touchstone.

  • PES
  • PEA
  • PEQ
  • PEF
  • PFL
  • PFH
  • PNC
  • PWX
  • PNW
  • PSH
  • PWH
  • PWS
  • PTR
  • PWA
char3   
 PerilGroup

Represents the group in which the Touchstone peril codes are organized.

  • EQ
  • FF + WF
  • FL
  • FL + TC
  • NC
  • TC
  • TR
  • SS
varchar1024   
 Description

Name of the Touchstone peril code.

TouchstonePerilCode Description
PES TS PES Earthquake shake only
PEA TS PEA All Earthquake perils
PEQ TS PES+PFF+PTS+PLS+PSL All Earthquake perils
PEF TS PEF Fire-Following and Wildfire
PFL TS PFL Inland flood
PFH

TS PFL+PSH Inland and Coastal Flood
PNC TS PNC Non-catastrophe
PWX

TS PWX Severe storm
PNW

TS PWH+PSH+PPH Named windstorm
PSH TS PSH Hurricane storm surge or coastal flood
PWH TS PWH Tropical cyclone only
PWS TS PWH+PSH Windstorm
PTR TS PTR Terrorism
PWA TS PWA Wind All

 

varchar1024  
 WriteToTSAsRepresents the description of the peril code in Touchstone.varchar1024  
See Also

Related Objects

AIRReference Database

 

 

Verisk Analytics Client Confidential

© 2022. AIR Worldwide is now Extreme Event Solutions. AIR Worldwide is a registered trademark. Touchstone is a registered trademark of AIR Worldwide.

Please contact Verisk Analytics with questions or comments. For database questions. For documentation comments.