Touchstone 4.0 Database Documentation
tIntensityAttribute Table
Description
Stores information about the intensity attributes that may be used during a Hazard analysis.
Properties
Creation Date10/22/2014 3:18 PM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows17
Data Space Used8.00 KB
Index Space Used8.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key 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
SmallInt2   
 OutputTypeCode

Code that represents the type of output generated during the analysis.

For a complete list of codes, see dbo.tOutputType Table.

VarChar10   
 IntensityAttributeTypeCode

Code that represents how the intensity attribute parameter is presented.

For a complete list of codes, see dbo.tIntensityAttributeType Table.

VarChar5   
 SubsetIntensityAttributeCode

Code that represents the intensity attribute types. This value is a subset of the primary intensity attribute identified in IntensityAttributeCode.

SmallInt2  
 IntensityAttribute

Name of the attribute.

Corresponds to the code in IntensityAttributeCode.

VarChar255  
 IntensityFieldNameDatabase field name for the attribute.VarChar255  
 IntensityFieldTypeDatatype for the IntensityFieldName.VarChar40  
 Description

Description of the attribute type.

VarChar1024  
 IntensityAttributeTableReferenceCodeReserved for future use.SmallInt2  
 DefaultValueReserved for future use.VarChar1024  
 SortOrderReserved for future use.SmallInt2  
Objects that tIntensityAttribute depends on
 Database ObjectObject TypeDescriptionDep Level
tAnalysisType tabletAnalysisTypeTableStores the various analysis types that can be performed in Touchstone.3
tExposureAttributeType tabletExposureAttributeTypeTable

Stores the possible types of exposure attributes used for the Loss analysis results options.

1
tIntensityAttributeType tabletIntensityAttributeTypeTableStores parameter options for the intensity attribute.1
tOutputDetailedAAL tabletOutputDetailedAALTable

Stores information regarding the possible targets to which the Average Annual Loss can apply.

1
tOutputType tabletOutputTypeTable

Stores the possible types of output for each analysis type.

1
tResultGroupBy tabletResultGroupByTable

Stores the possibly categorization (grouping) types for Data Quality analysis results.

1
tResultViewBy tabletResultViewByTable

Stores information identifying the options for viewing results in Touchstone.

2
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.