Touchstone 4.0 Database Documentation
tRRRR_DQ_AUG_ResultDetailAggregate Table
Description
Stores detailed summary results for the Data Quality - Augmentation 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.

For a complete list of records, see tDQRuleTier Table.

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  
 LocationsRVATotal replacement value of all augmented location(s) in the corresponding geographic region.Integer4  
 LocationsPANumber of locations with primary risk characteristics that were updated.Integer4  
 LocationsSANumber of locations with secondary risk characteristics that were updated.Integer4  
 TRVByRuleTotal replacement value of all location(s) updated as a result of the corresponding rule type, rule category, or rule.Double9  
 LocationsByRuleNumber of locations updated as a result of the corresponding rule.Integer4  
 LocationsRVAByRuleTotal replacement value of all augmented location(s) in the correspond corresponding rule.Integer4  
 LocationsPAByRuleNumber of locations with primary risk characteristics that were updated as a result of the corresponding rule.Integer4  
 LocationsSAByRuleNumber of locations with secondary risk characteristics that were updated as a result of the corresponding rule.Integer4  
 ByDQRuleSubTypeCode

Code for the corresponding data quality rule sub type.

For a complete list of codes, see tDQRuleTemplate Table.

Integer4   
 TRVByRuleSubTypeTotal replacement value of all location(s) updated as a result of the corresponding rule sub type.Double9  
 LocationsByDQRuleSubTypeCodeNumber of location(s) updated as a result of the corresponding rule sub type.Integer4  
 LocationsRVAByRuleSubTypeTotal replacement value of all location(s) updated as a result of the corresponding rule sub type.Integer4  
 LocationsPAByRuleSubTypeNumber of locations with primary risk characteristics that were updated as a result of the corresponding rule sub type.Integer4  
 LocationsSAByRuleSubTypeNumber of locations with secondary risk characteristics that were updated as a result of the corresponding rule sub type.Integer4  
 ByRuleTypeSID

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

Integer4   
 TRVByRuleTypeTotal replacement value of all location(s) updated as a result of the corresponding rule type.Double9  
 LocationsByRuleTypeNumber of locations updated as a result of the corresponding rule type.Integer4  
 LocationsRVAByRuleTypeTotal replacement value of all augmented location(s) in the correspond corresponding rule type.Integer4  
 LocationsPAByRuleTypeNumber of locations with primary risk characteristics that were updated as a result of the corresponding rule type.Integer4  
 LocationsSAByRuleTypeNumber of locations with secondary risk characteristics that were updated as a result of the corresponding rule type.Integer4  
 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.