Stores information about the Data Quality rules set templates that are available in Touchstone.
Touchstone 2022 Database Reference
tDQRuleSetTemplate Table
Stores information about the Data Quality rules set templates that are available in Touchstone.
| Creation Date | 4/4/2022 3:02 AM |
| File Group | PRIMARY |
| Text File Group | |
| System Object |  |
| Published for Replication | |
| Rows | 8 |
| Data Space Used | 8.00 KB |
| Index Space Used | 40.00 KB |
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
 | RuleSetSID | Unique system-generated sequential identifier for the rule set record. | int | 4 | |||
| BusinessUnitSID | Unique system-generated sequential identifier for the business unit record. | int | 4 | ||||
| DQRuleSetTypeCode | Code for the rule set type. For a complete list of codes, see tDQRuleSetType Table. | int | 4 | ||||
| RuleSetName | Name of the rule set. | varchar | 255 |  | |||
| RuleSetSource | Source of the rule set (client's name). | varchar | 255 | | |||
| Author | Name of the person who created the rule set. | varchar | 255 | | |||
| DateCreated | Date and time when the rule set was created. | datetime | 4 | | |||
| ModifiedBy | Name of the person who last modified the rule set. | varchar | 255 | | |||
| DateUpdated | Date and time when the rule set was last modified. | datetime | 4 | | |||
| IsEnabled | Indicates whether the rule set is available for use
| bit | 1 | | |||
| Notes | Any user-provided notes and/or descriptions. | varchar | 4000 | |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
 | tDQDefaultRuleSetTemplate | Table | A reference table used to identify the Data Quality analysis rule sets. | 1 |
| tDQRuleSetTemplateRuleSubTypeSelected | Table | Stores information about the rule sub-types that are available in Touchstone. | 1 |
| tDQRuleTemplate | Table | Stores information about the Data Quality rules that are available in Touchstone. | 1 |