Touchstone 4.0 Database Documentation
tDQRuleSetType Table
Description

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

Properties
Creation Date2/16/2011 6:00 PM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows4
Data Space Used8.00 KB
Index Space Used24.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key DQRuleSetTypeCode

Code for the rule set type.

  • 1 = DVA - Completeness
  • 2 = DVA - Reasonability
  • 3 = AUG - Augmentation
  • 4 = AUG - Location Update
Integer4   
 OutputTypeCode

Code that represents the Data Quality diagnostic tool to which the rule set applies. 

For a complete list of codes, see tOutputType Table

VarChar10   
 DQRuleSetType

Name of the rule set type.

Corresponds to the code in DQRuleSetTypeCode.

VarChar200  
 DescriptionDescription of the rule set type.VarChar1024  
Objects that tDQRuleSetType 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
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.