Stores pre- and post-summary coverage data. The data stored is used as part of the Data Quality - Augmentation PDF reports.
Touchstone 2022 Database Reference
tDQAUGPrePostSummaryCoverage 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 | Code that represents the type of output generated during the analysis. For a complete list of codes, see tOutputType Table. | varchar | 10 | |||
| CategoryValue | Exposure attribute being augmented during the Data Quality analysis. | varchar | 50 |  | |||
| LocationsImproved | Number of locations whose data was augmented during the Data Quality analysis. | int | 4 | | |||
| PercentTotalLocationsImproved | Percent of the total locations updated during the Data Quality - Augmentation analysis. | real | 4 | | |||
| PercentTotalReplacementValueImproved | Percent of the combined total replacement value updated during the Data Quality - Augmentation analysis. | real | 4 | | |||
| PreAugmentationValue | Exposure attribute value prior to the Data Quality - Augmentation analysis. | float | 9 | | |||
| PostAugmentationValue | Exposure attribute value after the Data Quality - Augmentation analysis. | float | 9 | | |||
| PercentBuildingReplacementValueImproved | Percent of the combined Coverage A replacement value updated during the Data Quality - Augmentation analysis. | real | 4 | |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
 | tDQAnalysisResultStatistics | Table | Stores the statistical information for the Data Quality analysis. | 1 |