Touchstone 2022 Database Reference
tDQAnalysisRuleSetRuleSubTypeSelected Table
AIRProject Database : tDQAnalysisRuleSetRuleSubTypeSelected Table
Description
Stores information regarding the rule sub type used during the Data Quality analysis.
Properties
Creation Date4/4/2022 3:02 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 

Code representing the sub type of the Data Quality rule.

For a complete list of codes, see  tDQRuleSubType Table.

int4   
Primary Key System-generated sequential identifier for the Data Quality sub-type rule set record.int4   
 

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

For a complete list of records, see tDQAnalysisRuleSet Table.

int4   
 

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

  • 1 = Yes (selected)
  • 0 = No (not selected)
bit1  
Objects that tDQAnalysisRuleSetRuleSubTypeSelected depends on
 Database ObjectObject TypeDescriptionDep Level
tAnalysis tabletAnalysisTableStores information about each analysis.4
tDataQualityAnalysisOption tabletDataQualityAnalysisOptionTableStores information regarding the augmentation of data during a Data Quality analysis.3
tDataQualityAnalysisOutputOption tabletDataQualityAnalysisOutputOptionTableStores the output options for a Data Quality analysis.2
tDataSource tabletDataSourceTable

Stores information about the databases registered with the application, for example, the exposure and results databases.

5
tDQAnalysisRuleSet tabletDQAnalysisRuleSetTableStores information regarding the rule sets used during a Data Quality analysis.1
tProject tabletProjectTableStores information about each project, for example, the project name and status code.5
See Also

Related Objects

AIRProject Database