Touchstone 4.0 Database Documentation
tRRRR_DQ_DVA_Violations Table
Description
Stores all Data Quality - Validation rule violations for each location record in tRRRR_DQ_DVA_ResultDetail Table. Each single table contains detail data for one report and each row represents a failed rule for specific location. The ViolationDescription attribute combines the information from rule and rule set for easy access. (For example "RV A is less than 50000")
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 tRRRR_DQ_DVA_ResultDetail 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   
 DQValueClassCode

Code that represents the exposure attribute that is being violated.

For a complete list of codes, see tDQValueClass Table.

Integer4  
 ViolationDescriptionDescription of the violation, defined by the rule and rule set.VarChar255  
 ValueFailedName of the DQValueClassCode in violation of the rule.VarChar255  
Objects that tRRRR_DQ_DVA_Violations depends on
 Database ObjectObject TypeDescriptionDep Level
tRRRR_DQ_DVA_ResultDetail tabletRRRR_DQ_DVA_ResultDetailTableStores result details for the Data Quality - Validation reports. Each table contains detail data for one report and every location in the report is represented by a record. See tRRRR_DQ_DVA_Violations Table to review the multiple rule violations for each location record.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.