Touchstone 4.0 Database Documentation
tHazardAnalysisAttributeOption Table
Description
Stores information about the attributes applied during a Hazard analysis.
Properties
Creation Date5/31/2016 9:45 AM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows144
Data Space Used8.00 KB
Index Space Used56.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key AnalysisSID

Unique system-generated sequential identifier for the analysis  record.

For a complete list of records, see tAnalysis Table.

Integer4   
Primary Key OutputTypeCode

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

For a complete list of codes, see tOutputType Table.

VarChar10   
Primary Key HazardAttributeCode

Code that represents the hazard attribute selected for a given analysis.

For a complete list of codes, see tHazardAttribute Table.

SmallInt2   
 UnitCode

Code for the unit of measure used to express the radius of the attribute.

For a complete list of codes, see tUnit Table.

VarChar10  
 IsAttributeEnabled

Indicates whether an attribute is enabled for a given analysis.

  • 1 = Yes (enabled)
  • 0 = No (disabled)
Boolean1  
 IsFlagEnabled

Indicates whether the Hazard analysis results are displayed on the user interface.

  • 1 = Yes (displayed)
  • 0 = No (not displayed)
Boolean1  
 FlagMinValueMinimum value boundary upon which the flag is triggered.Numeric9 (16,7)  
 FlagMaxValueMaximum value boundary upon which the flag is triggered.Numeric9 (16,7)  
 FlagValueListBoundary (minimum or maximum) or other values that may trigger the flag.VarChar1000  
Objects that tHazardAnalysisAttributeOption depends on
 Database ObjectObject TypeDescriptionDep Level
tAnalysis tabletAnalysisTableStores information about each sub-section of the activity output. Each activity task creates and writes to this table as the task is performed.1
tDataServer tabletDataServerTableStores information about each data server used in the project, including its sequential identifier (SID), name, description, connection information, and default MDF and LDF paths.3
tDataSource tabletDataSourceTableStores information about the data source used for the Touchstone project. A data source is a database that is registered with the Touchstone application.2
tHazardAnalysisOutputOption tabletHazardAnalysisOutputOptionTableStores information regarding the output from a Hazard analysis.2
tProject tabletProjectTableStores information regarding the project, such as project name and status code.1
See Also

Related Objects

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