Touchstone 4.0 Database Documentation
tRRRR_DQ_DVA_ResultDetailAggregate Table
Description
Stores the aggregate results for the Data Quality - Validation reports.
Properties
Creation Date5/31/2016 9:45 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 ResultDetailAggregateSID

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

For a complete list of records, see tAnalysisResult Table.

Integer4   
 CountryNameName of the country.VarChar255  
 AreaNameName of the area.VarChar255  
 SubAreaNameName of the subarea.VarChar255  
 PostalNameName of the postal code.VarChar255  
 CountryCode

ISO 2-character code for the country in which the location resides. 

For a complete list of codes, see tCountry Table.

VarChar15  
 AreaCode

Area code for the location.

For a complete list of codes, see tGeography Table.

VarChar15  
 SubareaCode

Subarea code for the location.

For a complete list of codes, see tGeography Table.

VarChar15  
 PostalCode

Postal code for the location.

For a complete list of codes, see tGeography Table.

VarChar15  
 PerilSetCode

Numeric code for the single peril or set of perils.

For a complete list of codes, see tPerilSet Table.

Integer4  
 ExposureViewNameName of the exposure view.VarChar255  
 ExposureSetNameName of the exposure set.VarChar255  
 UserLineOfBusinessUser's Line of Business.VarChar60  
 ExposureViewSID

Unique system-generated sequential identifier for the exposure view record.

For a complete list of records, see tExposureView Table.

Integer4  
 ExposureSetSID

Unique system-generated sequential identifier for the exposure set record.

For a complete list of records, see tExposureSet Table.

Integer4  
 UserLOBSID

Unique system-generated sequential identifier for the user's Line of Business record.

Integer4  
 RuleSID

Unique system-generated sequential identifier for the data quality rule record.

For a complete list of records, see tDQAnalysisRule Table.

Integer4   
 RuleNameName of the rule.VarChar8000  
 DQRuleSubTypeCode

Code that represents the type of Data Quality sub rule.

For a complete list of codes, see tDQRuleSubType Table.

Integer4  
 DQRuleSubTypeName of the Data Quality rule sub type.VarChar255  
 DQRuleSetTypeCode

Code that represents the type of Data Quality rule set.

For a complete list of codes, see tDQRuleSetType Table.

Integer4   
 DQRuleSetTypeName of the Data Quality rule set type.VarChar255  
 RuleTierSID

Unique system-generated sequential identifier for the rule tier record.

Integer4  
 RuleTierNameName of the rule tier. VarChar200  
 ByPostalSID

Unique system-generated sequential identifier for the By Postal record.

For a complete list of records, see tGeography Table.

Integer4   
 TotalReplacementValueSum of replacement value for all coverages.Double9  
 LocationsNumber of flagged location(s) in the corresponding data structure.Integer4  
 TRVByRuleTotal replacement value of the flagged location(s) in violation of the specified rule.Double9  
 LocationsByRuleNumber of flagged location(s) in violation of the specified rule.Integer4  
 ByDQRuleSubTypeCodeTotal number of rule sub type that are violated. Integer4   
 TRVByRuleSubTypeTotal replacement value of the flagged location(s) in violation of specified rule sub type.Double9  
 LocationsByDQRuleSubTypeCodeNumber of flagged location(s) in violation of the specified rule sub type.Integer4  
 ByRuleTypeSID

Unique system-generated sequential identifier for the By Rule Type record.

For a complete list of codes, see tDQRuleTemplate Table.

Integer4   
 TRVByRuleTypeTotal replacement value of the flagged location(s) in violation of the specified rule type.Double9  
 LocationsByRuleTypeNumber of flagged location(s) in violation of the specified rule type.Integer4  
 ReplacementValueACombined Coverage A replacement value of flagged location(s).Double9  
 ReplacementValueBCombined Coverage B replacement value of flagged location(s).Double9  
 ReplacementValueCCombined Coverage C replacement value of flagged location(s).Double9  
 ReplacementValueDCombined Coverage D replacement value of flagged location(s).Double9  
 Limit1Combined Coverage A limit value of flagged location(s). Referred to on the User Interface as Limit A.Double9  
 Limit2Combined Coverage B limit value of flagged location(s). Referred to on the User Interface as Limit B.Double9  
 Limit3Combined Coverage C limit value of flagged location(s). Referred to on the User Interface as Limit C.Double9  
 Limit4Combined Coverage D limit value of flagged location(s). Referred to on the User Interface as Limit D.Double9  
 Deductible1Combined Coverage A deductible value of flagged location(s). Referred to on the User Interface as Deductible A.Double9  
 Deductible2Combined Coverage B deductible value of flagged location(s). Referred to on the User Interface as Deductible B.Double9  
 Deductible3Combined Coverage C deductible value of flagged location(s). Referred to on the User Interface as Deductible C.Double9  
 Deductible4Combined Coverage D deductible value of flagged location(s). Referred to on the User Interface as Deductible D.Double9  
 RiskCountTotal number of risks.Integer4  
 PremiumCombined premiums of flagged location(s).Double9  
 GeographySID

Unique system-generated sequential identifier for the geographic record.

For a complete list of records, see tGeography Table.

Integer4  
See Also

Related Objects

AIRResult
Locating Results for a Specific Analysis

 

 


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.