Touchstone 2022 Database Reference
tRRRR_DQ_AUG_ConsistencyResultSummary Table
AIRExposureSummary Database : tRRRR_DQ_AUG_ConsistencyResultSummary Table
Description
Stores information regarding the number/percent of locations and replacement values that were in violation of each rule during the Data Quality - Augmentation analysis.
Properties
Creation Date4/11/2022 6:15 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 ResultSummarySID

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

For a complete list of records, see tAnalysisResult Table.

int4   
 RuleSID

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

For a complete list of records, see tDQAnalysisRule Table.

int4  
 RuleNameName of the rule that triggered the augmentation.varchar8000  
 LocationsNumber of flagged location(s) that were in violation of the rule.int4  
 PercentLocationsPercent of the total locations that were in violation of the rule.real4  
 TotalReplacementValueTotal replacement value for the locations that were in violation of the rule.float9  
 PercentTotalReplacementValuePercent of the total replacement value for the locations that were in violation of the rule.real4  
See Also

Related Objects

AIRExposureSummary Database

 

 

Verisk Analytics Client Confidential

© 2022. AIR Worldwide is now Extreme Event Solutions. AIR Worldwide is a registered trademark. Touchstone is a registered trademark of AIR Worldwide.

Please contact Verisk Analytics with questions or comments.