Touchstone 4.0 Database Documentation
tDQAnalysisResultStatistics Table
Description
Stores the statistical information for the Data Quality analysis.
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 ResultSID

Unique system-generated sequential identifier for the results record.

For a complete list of records, see tAnalysisResult Table.

Integer4   
Primary Key OutputTypeCode

Code that represents the type of output generated during the analysis.

For a complete list of codes, see tOutputType Table.

VarChar10   
 LocationsProcessedNumber of locations processed by the Data Quality analysis. Integer4  
 LocationsAffectedNumber of locations that triggered a rules violation during the Data Quality analysis.Integer4  
 ValuesAffectedNumber of values flagged or updated during the Data Quality - Augmentation analysisInteger4  
 TotalRVProcessedTotal replacement value for all the locations analyzed during the Data Quality analysis.Double9  
 TotalRVAffectedTotal replacement value for all the locations updated during the DAta Quality analysis.Double9  
 TotalIVProcessedTotal insured value for all the locations analyzed during the Data Quality analysis.Double9  
 TotalIVAffectedTotal insured value for all the locations updated during the Data Quality analysis.Double9  
 PoliciesProcessedNumber of policies processed during the Data Quality analysis.Integer4  
 PoliciesAffectedNumber of policies whose locations triggered a rules violation during the Data Quality analysis.Integer4  
 ExposureSetsProcessedNumber of books processed during the Data Quality analysis.Integer4  
 ExposureViewsProcessedNumber of business units processed during the Data Quality analysis.Integer4  
 LocationsSkippedNumber of locations skipped during the Data Quality analysis.Integer4  
 LocationsDQNotMatchedNumber of locations that could not be matched during the Data Quality analysis.Integer4  
 LocationsDQMatchedUpdatedNumber of locations that were matched and updated during the Data Quality analysis.Integer4  
 LocationsDQMatchedNotUpdatedNumber of locations that were matched but not updated during the Data Quality analysis.Integer4  
 LocationsUserValueUpdatedNumber of locations whose values were updated using user-provided data.Integer4  
 LocationsCalculationUpdated

Number of locations whose values were updated from the calculation of Coverage A. When Coverage A is updated, Touchstone updates other coverage and limits  as well.

Integer4  
 LocationsMultiRiskSkippedNumber of locations skipped during the Data Quality analysis because the Risk Count was greater than one.Integer4  
 LocationsMultiDQMatchSkippedNumber of locations skipped during the Data Quality analysis due to multiple matches.Integer4  
 ChangeInUserRVChange in the user's replacement value after a Data Quality analysis.Double9  
 LocationsInvalidAddressSkippedNumber of locations skipped during the Data Quality analysis due to invalid address.Integer4  
 LocationsSpecialOccOrConstSkippedNumber of locations with special occupancy or construction classes that were skipped during the Data Quality analysis.Integer4  
 LocationsNoRuleConditionsMetSkippedNumber of locations skipped during the Data Quality analysis due to No Rules matching.Integer4  
 LocationsAvailableToMatchNumber of valid locations during a Data Quality analysisInteger4  
 LocationsSingleMatchedNotUpdatedNumber of locations that had a single match, but were not updated during the Data Quality analysis.Integer4  
 LocationsSingleMatchedUpdatedNumber of locations that had a single match and were updated during the Data Quality analysis.Integer4  
 LocationsPSDUpdated

Number of locations in the Property-Specific database that were updated during the Data Quality analysis.

Integer4  
 LocationsPSDAndUserValueUpdatedNumber of locations in the Property-Specific database, as well as user-provided values, that were updated during the Data Quality analysis.Integer4  
 LocationsDuplicateAddressSkippedNumber of locations with duplicate addresses that were updated during the Data Quality analysis.Integer4  
 LocationsMultiBINMatchNumber of locations with multiple invalid ISOBIN matches that were skipped during the augmentation analysis.Integer4  
 UniqueBINSNumber of locations with unique ISOBIN values.Integer4  
 ScoreDataQualityOverall data quality score.Double9  
 ScoreBaseRiskIndexOverall risk index score.Double9  
 ScoreAdjustedRiskIndexOverall adjusted risk index score.Double9  
 LocationsNotProcessedNumber of locations that were not analyzed during the Data Quality analysis.Integer4  
 PoliciesNotProcessedNumber of policies that were not analyzed during the Data Quality analysis.Integer4  
 TotalRVNotProcessedNumber of replacement values that were not analyzed during the Data Quality analysis.Double9  
 ScoreDataQualityUncertainty

The Data Quality Uncertainty score.

For additional information about calculating the Data Quality Uncertainty score, see the ScoreDQU column in tRRRR_DQ_SCR_ResultDetail Table.

Double9  
Objects that depend on tDQAnalysisResultStatistics
 Database ObjectObject TypeDescriptionDep Level
tDQAUGPrePostSummaryCoverage tabletDQAUGPrePostSummaryCoverageTableStores pre- and post-summary coverage data. The data stored is used as part of the Data Quality - Augmentation PDF 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.