Touchstone 4.0 Database Documentation
tRRRR_DQ_AUG_ResultValues Table
Description
Defines actual values referenced by the augmentation rules. Stores both user and industry value for easy comparison and augmentation. Referenced by the  tRRRR_DQ_AUG_ResultDetail Table to provide multiple values per location. Each location affected by the augmentation should have an ISOBIN record within this table to keep track of the augmentation data source.
Properties
Creation Date5/31/2016 9:45 AM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows0
Data Space Used0.00 KB
Index Space Used0.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key ResultDetailSID

Unique system-generated sequential identifier for the detailed results record.

For a complete list of records, see tAnalysisResult Table.

Integer4   
Primary Key DQValueClassCode

Code that represents the Data Quality class.

For a complete list of names, see tDQValueClass Table.

Integer4   
Primary Key RuleSID

Unique system-generated sequential identifier for the data quality rule record.

For a complete list of records, see tDQAnalysisRule Table.

Integer4   
 DQValueClass

Name of the Data Quality class.

VarChar255  
 ValueUserAugmentation value.VarChar255  
 ValueUserDescriptionText description of the user's value.  When the value is a code, this field contains the description for the code.VarChar200  
 ValueIndustry

Augmentation value

VarChar200  
 ValueIndustryDescription

Description of the industry value.  When the industry value is a code, the code's description is used.

VarChar200  
 IndDataSourceSource for the augmented data, such as Property Exposure or User Specified.VarChar200  
 IsAccepted

Indicates whether the augmented value was accepted or rejected by the user.

  • 1 = Yes (accepted)
  • 0 = No (rejected)
Boolean1  
 TargetSID

Unique system-generated sequential identifier for the record against which the analysis is performed.  This identification is used when the  record cannot be identified via the ResultDetailSID.

For a complete list of records, see tAnalysisTarget Table.

Integer4   
 OriginalValueIndustryOriginal value before augmentation.VarChar200  
 IsConsistent

Indicates whether the augmented value is consistent. 

  • 1 = Yes (consistent)
  • 0 = No (inconsistent)
Boolean1   
Objects that tRRRR_DQ_AUG_ResultValues depends on
 Database ObjectObject TypeDescriptionDep Level
tRRRR_DQ_AUG_ResultDetail tabletRRRR_DQ_AUG_ResultDetailTableReport detail results for the Data Quality - Augmentation reports.1
See Also

Related Objects

AIRResult
Locating Results for a Specific Analysis

 

 


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.