Touchstone 4.0 Database Documentation
tDQAnalysisRule Table
Description
Stores data relating to the rules used in a Data Quality analysis.
Properties
Creation Date5/31/2016 9:45 AM
File GroupPRIMARY
Text File GroupPRIMARY
System Object
Published for Replication
Rows0
Data Space Used0.00 KB
Index Space Used0.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key RuleSIDUnique system-generated sequential identifier for the Data Quality rule record.Integer4   
 DQRuleSubTypeCode

Code representing the sub-type of the Data Quality rule.

For a complete list of codes, see  tDQRuleSubType Table.

Integer4   
 DQRuleTierCode

Code representing the tier of the Data Quality rule.

For a complete list of codes, see tDQRuleTier Table.

Integer4   
 RuleSetSID

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

For a complete list of records, see tDQAnalysisRuleSet Table.

Integer4   
 RuleNameUser-provided name for the rule.VarChar8000  
 SuspiciousDataFactorFactor that is applied when reasonability checks fail.  Reserved for future use.Double9  
 MaxQualityScoreMaximum Data Quality score value. Integer ranges from 0-100, with 100 representing the highest quality.Integer4  
 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. 

Integer4  
 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.

Integer4  
 AppliesToLocationTypeFlag indicating the  location types to which the rule applies.Integer4  
 AppliesToPerilFlag indicating the  peril set code to which the rule applies.Integer4  
 ExpressionXML expression of a given rule. Used internally by Touchstone.Xml16  
 TargetObjectPathsPaths for target objects of the rule.  Used internally by Touchstone.VarChar1000  
 ExpectedResult

Indicates whether the rule passes or fails when conditions are met.

  • 1 = Yes (passes)
  • 0 = No (fails)
Boolean1  
 RuleSetNameUser-provided name of the Data Quality rule set.VarChar255  
 DQRuleSubType

Description of the rule sub-type.

For a complete list of rule sub-types, see  tDQRuleSubType Table.

VarChar255  
 DQRuleTier

Description of the Data Quality rule tier.

For a complete list of rule tiers, see tDQRuleTier Table.

VarChar255  
 IsEnabled

Indicates whether the object is enabled for use.

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

Indicates whether the object is selected on the user interface.

  • 1 = Yes (selected)
  • 0 = No (not selected)
Boolean1  
 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,

Integer4  
 AppliesToRegionReserved for future use.Identifies any region to which the rule apples. Integer4  
Objects that tDQAnalysisRule depends on
 Database ObjectObject TypeDescriptionDep Level
tAnalysis tabletAnalysisTableStores information about each sub-section of the activity output. Each activity task creates and writes to this table as the task is performed.1
tDataQualityAnalysisOption tabletDataQualityAnalysisOptionTableStores information regarding the augmentation of data during a Data Quality analysis.2
tDataQualityAnalysisOutputOption tabletDataQualityAnalysisOutputOptionTableStores the output options for a Data Quality analysis.3
tDataSource tabletDataSourceTableStores information about the data source used for the Touchstone project. A data source is a database that is registered with the Touchstone application.2
tDQAnalysisRuleSet tabletDQAnalysisRuleSetTableStores information regarding the rule sets used during a Data Quality analysis.4
tProject tabletProjectTableStores information regarding the project, such as project name and status code.1
See Also

Related Objects

AIRProject 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.