Stores information about the Data Quality rules that are available in Touchstone.
Touchstone 2022 Database Reference
tDQRuleTemplate Table
Stores information about the Data Quality rules that are available in Touchstone.
| Creation Date | 4/4/2022 3:02 AM |
| File Group | PRIMARY |
| Text File Group | PRIMARY |
| System Object |  |
| Published for Replication | |
| Rows | 256 |
| Data Space Used | 472.00 KB |
| Index Space Used | 64.00 KB |
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
 | RuleSID | Unique system-generated sequential identifier for the rule record. | int | 4 | |||
| DQRuleSubTypeCode | Code for the rule sub type. For a complete list of codes, see tDQRuleSubType Table. | int | 4 |  | |||
| RuleSetSID | Unique system-generated sequential identifier for the rule set record. For a complete list of records, see tDQRuleSetTemplate Table. | int | 4 | ||||
| DQRuleTierCode | Code that represents the Data Quality rule tier. For a complete list of codes, see tDQRuleTier Table. | int | 4 | ||||
| RuleName | Name of the rule. | varchar | 8000 | | |||
| SuspiciousDataFactor | Factor that is applied when the reasonability check fails. | float | 9 | | |||
| MaxQualityScore | Maximum quality score from a Data Quality analysis. | int | 4 | | |||
| IndustryMatchNoneFactor | Factor that is applied when the value for the location does not match the value in the Industry Data source. | int | 4 | | |||
| IndustryMatchRelaxedFactor | Factor that is applied when the value for the location does not exactly match the value in the Industry Data source., but matches a distribution of values for the location's postal code. | int | 4 | | |||
| AppliesToLocationType | Indicates the location types to which the rule applies. | int | 4 | | |||
| AppliesToPeril | Indicates the peril(s) to which the rule applies. | int | 4 | | |||
| Expression | XML string that defines the filter conditions. Used internally by Touchstone. | xml | 0 | | |||
| TargetObjectPaths | Target of the rule. | varchar | 1000 | | |||
| ExpectedResult | Indicates whether the rule passes (or fails) when conditions are met. When the condition results match the expected results, the rule passes, otherwise it fails.
| bit | 1 | | |||
| IsEnabled | Indicates whether the rule is available for use
| bit | 1 | | |||
| IsSelected | Indicates whether the rule is selected on the user interface.
| bit | 1 | | |||
| Notes | Any user-provided notes and/or descriptions. | varchar | 4000 | | |||
| AppliesToRegion | Region to which the rule set applies. | int | 4 | |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
 | tDQRuleSetTemplate | Table | Stores information about the Data Quality rules set templates that are available in Touchstone. | 1 |