Stores detailed summary results for the Data Quality - Augmentation reports.
Touchstone 2022 Database Reference
tRRRR_DQ_AUG_ResultDetailAggregate 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 | |
|---|---|---|---|---|---|---|---|
 | ResultDetailAggregateSid | Unique system-generated sequential identifier for the detailed aggregate results record. For a complete list of records, see tAnalysisResult Table. | int | 4 | |||
| CountryName | Name of the country. | varchar | 255 |  | |||
| AreaName | Name of the area. | varchar | 255 | | |||
| SubAreaName | Name of the subarea. | varchar | 255 | | |||
| PostalName | Name of the postal code. | varchar | 255 | | |||
| CountryCode | ISO 2-character code for the country in which the location resides. For a complete list of codes, see tCountry Table. | varchar | 15 | | |||
| AreaCode | Area code for the location. For a complete list of codes, see tGeography Table. | varchar | 15 | | |||
| SubareaCode | Subarea code for the location. For a complete list of codes, see tGeography Table. | varchar | 15 | | |||
| PostalCode | Postal code for the location. For a complete list of codes, see tGeography Table. | varchar | 15 | | |||
| PerilSetCode | Numeric code for the single peril or set of perils. For a complete list of codes, see tPerilSet Table. | int | 4 | | |||
| ExposureViewName | Name of the exposure view. | varchar | 255 | | |||
| ExposureSetName | Name of the exposure set. | varchar | 255 | | |||
| UserLineOfBusiness | User's Line of Business. | varchar | 60 | | |||
| ExposureViewSID | Unique system-generated sequential identifier for the exposure view record. For a complete list of records, see tExposureView Table. | int | 4 | | |||
| ExposureSetSID | Unique system-generated sequential identifier for the exposure set record. For a complete list of records, see tExposureSet Table. | int | 4 | | |||
| UserLOBSID | Unique system-generated sequential identifier for the user's Line of Business record. | int | 4 | | |||
| RuleSID | Unique system-generated sequential identifier for the data quality rule record. For a complete list of records, see tDQAnalysisRule Table. | int | 4 | ||||
| RuleName | Name of the rule. | varchar | 8000 | | |||
| DQRuleSubTypeCode | Code that represents the type of Data Quality sub rule. For a complete list of codes, see tDQRuleSubType Table. | int | 4 | | |||
| DQRuleSubType | Name of the Data Quality rule sub type. | varchar | 255 | | |||
| DQRuleSetTypeCode | Code that represents the type of Data Quality rule set. For a complete list of codes, see tDQRuleSetType Table. | int | 4 | ||||
| DQRuleSetType | Name of the Data Quality rule set type. | varchar | 255 | | |||
| RuleTierSID | Unique system-generated sequential identifier for the rule tier record. For a complete list of records, see tDQRuleTier Table. | int | 4 | | |||
| RuleTierName | Name of the rule tier. | varchar | 200 | | |||
| ByPostalSID | Unique system-generated sequential identifier for the By Postal record. For a complete list of records, see tGeography Table. | int | 4 | ||||
| TotalReplacementValue | Sum of replacement value for all coverages. | float | 9 | | |||
| Locations | Number of flagged location(s) in the corresponding data structure. | int | 4 | | |||
| LocationsRVA | Total replacement value of all augmented location(s) in the corresponding geographic region. | int | 4 | | |||
| LocationsPA | Number of locations with primary risk characteristics that were updated. | int | 4 | | |||
| LocationsSA | Number of locations with secondary risk characteristics that were updated. | int | 4 | | |||
| TRVByRule | Total replacement value of all location(s) updated as a result of the corresponding rule type, rule category, or rule. | float | 9 | | |||
| LocationsByRule | Number of locations updated as a result of the corresponding rule. | int | 4 | | |||
| LocationsRVAByRule | Total replacement value of all augmented location(s) in the correspond corresponding rule. | int | 4 | | |||
| LocationsPAByRule | Number of locations with primary risk characteristics that were updated as a result of the corresponding rule. | int | 4 | | |||
| LocationsSAByRule | Number of locations with secondary risk characteristics that were updated as a result of the corresponding rule. | int | 4 | | |||
| ByDQRuleSubTypeCode | Code for the corresponding rule sub type. | int | 4 | ||||
| TRVByRuleSubType | Total replacement value of all location(s) updated as a result of the corresponding rule sub type. | float | 9 | | |||
| LocationsByDQRuleSubTypeCode | Number of location(s) updated as a result of the corresponding rule sub type. | int | 4 | | |||
| LocationsRVAByRuleSubType | Total replacement value of all location(s) updated as a result of the corresponding rule sub type. | int | 4 | | |||
| LocationsPAByRuleSubType | Number of locations with primary risk characteristics that were updated as a result of the corresponding rule sub type. | int | 4 | | |||
| LocationsSAByRuleSubType | Number of locations with secondary risk characteristics that were updated as a result of the corresponding rule sub type. | int | 4 | | |||
| ByRuleTypeSID | Unique system-generated sequential identifier for the rule type record. | int | 4 | ||||
| TRVByRuleType | Total replacement value of all location(s) updated as a result of the corresponding rule type. | float | 9 | | |||
| LocationsByRuleType | Number of locations updated as a result of the corresponding rule type. | int | 4 | | |||
| LocationsRVAByRuleType | Total replacement value of all augmented location(s) in the correspond corresponding rule type. | int | 4 | | |||
| LocationsPAByRuleType | Number of locations with primary risk characteristics that were updated as a result of the corresponding rule type. | int | 4 | | |||
| LocationsSAByRuleType | Number of locations with secondary risk characteristics that were updated as a result of the corresponding rule type. | int | 4 | | |||
| GeographySID | Unique system-generated sequential identifier for the geographic record. For a complete list of records, see tGeography Table. | int | 4 | |