Unmapped Concepts
| dc.contributor.author | Wieand, Kaleigh |
| dc.contributor.author | Dickinson, Kimberley |
| dc.contributor.other | PEDSnet Data Coordinating Center |
| dc.date.accessioned | 2025-05-28T17:15:36Z |
| dc.date.created | 2024 |
| dc.description.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.<br> <br> Results of this check for the current data cycle can be explored on the <a href="https://pedsnet.org/metadata/entities/documentation/9a3dcf2c-b84e-4c9c-9e09-074804956d0f">PEDSnet Data Quality Dashboard</a>. Data quality results for previous data cycles have been archived in the <a href="https://pedsnet.org/metadata/collections/13cc0daa-ea79-47f4-94ed-17f2e03dc470">Unmapped Concepts Network Results collection</a>. |
| dc.identifier.uri | https://hdl.handle.net/20.500.14642/1041 |
| dc.identifier.uri | https://doi.org/10.24373/pdsp-485 |
| dc.publisher | PEDSnet |
| dc.relation.uri | https://github.com/PEDSnet/ndq/blob/main/R/unmapped_concepts.R |
| dc.rights | a CC-BY Attribution 4.0 license. |
| dc.rights.uri | https://creativecommons.org/licenses/by/4.0/ |
| dc.title | Unmapped Concepts |
| dspace.entity.type | DQCheck |
| local.description.raw | This check produces a raw data output containing 8 columns of data: <br> |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| {.dqcheck-table} <br> 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: <br> |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| {.dqcheck-table} <br> |
| local.description.viz | **NOTE: The visualizations are NOT part of the packaged code. This description applies to the visualizations available on the <a href="https://pedsnet.org/metadata/entities/documentation/9a3dcf2c-b84e-4c9c-9e09-074804956d0f">PEDSnet Data Quality Dashboard</a>.** <br><br> 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. |
| local.dqcheck.category | Completeness |
| local.dqcheck.probe | Data Representation Errors |
| local.dqcheck.requirement | uc_tbl |
| local.dqcheck.requirement | by_year |
| local.dqcheck.requirement | check_string |
| local.dqcheck.requirement | produce_mapped_list |
| local.dqcheck.requirement | unmapped_values |
| local.dqcheck.viz | Bar Graph |
| local.dqcheck.viz | Line Graph |
| relation.isCodeOfDQCheck | 3518c7c7-0f20-491d-bd3d-a2841b66ca2f |
| relation.isCodeOfDQCheck.latestForDiscovery | 3518c7c7-0f20-491d-bd3d-a2841b66ca2f |
| relation.isDQResultOfDQCheck | 5a042f1f-ee64-4833-adf1-7518ebcf68d2 |
| relation.isDQResultOfDQCheck.latestForDiscovery | 5a042f1f-ee64-4833-adf1-7518ebcf68d2 |
| relation.isDocumentationOfDQCheck | 9a3dcf2c-b84e-4c9c-9e09-074804956d0f |
| relation.isDocumentationOfDQCheck.latestForDiscovery | 9a3dcf2c-b84e-4c9c-9e09-074804956d0f |