Touchstone 4.0 Database Documentation
tDQAnalysisRuleSet Table
Description
Stores information regarding the rule sets used during a 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 RuleSetSIDUnique system-generated sequential identifier for the Data Quality rule set record.Integer4   
 DQRuleSetTypeCode

Code representing the type of Data Quality rule set.

For a complete list of codes, see tDQRuleSetType Table.

Integer4   
 AnalysisSID

Unique system-generated sequential identifier for the analysis record.

For a complete list of records, see tAnalysis Table.

Integer4   
 OutputTypeCode

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

For a complete list of codes, see tOutputType Table.

VarChar10   
 RuleSetNameUser-specified name of the Data Quality rule set.VarChar255  
 RuleSetSourceIdentifies the source of the rule set (AIR or customer).VarChar255  
 AuthorUser that created the rule set.VarChar255  
 DateCreatedDate and time the rule set was created.DBTimeStamp4  
 DateCompletedDate and time the rule set was updated.DBTimeStamp4  
 RuleSetTemplateSID

Unique system-generated sequential identifier for the template  record that used when creating the rule set.

For a complete list of records, see tDQRuleSetTemplate Table.

Integer4  
 NotesUser-provided notes and descriptions for the rule set.VarChar4000  
Objects that depend on tDQAnalysisRuleSet
 Database ObjectObject TypeDescriptionDep Level
tDQAnalysisRule tabletDQAnalysisRuleTableStores data relating to the rules used in a Data Quality analysis.5
tDQAnalysisRuleSetRuleSubTypeSelected tabletDQAnalysisRuleSetRuleSubTypeSelectedTableStores information regarding the rule sub type used during the Data Quality analysis.5
Objects that tDQAnalysisRuleSet 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
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
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.