Unmapped Concepts
Created
Last Modified
Files
Domain
Category
Parameters
Publisher
Abstract
A network data quality check which computes the proportion of unmapped concepts for a given domain. For example, this check type may be applied to the drug_exposure table to determine the proportion of unmapped prescriptions. The output of this check type can amount to three distinct tables: First, the raw proportion of unmapped concepts; Second, unmapped concepts over time; Third, the unmapped source values are also shown to assist ETL analysts in viewing what the top unmapped values are for each domain.
Results of this check for the current data cycle can be explored on the PEDSnet Data Quality Dashboard. Data quality results for previous data cycles have been archived in the Unmapped Concepts Network Results collection.
Data Requirements
Probe
Clinical Assessment
Access Package
Visualization Output
NOTE: The visualizations are NOT part of the packaged code. This description applies to the visualizations available on the PEDSnet Data Quality Dashboard.
For the cross-sectional (not over time) output, the results are visualized as a bar graph showing the proportion of rows in the domain that are unmapped. For the by year output, a line graph with the proportion of unmapped concepts per year is used.
Raw Output
This check produces a raw data output containing 8 columns of data:
| Column | Data Type | Definition |
|---|---|---|
site |
character | the name of the site being targeted |
measure |
character | the name of the clinical fact domain being evaluated |
total_rows |
numeric | the total number of rows associated with the measure |
unmapped_rows |
numeric | the total number of unmapped rows associated with the measure |
database_version |
character | the database version from which the counts originated |
check_name |
character | a short string identifier for the check |
check_type |
character | a short string identifier for the module |
unmapped_prop |
numeric | the proportion of unmapped rows associated with the measure |
This check can also be executed by year to measure the rate of unmapped concepts across time. This version of the check produces output with 9 columns:
| Column | Data Type | Definition |
|---|---|---|
site |
character | the name of the site being targeted |
year_date |
date | the year for which unmapped concepts are being evaluated |
total_row_ct |
numeric | the total number of rows associated with the measure for that year |
total_unmapped_row_ct |
numeric | the total number of unmapped rows associated with the measure for that year |
unmapped_description |
character | the name of the clinical fact domain being evaluated |
database_version |
character | the database version from which the counts originated |
check_name |
character | a short string identifier for the check |
check_type |
character | a short string identifier for the module |
unmapped_prop |
numeric | the proportion of unmapped rows associated with the measure |
Affiliation(s)
Funder(s)
Provenance
Description
Development Code
Clinical Subjects Headings
Related Publications
Creative Commons license
