Stores the primary rule sets that can be applied during a Data Quality analysis.
Touchstone 2022 Database Reference
tDQRuleSetType Table
Stores the primary rule sets that can be applied during a Data Quality analysis.
| Creation Date | 2/16/2011 6:00 PM |
| File Group | PRIMARY |
| Text File Group | |
| System Object |  |
| Published for Replication | |
| Rows | 4 |
| Data Space Used | 8.00 KB |
| Index Space Used | 24.00 KB |
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
 | DQRuleSetTypeCode | Code for the rule set type.
| int | 4 | |||
| OutputTypeCode | Code that represents the Data Quality diagnostic tool to which the rule set applies. For a complete list of codes, see tOutputType Table | varchar | 10 | ||||
| DQRuleSetType | Name of the rule set type. Corresponds to the code in DQRuleSetTypeCode. | varchar | 200 |  | |||
| Description | Description of the rule set type. | varchar | 1024 | |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
 | tAnalysisType | Table | Stores the analysis types available in the application. | 2 |
| tExposureAttributeType | Table | Stores the possible types of exposure attributes used for the Loss analysis results options. | 3 |
| tOutputDetailedAAL | Table | Stores information regarding the possible targets to which the Average Annual Loss can apply. | 3 |
| tOutputType | Table | Stores the possible types of output for each analysis type. | 1 |
| tResultGroupBy | Table | Stores the possibly categorization (grouping) types for Data Quality analysis results. | 3 |
| tResultViewBy | Table | Stores information identifying the options for viewing results in Touchstone. | 2 |