Stores the statistical information for the Data Quality analysis.
Touchstone 2022 Database Reference
tDQAnalysisResultStatistics Table
| Creation Date | 4/11/2022 6:15 PM |
| File Group | PRIMARY |
| Text File Group | |
| System Object |  |
| Published for Replication | |
| Rows | 0 |
| Data Space Used | 0.00 KB |
| Index Space Used | 0.00 KB |
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
 | ResultSID | Unique system-generated sequential identifier for the results record. For a complete list of records, see tAnalysisResult Table. | int | 4 | |||
| | OutputTypeCode | Unique system-generated sequential identifier for the category record. For a complete list of codes, see tOutputType Table. | varchar | 10 | |||
| LocationsProcessed | Number of locations processed by the Data Quality analysis. | int | 4 |  | |||
| LocationsAffected | Number of locations that triggered a rules violation during the Data Quality analysis. | int | 4 | | |||
| ValuesAffected | Number of values flagged or updated during the Data Quality - Augmentation analysis | int | 4 | | |||
| TotalRVProcessed | Total replacement value for all the locations analyzed during the Data Quality analysis. | float | 9 | | |||
| TotalRVAffected | Total replacement value for all the locations updated during the DAta Quality analysis. | float | 9 | | |||
| TotalIVProcessed | Total insured value for all the locations analyzed during the Data Quality analysis. | float | 9 | | |||
| TotalIVAffected | Total insured value for all the locations updated during the Data Quality analysis. | float | 9 | | |||
| PoliciesProcessed | Number of policies processed during the Data Quality analysis. | int | 4 | | |||
| PoliciesAffected | Number of policies whose locations triggered a rules violation during the Data Quality analysis. | int | 4 | | |||
| ExposureSetsProcessed | Number of books processed during the Data Quality analysis. | int | 4 | | |||
| ExposureViewsProcessed | Number of business units processed during the Data Quality analysis. | int | 4 | | |||
| LocationsSkipped | Number of locations skipped during the Data Quality analysis. | int | 4 | | |||
| LocationsDQNotMatched | Number of locations that could not be matched during the Data Quality analysis. | int | 4 | | |||
| LocationsDQMatchedUpdated | Number of locations that were matched and updated during the Data Quality analysis. | int | 4 | | |||
| LocationsDQMatchedNotUpdated | Number of locations that were matched but not updated during the Data Quality analysis. | int | 4 | | |||
| LocationsUserValueUpdated | Number of locations whose values were updated using user-provided data. | int | 4 | | |||
| 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. | int | 4 | | |||
| LocationsMultiRiskSkipped | Number of locations skipped during the Data Quality analysis because the Risk Count was greater than one. | int | 4 | | |||
| LocationsMultiDQMatchSkipped | Number of locations skipped during the Data Quality analysis due to multiple matches. | int | 4 | | |||
| ChangeInUserRV | Change in the user's replacement value after a Data Quality analysis. | float | 9 | | |||
| LocationsInvalidAddressSkipped | Number of locations skipped during the Data Quality analysis due to invalid address. | int | 4 | | |||
| LocationsSpecialOccOrConstSkipped | Number of locations with special occupancy or construction classes that were skipped during the Data Quality analysis. | int | 4 | | |||
| LocationsNoRuleConditionsMetSkipped | Number of locations skipped during the Data Quality analysis due to No Rules matching. | int | 4 | | |||
| LocationsAvailableToMatch | Number of valid locations during a Data Quality analysis. | int | 4 | | |||
| LocationsSingleMatchedNotUpdated | Number of locations that had a single match, but were not updated during the Data Quality analysis. | int | 4 | | |||
| LocationsSingleMatchedUpdated | Number of locations that had a single match and were updated during the Data Quality analysis. | int | 4 | | |||
| LocationsPSDUpdated | Number of locations in the Property-Specific database that were updated during the Data Quality analysis. | int | 4 | | |||
| LocationsPSDAndUserValueUpdated | Number of locations in the Property-Specific database, as well as user-provided values, that were updated during the Data Quality analysis. | int | 4 | | |||
| LocationsDuplicateAddressSkipped | Number of locations with duplicate addresses that were updated during the Data Quality analysis. | int | 4 | | |||
| LocationsMultiBINMatch | Number of locations with multiple invalid ISOBIN matches that were skipped during the augmentation analysis. | int | 4 | | |||
| UniqueBINS | Number of locations with unique ISOBIN values. | int | 4 | | |||
| ScoreDataQuality | Overall data quality score. | float | 9 | | |||
| ScoreBaseRiskIndex | Overall risk index score. | float | 9 | | |||
| ScoreAdjustedRiskIndex | Overall adjusted risk index score. | float | 9 | | |||
| LocationsNotProcessed | Number of locations that were not analyzed during the Data Quality analysis. | int | 4 | | |||
| PoliciesNotProcessed | Number of policies that were not analyzed during the Data Quality analysis. | int | 4 | | |||
| TotalRVNotProcessed | Replacement values that were not analyzed during the Data Quality analysis. | float | 9 | | |||
| ScoreDataQualityUncertainty | The Data Quality Uncertainty score. For additional information about calculating the Data Quality Uncertainty score, see the ScoreDQU column in dbo.tRRRR_DQ_SCR_ResultDetail Table. | float | 9 | |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
 | tDQAUGPrePostSummaryCoverage | Table | Stores pre- and post-summary coverage data. The data stored is used as part of the Data Quality - Augmentation PDF reports. | 1 |