Stores information regarding the rule sets used during a Data Quality analysis.
Touchstone 2022 Database Reference
tDQAnalysisRuleSet Table
| Creation Date | 4/4/2022 3:02 AM |
| File Group | PRIMARY |
| Text File Group | |
| System Object |  |
| Published for Replication | |
| Rows | 0 |
| Data Space Used | 0.00 KB |
| Index Space Used | 0.00 KB |
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
 | RuleSetSID | Unique system-generated sequential identifier for the Data Quality rule set record. | int | 4 | |||
| DQRuleSetTypeCode | Code representing the type of Data Quality rule set. For a complete list of codes, see tDQRuleSetType Table. | int | 4 | ||||
| AnalysisSID | Unique system-generated sequential identifier for the analysis record. For a complete list of records, see tAnalysis Table. | int | 4 | ||||
| OutputTypeCode | Code that represents the type of output generated during the analysis. For a complete list of codes, see tOutputType Table. | varchar | 10 | ||||
| RuleSetName | User-specified name of the Data Quality rule set. | varchar | 255 |  | |||
| RuleSetSource | Identifies the source of the rule set (AIR or customer). | varchar | 255 | | |||
| Author | User that created the rule set. | varchar | 255 | | |||
| DateCreated | Date and time the rule set was created. | datetime | 4 | | |||
| DateCompleted | Date and time the rule set was updated. | datetime | 4 | | |||
| 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. | int | 4 | | |||
| Notes | User-provided notes and descriptions for the rule set. | varchar | 4000 | |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
 | tDQAnalysisRule | Table | Stores data relating to the rules used in a Data Quality analysis. | 1 |
| tDQAnalysisRuleSetRuleSubTypeSelected | Table | Stores information regarding the rule sub type used during the Data Quality analysis. | 1 |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
| tAnalysis | Table | Stores information about each analysis. | 3 |
| tDataQualityAnalysisOption | Table | Stores information regarding the augmentation of data during a Data Quality analysis. | 2 |
| tDataQualityAnalysisOutputOption | Table | Stores the output options for a Data Quality analysis. | 1 |
| tDataServer | Table | Stores information about each data server associated with the project, including the sequential identifier (SID), name, description, connection information, and default MDF and LDF paths for the server. | 5 |
| tDataSource | Table | Stores information about the databases registered with the application, for example, the exposure and results databases. | 4 |
| tExposureSet | Table | Stores exposure set information from each exposure database on the server. | 5 |
| tProject | Table | Stores information about each project, for example, the project name and status code. | 4 |