Touchstone 4.0 Database Documentation
tOutputDetailedAAL Table
Description

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

Properties
Creation Date1/11/2012 11:28 AM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows2
Data Space Used8.00 KB
Index Space Used8.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key OutputDetailedAALCode

Code that represents the the average annual loss target type.

  • CONSUM = Contract Summary Event Loss
  • LOCSUM = Location Summary Event Loss
VarChar10   
 OutputDetailedAAL

Name of the target type.

Corresponds to the code in OutputDetailedAALCode.

VarChar40   
 Description

Description of the target type.

VarChar1024  
Objects that depend on tOutputDetailedAAL
 Database ObjectObject TypeDescriptionDep Level
tDQRuleSetType tabletDQRuleSetTypeTable

Stores the primary rule sets that can be applied during a Data Quality analysis.

2
tHazardAttribute tabletHazardAttributeTable

Stores the possible the attributes of a hazard.

2
tIntensityAttribute tabletIntensityAttributeTableStores information about the intensity attributes that may be used during a Hazard analysis.2
tOutputTable tabletOutputTableTable

Stores the database tables where the output is stored.

1
tOutputType tabletOutputTypeTable

Stores the possible types of output for each analysis type.

1
tResultTemplate tabletResultTemplateTable

Stores the association between output types and the results.

1
tResultTemplateFilterAttributeXRef tabletResultTemplateFilterAttributeXRefTableSystem reference table used to determine the filter attributes that are applied to the results.2
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.