Stores data relating to the rules used in a Data Quality analysis.
Touchstone 2022 Database Reference
tDQAnalysisRule Table
| Creation Date | 4/4/2022 3:02 AM |
| File Group | PRIMARY |
| Text File Group | PRIMARY |
| 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 | |
|---|---|---|---|---|---|---|---|
 | RuleSID | Unique system-generated sequential identifier for the Data Quality rule record. | int | 4 | |||
| DQRuleSubTypeCode | Code representing the sub-type of the Data Quality rule. For a complete list of codes, see tDQRuleSubType Table. | int | 4 | ||||
| DQRuleTierCode | Code representing the tier of the Data Quality rule. For a complete list of codes, see tDQRuleTier Table. | int | 4 | ||||
| RuleSetSID | Unique system-generated sequential identifier for the Data Quality rule set record. For a complete list of records, see tDQAnalysisRuleSet Table. | int | 4 | ||||
| RuleName | User-provided name for the rule. | varchar | 8000 |  | |||
| SuspiciousDataFactor | Factor that is applied when reasonability checks fail. Reserved for future use. | float | 9 | | |||
| MaxQualityScore | Maximum Data Quality score value. Integer ranges from 0-100, with 100 representing the highest quality. | int | 4 | | |||
| IndustryMatchNoneFactor | Reserved for future use. Factor to be applied when the value for this location does not match the value in the industry data sources. | int | 4 | | |||
| IndustryMatchRelaxedFactor | Reserved for future use. Factor to be applied when the value for this location does not exactly match the value in available industry data sources, but matches a distribution of values for the location's postal code. | int | 4 | | |||
| AppliesToLocationType | Flag indicating the location types to which the rule applies. | int | 4 | | |||
| AppliesToPeril | Flag indicating the peril set code to which the rule applies. | int | 4 | | |||
| Expression | XML expression of a given rule. Used internally by Touchstone. | xml | 0 | | |||
| TargetObjectPaths | Paths for target objects of the rule. Used internally by Touchstone. | varchar | 1000 | | |||
| ExpectedResult | Indicates whether the rule passes or fails when conditions are met.
| bit | 1 | | |||
| RuleSetName | User-provided name of the Data Quality rule set. | varchar | 255 | | |||
| DQRuleSubType | Description of the rule sub-type. For a complete list of rule sub-types, see tDQRuleSubType Table. | varchar | 255 | | |||
| DQRuleTier | Description of the Data Quality rule tier. For a complete list of rule tiers, see tDQRuleTier Table. | varchar | 255 | | |||
| IsEnabled | Indicates whether the object is enabled for use.
| bit | 1 | | |||
| IsSelected | Indicates whether the object is selected on the user interface.
| bit | 1 | | |||
| RuleTemplateSID | Unique system-generated sequential identifier for the rule template record. This template was the source of a provided rule report record. For a complete list of records, see tDQRuleTemplate Table, | int | 4 | | |||
| AppliesToRegion | Reserved for future use.Identifies any region to which the rule apples. | int | 4 | |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
 | tAnalysis | Table | Stores information about each analysis. | 4 |
| tDataQualityAnalysisOption | Table | Stores information regarding the augmentation of data during a Data Quality analysis. | 3 |
| tDataQualityAnalysisOutputOption | Table | Stores the output options for a Data Quality analysis. | 2 |
| tDataSource | Table | Stores information about the databases registered with the application, for example, the exposure and results databases. | 5 |
| tDQAnalysisRuleSet | Table | Stores information regarding the rule sets used during a Data Quality analysis. | 1 |
| tProject | Table | Stores information about each project, for example, the project name and status code. | 5 |