Touchstone 4.0 Database Documentation
tRRRR_DQ_SCR_ResultSummary Table
Description
Stores summary results for the Data Quality - Scoring 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 ResultSummarySID

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

For a complete list of records, see tAnalysisResult Table.

Integer4   
 ChartTypeCode that represents the chart type.Integer4  
 ChartTypeNameName of the chart type.VarChar50  
 LocationsNumber of flagged location(s) in the corresponding data structure.Integer4  
 RiskCategory

Overall risk distribution band (or category). The categories depend on the location-based losses in the exposure set.

  • 0 = Number of locations with an overall risk of zero
  • 1-n = Number of location with an overall risk greater than zero and less than or equal to half (½) of the average.
VarChar50  
 DataQualityScore

Data quality score value, ranges from 0-100, with 100 representing the highest data quality.

The Data Quality Score indicates the completeness of the portfolio data’s construction, occupancy, year built, stories and address information.

Integer4  
 DataQualityUncertainty

Data quality uncertainty value, ranges from 0-100.

This value is applied to the Overall Risk Score to reflect deficiencies in the exposure data.

Integer4  
 RIBandNumeric code value used for the user interface display of risk index bands.Integer4  
 PercentPortfolioLocations

Percent of the portfolio locations within the corresponding:

  • Geographic area
  • Overall risk band
  • Range of data quality scores
Single4  
 TotalReplacementValue

Total replacement value for all locations within the corresponding:

  • Geographic area
  • Overall risk band
  • Range of data quality scores
Double9  
 PercentTotalReplacementValue

 

Percent of the portfolio replacement value made up by locations within the corresponding:

  • Geographic area
  • Overall risk band
  • Range of data quality scores
Single4  
 PercentKnownConstructionPercent of locations with known construction information.Single4  
 PercentKnownOccupancy

Percent of locations with known occupancy information.

Single4  
 PercentKnownStories

Percent of locations with known building height.

Single4  
 PercentKnownYearBuilt

Percent of locations with known year built.

Single4  
 PercentBetterThanZip

Percent of locations with quality geocode match level that is better than postal code.

Single4  
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.