Touchstone 2022 Database Reference
tRRRR_DQ_SCR_ResultSummary Table
AIRExposureSummary Database : tRRRR_DQ_SCR_ResultSummary Table
Description
Stores summary results for the Data Quality - Scoring reports.
Properties
Creation Date4/11/2022 6:15 PM
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 

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

For a complete list of records, see tAnalysisResult Table.

int4   
 Code that represents the chart type.int4  
 Name of the chart type.varchar50  
 Number of flagged location(s) in the corresponding data structure.int4  
 

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  
 

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.

int4  
 

Data quality uncertainty value, ranges from 0-100.

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

int4  
 Numeric code value used for the user interface display of risk index bands.int4  
 

Percent of the portfolio locations within the corresponding:

  • Geographic area
  • Overall risk band
  • Range of data quality scores
real4  
 

Total replacement value for all locations within the corresponding:

  • Geographic area
  • Overall risk band
  • Range of data quality scores
float9  
 

 

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

  • Geographic area
  • Overall risk band
  • Range of data quality scores
real4  
 Percent of locations with known construction information.real4  
 

Percent of locations with known occupancy information.

real4  
 

Percent of locations with known building height.

real4  
 

Percent of locations with known year built.

real4  
 

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

real4  
See Also

Related Objects

AIRExposureSummary Database