Touchstone 4.0 Database Documentation
tDQRuleTemplate Table
Description

Stores information about the Data Quality rules that are available in Touchstone. 

Properties
Creation Date5/31/2016 9:46 AM
File GroupPRIMARY
Text File GroupPRIMARY
System Object
Published for Replication
Rows256
Data Space Used456.00 KB
Index Space Used64.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key RuleSID

Unique system-generated sequential identifier for the rule record.

Integer4   
 DQRuleSubTypeCode

Code for the rule sub type.

For a complete list of codes, see tDQRuleSubType Table.

Integer4  
 RuleSetSID

Unique system-generated sequential identifier for the rule set record.

For a complete list of records, see tDQRuleSetTemplate Table.

Integer4   
 DQRuleTierCode

Code that represents the Data Quality rule tier.

For a complete list of codes, see tDQRuleTier Table.

Integer4   
 RuleName

Name of the rule.

VarChar8000  
 SuspiciousDataFactorFactor that is applied when the reasonability check fails.Double9  
 MaxQualityScoreMaximum quality score from a Data Quality analysis.Integer4  
 IndustryMatchNoneFactorFactor that is applied when the value for the location does not match the value in the Industry Data source.Integer4  
 IndustryMatchRelaxedFactorFactor 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.Integer4  
 AppliesToLocationTypeIndicates the location types to which the rule applies.  Integer4  
 AppliesToPerilIndicates the peril(s) to which the rule applies.Integer4  
 Expression

XML string that defines the filter conditions.  Used internally by Touchstone.

Xml16  
 TargetObjectPathsTarget of the rule.VarChar1000  
 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.

  • 1 = Yes (passes)
  • 0 = No (fails) 
Boolean1  
 IsEnabled

Indicates whether the rule is available for use

  • 1 = Yes (enabled)
  • 0 = No (disabled)
Boolean1  
 IsSelected

Indicates whether the rule is selected on the user interface.

  • 1 = Yes (selected)
  • 0 = No (not selected)
Boolean1  
 NotesAny user-provided notes and/or descriptions.VarChar4000  
 AppliesToRegionRegion to which the rule set applies.Integer4  
Objects that tDQRuleTemplate depends on
 Database ObjectObject TypeDescriptionDep Level
tDQRuleSetTemplate tabletDQRuleSetTemplateTable

Stores information about the Data Quality rules set templates that are available in Touchstone. 

1
See Also

Related Objects

AIRUserSetting Database

 

 


AIR Client Confidential

© 2016. AIR Worldwide is a registered trademark. Touchstone is a registered trademark of AIR Worldwide.

Please contact AIR Worldwide with questions or comments. For database questions. For documentation comments.