Touchstone 4.0 Database Documentation
tDQAnalysisRuleSetRuleSubTypeSelected Table
Description
Stores information regarding the rule sub type used during the Data Quality analysis.
Properties
Creation Date5/31/2016 9:45 AM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows0
Data Space Used0.00 KB
Index Space Used0.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key DQRuleSubTypeCode

Code representing the sub type of the Data Quality rule.

For a complete list of codes, see  tDQRuleSubType Table.

Integer4   
Primary Key RuleSetRuleSubTypeSelectedSIDSystem-generated sequential identifier for the Data Quality sub-type rule set record.Integer4   
 RuleSetSID

Unique system-generated sequential identifier for the Data Quality rule set record.

For a complete list of records, see tDQAnalysisRuleSet Table.

Integer4   
 IsSelected

Indicates if a rule set is selected for use during an analysis.

  • 1 = Yes (selected)
  • 0 = No (not selected)
Boolean1  
Objects that tDQAnalysisRuleSetRuleSubTypeSelected 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
tDataQualityAnalysisOption tabletDataQualityAnalysisOptionTableStores information regarding the augmentation of data during a Data Quality analysis.2
tDataQualityAnalysisOutputOption tabletDataQualityAnalysisOutputOptionTableStores the output options for a Data Quality analysis.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
tDQAnalysisRuleSet tabletDQAnalysisRuleSetTableStores information regarding the rule sets used during a Data Quality analysis.4
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.