Missing Field: Visit ID
Created
Last Modified
Files
Domain
Category
Parameters
Publisher
Abstract
A 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.
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 Facts with Associated Visit ID 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.
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.
Raw Output
This check produces a raw data output containing 8 columns of data:
| 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 |
Affiliation(s)
Funder(s)
Provenance
Description
Development Code
Clinical Subjects Headings
Related Publications
Creative Commons license
