Stores the aggregate results for the Data Quality - Validation reports.
Touchstone 2022 Database Reference
tRRRR_DQ_DVA_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. | 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 codes, 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 | | |||
| TRVByRule | Total replacement value of the flagged location(s) in violation of the specified rule. | float | 9 | | |||
| LocationsByRule | Number of flagged location(s) in violation of the specified rule. | int | 4 | | |||
| ByDQRuleSubTypeCode | Total number of rule sub type that are violated. | int | 4 | ||||
| TRVByRuleSubType | Total replacement value of the flagged location(s) in violation of specified rule sub type. | float | 9 | | |||
| LocationsByDQRuleSubTypeCode | Number of flagged location(s) in violation of the specified rule sub type. | int | 4 | | |||
| ByRuleTypeSID | Unique system-generated sequential identifier for the By Rule Type record. For a complete list of codes, see tDQRuleTemplate Table. | int | 4 | ||||
| TRVByRuleType | Total replacement value of the flagged location(s) in violation of the specified rule type. | float | 9 | | |||
| LocationsByRuleType | Number of flagged location(s) in violation of the specified rule type. | int | 4 | | |||
| ReplacementValueA | Combined Coverage A replacement value of flagged location(s). | float | 9 | | |||
| ReplacementValueB | Combined Coverage B replacement value of flagged location(s). | float | 9 | | |||
| ReplacementValueC | Combined Coverage C replacement value of flagged location(s). | float | 9 | | |||
| ReplacementValueD | Combined Coverage D replacement value of flagged location(s). | float | 9 | | |||
| Limit1 | Combined Coverage A limit value of flagged location(s). Referred to on the User Interface as Limit A. | float | 9 | | |||
| Limit2 | Combined Coverage B limit value of flagged location(s). Referred to on the User Interface as Limit B. | float | 9 | | |||
| Limit3 | Combined Coverage C limit value of flagged location(s). Referred to on the User Interface as Limit C. | float | 9 | | |||
| Limit4 | Combined Coverage D limit value of flagged location(s). Referred to on the User Interface as Limit D. | float | 9 | | |||
| Deductible1 | Combined Coverage A deductible value of flagged location(s). Referred to on the User Interface as Deductible A. | float | 9 | | |||
| Deductible2 | Combined Coverage B deductible value of flagged location(s). Referred to on the User Interface as Deductible B. | float | 9 | | |||
| Deductible3 | Combined Coverage C deductible value of flagged location(s). Referred to on the User Interface as Deductible C. | float | 9 | | |||
| Deductible4 | Combined Coverage D deductible value of flagged location(s). Referred to on the User Interface as Deductible D. | float | 9 | | |||
| RiskCount | Total number of risks. | int | 4 | | |||
| Premium | Combined premiums of flagged location(s). | float | 9 | | |||
| GeographySID | Unique system-generated sequential identifier for the geographic record. For a complete list of records, see tGeography Table. | int | 4 | |