Touchstone 2022 Database Reference
tRRRR_DQ_DVA_Violations Table
AIRResult : 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 Date4/11/2022 5:46 PM
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 

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

For a complete list of records, see tRRRR_DQ_DVA_ResultDetail Table.

int4   
Primary Key 

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

For a complete list of records, see tDQAnalysisRule Table.

int4   
 

Code that represents the exposure attribute that is being violated.

For a complete list of codes, see tDQValueClass Table.

int4  
 Description of the violation, defined by the rule and rule set.varchar255  
 Name 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