tConvertUPXPerilSet Table

Description

Stores information about peril codes supported in UPX files.

Touchstone uses the information to convert peril codes supported in UPX files to peril codes supported in Touchstone.

Properties

Columns

Column Name	Description	Datatype	Length
CountryCode	Code that represents the country in a UPX record.	varchar	15
UPXPeril	Code that represents the peril in a UPX record. PAL = All licenses perils PCY = Cyber security data and privacy breach PCZ = Cyber security property damage PEA = All earthquake perils(shake, fire, sprinkler, landslide, tsunami) PES = Earthquake - shake only PFF = Fire following earthquake PFL = Inland flood PLS = Landslide PPH = Precipitation flood PHL = Hail PSH = Hurricane storm surge PSL = Earthquake - sprinkler leakage only PTR = Terrorism PTS = Tsunami PTD = Tornado PSW = Straight-Line Winds 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	varchar	10
PerilSetCode	Code that represent the peril set in Touchstone. For a complete list of codes, see tPerilSet Table.	int	4
Description	Description of the peril set. Corresponds to the code in UPXPeril.	varchar	1024

Objects that tConvertUPXPerilSet depends on

	Database Object	Object Type	Description	Dep Level
	tPerilSet	Table	Stores codes that represent the perils sets supported by the application.	1

Verisk Analytics Client Confidential

Please contact Verisk Analytics with questions or comments.