tIntensityAttribute Table

Touchstone 2022 Database Reference

tIntensityAttribute Table

Collapse All

AIRReference Database : tIntensityAttribute Table

Description

Stores information about the intensity attributes that may be used during a hazard analysis.

Properties

Creation Date	10/22/2014 3:18 PM
File Group	PRIMARY
Text File Group
System Object
Published for Replication
Rows	27
Data Space Used	8.00 KB
Index Space Used	8.00 KB

Columns

	Column Name	Description	Datatype	Length	Allow Nulls	Default	Formula
	IntensityAttributeCode	Code that represents the intensity attribute types. 101 = Earthquake 102 = Tropical Cyclone 103 = Peak Ground Acceleration 104 = Spectral Acceleration 0.3 seconds 105 = Spectral Acceleration 1.0 seconds 106 = Maximum Wind Speed 107 = Duration 108 = Storm Surge Depth 109 = Event Set SID 110 = Disaggregation 111 = Average Properties 112 = Maximum Wind Speed Unit 113 = Storm Surge Depth Unit 114 = Duration Unit 115 = Peak Ground Acceleration Unit 116 = Spectral Acceleration 0.3 seconds 117 = Spectral Acceleration 1.0 seconds 118 = Inland Flood 119 = Coastal Flood 120 = Inland On Plain Flood Depth 121 = Coastal On Plain Flood Depth 122 = Inland On Plain Flood Depth Unit 123 = Coastal On Plain Flood Depth Unit	smallint	2
	OutputTypeCode	Code that represents the type of output generated during the analysis. For a complete list of codes, see dbo.tOutputType Table.	varchar	10
	IntensityAttributeTypeCode	Code that represents how the intensity attribute parameter is presented. For a complete list of codes, see dbo.tIntensityAttributeType Table.	varchar	5
	SubsetIntensityAttributeCode	Code that represents the intensity attribute types. This value is a subset of the primary intensity attribute identified in IntensityAttributeCode.	smallint	2
	IntensityAttribute	Name of the attribute. Corresponds to the code in IntensityAttributeCode.	varchar	255
	IntensityFieldName	Database field name for the attribute.	varchar	255
	IntensityFieldType	Datatype for the IntensityFieldName.	varchar	40
	Description	Description of the attribute type.	varchar	1024
	IntensityAttributeTableReferenceCode	Reserved for future use.	smallint	2
	DefaultValue	Reserved for future use.	varchar	1024
	SortOrder	Reserved for future use.	smallint	2

Objects that tIntensityAttribute 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
	tIntensityAttributeType	Table	Stores parameter options for the intensity attribute.	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.