Touchstone 4.0 Database Documentation
tRRRR_DQ_DVA_ResultDetailTerms Table
Description
Stores detailed term result for the Data Quality - Validation reports.
Properties
Creation Date5/31/2016 9:46 AM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows0
Data Space Used0.00 KB
Index Space Used0.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key ResultDetailTermsSID

Unique system-generated sequential identifier for the detailed term results record.

For a complete list of records, see tAnalysisResult Table.

Integer4   
 ResultDetailSID

Unique system-generated sequential identifier for the detailed results record.

For a complete list of records, see tRRRR_DQ_DVA_ResultDetail Table.

Integer4  
 LocationSID

Unique system-generated sequential identifier for the location record.

For a complete list of records, see tLocation Table.

Integer4  
 LocTermSID

Unique system-generated sequential identifier for the location term record.

For a complete list of records, see tLocTerm Table.

Integer4  
 Deductible1
Coverage A deductible value of flagged location(s) in the geographic area. Referred to on the user interface as Deductible A.
Double9  
 Deductible2
Coverage B deductible value of flagged location(s) in the geographic area. Referred to on the user interface as Deductible B.
Double9  
 Deductible3
Coverage C deductible value of flagged location(s) in the geographic area. Referred to on the user interface as Deductible C.
Double9  
 Deductible4
Coverage D deductible value of flagged location(s) in the geographic area. Referred to on the user interface as Deductible D.
Double9  
 DeductibleTypeCode

Code that represents the type of deducible.

For a complete list of codes, see tDeductibleType Table

VarChar10  
 Limit1Coverage A limit value of flagged location(s) in the geographic area. Referred to on the user interface as Limit A.Double9  
 Limit2Coverage B limit value of flagged location(s) in the geographic area. Referred to on the user interface as Limit B.Double9  
 Limit3Coverage C limit value of flagged location(s) in the geographic area. Referred to on the user interface as Limit C.Double9  
 Limit4Coverage D limit value of flagged location(s) in the geographic area. Referred to on the user interface as Limit D.Double9  
 PerilSetCode

Numeric code for the single peril or set of perils.

For a complete list of codes, see tPerilSet Table.

Integer4  
 LimitTypeCode

Code that represents the limit type.

For a complete list of codes, see tLimitType Table.

VarChar10  
 PerilSet

Name corresponds to the PerilSetCode value.

VarChar255  
Objects that tRRRR_DQ_DVA_ResultDetailTerms depends on
 Database ObjectObject TypeDescriptionDep Level
tRRRR_DQ_DVA_ResultDetail tabletRRRR_DQ_DVA_ResultDetailTableStores 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
See Also

Related Objects

AIRExposureSummary Database

 

 


AIR Client Confidential

© 2016. AIR Worldwide is a registered trademark. Touchstone is a registered trademark of AIR Worldwide.

Please contact AIR Worldwide with questions or comments. For database questions. For documentation comments.