Touchstone 4.0 Database Documentation
tDQRuleSetTemplate Table
Description

Stores information about the Data Quality rules set templates that are available in Touchstone. 

Properties
Creation Date5/31/2016 9:46 AM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows8
Data Space Used8.00 KB
Index Space Used40.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key RuleSetSID

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

Integer4   
 BusinessUnitSID

Unique system-generated sequential identifier for the business unit record.

Integer4   
 DQRuleSetTypeCode

Code for the rule set type.

For a complete list of codes, see tDQRuleSetType Table.

Integer4   
 RuleSetName

Name of the rule set.

VarChar255  
 RuleSetSourceSource of the rule set (client's name).VarChar255  
 AuthorName of the person who created the rule set.VarChar255  
 DateCreatedDate and time when the rule set was created.DBTimeStamp4  
 ModifiedByName of the person who last modified the rule set.VarChar255  
 DateUpdatedDate and time when the rule set was last modified.DBTimeStamp4  
 IsEnabled

Indicates whether the rule set is available for use

  • 1 = Yes (enabled)
  • 0 = No (disabled)
Boolean1  
 NotesAny user-provided notes and/or descriptions.VarChar4000  
Objects that depend on tDQRuleSetTemplate
 Database ObjectObject TypeDescriptionDep Level
tDQDefaultRuleSetTemplate tabletDQDefaultRuleSetTemplateTableA reference table used to identify the Data Quality analysis rule sets.1
tDQRuleSetTemplateRuleSubTypeSelected tabletDQRuleSetTemplateRuleSubTypeSelectedTable

Stores information about the rule sub-types that are available in Touchstone.

1
tDQRuleTemplate tabletDQRuleTemplateTable

Stores information about the Data Quality rules that are available in Touchstone. 

1
See Also

Related Objects

AIRUserSetting 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.