tPeril Table

CEDE 9.0 Database Reference

tPeril Table

Collapse All

AIRReference Database : tPeril Table

Description

Stores codes that represent the perils supported by the application.

Properties

Creation Date	2/16/2011 6:00 PM
File Group	PRIMARY
Text File Group
System Object
Published for Replication
Rows	24
Data Space Used	8.00 KB
Index Space Used	24.00 KB

Columns

	Column Name	Description	Datatype	Length	Allow Nulls	Default	Formula
	PerilCode	Code that represents the peril type. AG = Multi-peril Crop CF= Coastal Flood CH = Crop Hail EQ = Earthquake Shake FF = Fire Following HL = Hail IF = Inland Flood LS = Landslide LQ = Liquefaction NC = NonCat PD = Property Damage (Cyber) PF = Precipitation Flood PN = Pandemic Flu SB = Security Breach (Cyber) SL = Sprinkler Leakage ST = Severe Thunderstorm SU = Storm Surge TC = Wind TD = Tornado TR = Terrorism TS = Tsunami WF = Wildfire/Bushfire WS = Winter Storm	varchar	10
	Peril	Name of the peril. Corresponds to the code in PerilCode.	varchar	40
	Description	Description of the peril.	varchar	1024
	PerilSetCode	Numeric code for the single peril or set of perils. For a complete list of codes, see tPerilSet Table.	int	4
	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.	varchar	50
	IsEnabled	Indicates whether the peril is available for use, for example, whether you can select the peril in the Exposure Set pane. 1 = Yes (available) 0 = No (not available)	bit	1		dbo.D_0
	ModRulePerilSetCode	Numeric code for the single peril or set of perils that can be used as a filter in a loss modification template rule.	int	4
	IsReinsurance	Indicates whether the peril is supported in Touchstone Re. 1 = Yes (supported) 0 = No (not supported)	bit	1
	UIOrder	Order of the peril in the user interface. The order specifies where the peril appears in configuration screens.	tinyint	1

Objects that tPeril depends on

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

See Also

Related Objects

AIRReference Database

© 2021. 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.