CEDE 8.0 Database Reference
tSEQUELImpactSubPerilGroupingXRef Table
Description
Stores codes, descriptions, and groupings of the peril codes generated in Touchstone.
Properties
Creation Date2/27/2020 2:51 PM
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
 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