Missing Field: Visit ID


Simple item page
dc.contributor.authorWieand, Kaleigh
dc.contributor.authorDickinson, Kimberley
dc.contributor.otherPEDSnet Data Coordinating Center
dc.date.accessioned2025-05-28T17:15:41Z
dc.date.created2024
dc.description.abstractA network data quality check which computes the proportion of records in each of the domains that do not have an associated `visit_occurrence_id`, either because the `visit_occurrence_id` is missing or because it does not have an associated record in the `visit_occurrence` table.<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/8cea22b5-37bd-45c5-b720-ad05adad6091">Facts with Associated Visit ID Network Results collection</a>.
dc.identifier.urihttps://hdl.handle.net/20.500.14642/1045
dc.identifier.urihttps://doi.org/10.24373/pdsp-483
dc.publisherPEDSnet
dc.relation.urihttps://github.com/PEDSnet/ndq/blob/main/R/mf_visit_id.R
dc.rightsa CC-BY Attribution 4.0 license.
dc.rights.urihttps://creativecommons.org/licenses/by/4.0/
dc.titleMissing Field: Visit ID
dspace.entity.typeDQCheck
local.description.rawThis check produces a raw data output containing 8 columns of data: <br> |Column |Data Type|Definition | |----------------|---------|--------------------------------------------------------------------------------------------| |`measure`|character|the clinical fact type being evaluated| |`total_ct`|numeric|the total row count associated with the measure| |`total_visits`|numeric|the total visit count associated with the measure| |`missing_visits_total`|numeric|the total number of missing visits| |`missing_visits_distinct`|numeric|the distinct number of missing visits| |`visit_na`|numeric|the number of rows with a `visit_occurrence_id` of NA| |`total_id`|numeric|the number of rows where the `visit_occurrence_id` does not also exist in the `visit_occurrence` table| |`site` |character|the name of the site being targeted | |`database_version` |character |the database version from which the counts originated | |`check_type` |character |a short string identifier for the module | |`check_name` |character |a short string identifier for the check | |`domain`|character|the table that is used as the source of 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> These results are visualized as a heatmap, with the proportion of missing visits acting as the fill, site along the X axis, and facetted by domain. Site-specific bar graphs are also made available to more closely examine the exact proportions.
local.dqcheck.categoryCompleteness
local.dqcheck.probeData Representation Errors
local.dqcheck.requirementomop_or_pcornet
local.dqcheck.requirementmf_tbl
local.dqcheck.requirementcheck_string
local.dqcheck.requirementvisit_tbl
local.dqcheck.vizHeatmap
local.dqcheck.vizBar Graph
relation.isCodeOfDQCheck3518c7c7-0f20-491d-bd3d-a2841b66ca2f
relation.isCodeOfDQCheck.latestForDiscovery3518c7c7-0f20-491d-bd3d-a2841b66ca2f
relation.isDQResultOfDQCheckda8542f3-c4f6-4c1a-9974-4c82ccf9c260
relation.isDQResultOfDQCheck.latestForDiscoveryda8542f3-c4f6-4c1a-9974-4c82ccf9c260
relation.isDocumentationOfDQCheck9a3dcf2c-b84e-4c9c-9e09-074804956d0f
relation.isDocumentationOfDQCheck.latestForDiscovery9a3dcf2c-b84e-4c9c-9e09-074804956d0f

Files

Original bundle

Now showing 1 - 1 of 1
Thumbnail Image
Name:
mf_visitid_output.png
Size:
147.24 KB
Format:
Portable Network Graphics
Download

Domains

Network-Level Data Quality Modules