Touchstone 4.0 Database Documentation
tConvertUPXPerilSet Table
Description

Stores information regarding the peril codes when using UPX files. This information is used to convert peril codes from UPX files for use in Touchstone.

Properties
Creation Date11/3/2011 10:37 PM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows17
Data Space Used8.00 KB
Index Space Used24.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key CountryCodeCode that represents the country in a UPX record.VarChar15   
Primary Key UPXPeril

Code that represents the peril in a UPX record.

  • PAL = All licenses perils
  • PEA = All earthquake perils(shake, fire, sprinkler, Tsunami)
  • PES = Earthquake - shake only
  • PFL = Inland flood
  • PPH = Precipitation flood
  • PSH = Hurricane storm surge
  • PSL = Earthquake - sprinkler leakage only
  • PTR = Terrorism
  • PTS = Tsunami
  • PWA = All wind perils (tropical cyclone, severe storm and winter storm)
  • PWF = All wind plus fire
  • PWH = Tropical cyclone only
  • PWT = Severe thunderstorm code appears only in exports by peril. Use PWX to import these perils
  • PWW = Winter storm
  • PWX = Severe storm(wind excluding tropical cyclone)
  • PEF = Fire (Wildfire, fire following earthquake)
  • PNC = NonCat
VarChar10   
 PerilSetCode

Code that represent the peril set in Touchstone.

For a complete list of codes, see tPerilSet Table.

Integer4   
 Description

Description of the peril set.

Corresponds to the code in UPXPeril.

VarChar1024  
Objects that tConvertUPXPerilSet 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.