tHazardAttribute Table

Touchstone 2022 Database Reference

tHazardAttribute Table

Collapse All

AIRReference Database : tHazardAttribute Table

Description

Stores the possible the attributes of a hazard.

Properties

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

Columns

	Column Name	Description	Datatype	Length	Allow Nulls	Default	Formula
	HazardAttributeCode	Code that represents the hazard attribute. 101 = Earthquake 100 Year Loss Level 102 = Earthquake 250 Year Loss Level 103 = Earthquake Average Annual Loss 104 = Earthquake Relative Risk County 105 = Earthquake Relative Risk State 106 = Earthquake Soil Type 107 = Earthquake California DOI Zone 108 = Earthquake Liquefaction Potential 109 = Earthquake Landslide Zone 110 = Earthquake Alquist-Priolo Fault Zone 111 = Earthquake Intensity by Probability of Exceedance (PE) 112 = Earthquake Intensity by Return Period 113 = Earthquake Nearest Fault Name 114 = Earthquake Distance to Nearest Fault 115 = Earthquake Distance to Nearest Faults 116 = Historical Earthquakes 117 = Top Historical Earthquake Name 118 = Top Historical Earthquake Date 119 = Top Historical Earthquake Magnitude 120 = Earthquake MMI PE VI 121 = Earthquake MMI PE VII 122 = Earthquake MMI PE VIII 123 = Earthquake MMI PE IX 124 = Earthquake MMI PE X 125 = Earthquake MMI PE XI 126 = Earthquake MMI PE XII 127 = Earthquake 100 Year MMI Intensity by Return Period 128 = Earthquake 200 Year MMI Intensity by Return Period 129 = Earthquake 250 Year MMI Intensity by Return Period 130 = Earthquake 475 Year MMI Intensity by Return Period 201 = Tropical Cyclone 100 Year Loss Level 202 = Tropical Cyclone 250 Year Loss Level 203 = Tropical Cyclone Average Annual Loss 204 = Tropical Cyclone Relative Risk County 205 = Tropical Cyclone Relative Risk State 206 = Tropical Cyclone Storm Surge Potential 207 = Tropical Cyclone Distance to effective (AIR) coast 208 = Tropical Cyclone Distance to actual (ISO) coast 209 = Tropical Cyclone Coastal County 210 = Tropical Cyclone Elevation 211 = Tropical Cyclone Terrain 212 = Tropical Cyclone Florida Wind Mitigation – Exposure Area 213 = Tropical Cyclone Florida Wind Mitigation – Wind Speed Region 214 = Tropical Cyclone Florida Wind Mitigation – Windborne Debris Region 215 = Tropical Cyclone Florida Wind Mitigation – High Velocity Wind Region 216 = Historical Hurricanes 217 = Top Historical Hurricane Name 218 = Top Historical Hurricane Date of Landfall 219 = Top Historical Hurricane Intensity at Closest Location 220 = SS Storm Surge Category 221 = Shortest Distance to 100 Year SS Storm Surge 222 = Shortest Distance to 250 Year SS Storm Surge 223 = Shortest Distance to 500 Year SS Storm Surge 224 = Depth for 100 year Storm Surge 225 = Depth for 250 year Storm Surge 226 = Depth for 500 year Storm Surge 227 = Florida Wind Mitigation – Exposure Area 2010 228 = Florida Wind Mitigation – Wind Speed Region 2010 229 = Florida Wind Mitigation – Windborne Debris Region 2010 230 = Florida Wind Mitigation – High Velocity Wind Region 2010 301 = Severe Thunderstorm 100 Year Loss level 302 = Severe Thunderstorm 250 Year Loss Level 303 = Severe Thunderstorm Average Annual Loss 304 = Severe Thunderstorm Relative Risk County 305 = Severe Thunderstorm Relative Risk State 306 = Severe Thunderstorm Tornado Frequency 307 = Severe Thunderstorm Hail Storm Frequency 308 = Severe Thunderstorm Straight-Line Wind Storm Frequency 309 = Severe Thunderstorm Nearest Historical Tornados 310 = Severe Thunderstorm Nearest Historical Hail Storms 311 = Severe Thunderstorm Nearest Historical Straight-Line Windstorms 312 = Severe Thunderstorm Nearest Historical Tornados Date 313 = Severe Thunderstorm Nearest Historical Tornados Severity 314 = Severe Thunderstorm Nearest Historical Hail Storms Date 315 = Nearest Historical Hail Storm Severity 316 = Nearest Historical Straight-Line Wind Storms Date 317 = Severe Thunderstorm Nearest Historical Straight-Line Windstorms Severity 401 = Winter Storm 100 Year Loss Level 402 = Winter Storm 250 Year Loss Level 403 = Winter Storm Average Annual Loss 404 = Winter Storm Relative Risk County 405 = Winter Storm Relative Risk State 406 = Winter Storm Damaging Wind Frequency 407 = Winter Storm Damaging Snow Frequency 501 = Flood Source 502 = Flood Zone 503 = FEMA Flood Zone 504 = Elevation 505 = Shortest Distance to FEMA Water Body 506 = Shortest Distance to 100-year Flood Plain 507 = Shortest Distance to 500-year Flood Plain 508 = Base Flood Elevation 509 = AIR Flood Zone Category 510 = AIR Shortest Distance to 100-year Flood Plain 511 = AIR Shortest Distance to 500-year Flood Plain 601 = Terrorism 100 Year Loss Level 602 = Terrorism 250 Year Loss Level 603 = Terrorism Average Annual Loss 604 = Terrorism Relative Risk County 605 = Terrorism Relative Risk State 606 = Terrorism Distance to Nearest Landmark 607 = Terrorism Landmark Type 701 = Construction 702 = Occupancy 703 = Replacement Value A 704 = Replacement Value B 705 = Replacement Value C 706 = Replacement Value D	smallint	2
	OutputTypeCode	Code that represents the output type. For a complete list of codes, see tOutputType Table.	varchar	10
	HazardAttributeTypeCode	Code that represents the hazard attribute type, which is used to indicate if the attribute takes a range of value or just single value. For a complete list of codes, see tHazardAttributeType Table.	varchar	5
	SubsetHazardAttributeCode	Code that represents the hazard attribute subset hierarchy when applicable. For example, HazardAttributeCodes 117, 118, and 119 have a SubsetHazardAttributeCode of 116. The codes are the same as listed in HazardAttributeCode.	smallint	2
	HazardAttribute	Name of the hazard attribute. Corresponds to the code in HazardAttributeCode.	varchar	255
	HazardFieldName	Name for the hazard attribute type.	varchar	255
	HazardFieldType	SQL data type used to display the hazard field information.	varchar	40
	Description	Description of the hazard attribute.	varchar	1024
	HazardAttributeTableReferenceCode	Code that represents the reference table for the hazard attribute. For a complete list of codes, see tHazardAttributeTableReference Table.	smallint	2
	DefaultValue	Identifies whether this is a default value. 1 = Yes (default) 0 = No (not default)	varchar	1024

Objects that tHazardAttribute depends on

	Database Object	Object Type	Description	Dep Level
	tAnalysisType	Table	Stores the analysis types available in the application.	2
	tExposureAttributeType	Table	Stores the possible types of exposure attributes used for the Loss analysis results options.	3
	tHazardAttributeTableReference	Table	A reference table used to determine the possible attributes of a hazard.	1
	tHazardAttributeType	Table	Stores information regarding the possible hazard attribute types.	1
	tOutputDetailedAAL	Table	Stores information regarding the possible targets to which the Average Annual Loss can apply.	3
	tOutputType	Table	Stores the possible types of output for each analysis type.	1
	tResultGroupBy	Table	Stores the possibly categorization (grouping) types for Data Quality analysis results.	3
	tResultViewBy	Table	Stores information identifying the options for viewing results in Touchstone.	2

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.