Stores detailed term result for the Data Quality - Validation reports.
Touchstone 2022 Database Reference
tRRRR_DQ_DVA_ResultDetailTerms 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 | |
|---|---|---|---|---|---|---|---|
 | ResultDetailTermsSID | Unique system-generated sequential identifier for the detailed term results record. For a complete list of records, see tAnalysisResult Table. | int | 4 | |||
| ResultDetailSID | Unique system-generated sequential identifier for the detailed results record. For a complete list of records, see tRRRR_DQ_DVA_ResultDetail Table. | int | 4 |  | |||
| LocationSID | Unique system-generated sequential identifier for the location record. For a complete list of records, see tLocation Table. | int | 4 | | |||
| LocTermSID | Unique system-generated sequential identifier for the location term record. For a complete list of records, see tLocTerm Table. | int | 4 | | |||
| Deductible1 |
Coverage A deductible value of flagged location(s) in the geographic area. Referred to on the user interface as Deductible A.
| float | 9 | | |||
| Deductible2 |
Coverage B deductible value of flagged location(s) in the geographic area. Referred to on the user interface as Deductible B.
| float | 9 | | |||
| Deductible3 |
Coverage C deductible value of flagged location(s) in the geographic area. Referred to on the user interface as Deductible C.
| float | 9 | | |||
| Deductible4 |
Coverage D deductible value of flagged location(s) in the geographic area. Referred to on the user interface as Deductible D.
| float | 9 | | |||
| DeductibleTypeCode | Code that represents the type of deducible. For a complete list of codes, see tDeductibleType Table. | varchar | 10 | | |||
| Limit1 | Coverage A limit value of flagged location(s) in the geographic area. Referred to on the user interface as Limit A. | float | 9 | | |||
| Limit2 | Coverage B limit value of flagged location(s) in the geographic area. Referred to on the user interface as Limit B. | float | 9 | | |||
| Limit3 | Coverage C limit value of flagged location(s) in the geographic area. Referred to on the user interface as Limit C. | float | 9 | | |||
| Limit4 | Coverage D limit value of flagged location(s) in the geographic area. Referred to on the user interface as Limit D. | float | 9 | | |||
| PerilSetCode | Numeric code for the single peril or set of perils. For a complete list of codes, see tPerilSet Table. | int | 4 | | |||
| LimitTypeCode | Code that represents the limit type. For a complete list of codes, see tLimitType Table. | varchar | 10 | | |||
| PerilSet | Name corresponds to the PerilSetCode value. | varchar | 255 | |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
 | tRRRR_DQ_DVA_ResultDetail | Table | Stores result details for the Data Quality - Validation reports. Each table contains detail data for one report and every location in the report is represented by a record. See tRRRR_DQ_DVA_Violations Table to review the multiple rule violations for each location record. | 1 |