Vocabulary Conformance
Created
Last Modified
Files
Domain
Category
Parameters
Publisher
Abstract
A network data quality check which determines whether values for a particular field violate the expected vocabulary. An example of a vocabulary violation is if an RxNorm code was found in the Immunizations table, which can only take on values in the CVX vocabulary.
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 Vocabulary Conformance Network Results collection.
Data Requirements
Probe
Clinical Assessment
Access Package
Visualization Output
NOTE: Visualizations are NOT part of the packaged code. This description applies to what is used on the PEDSnet Data Quality Dashboard.
There are two bar graphs included in the visualization for this check. The first is a stacked bar plot with all of the vocabularies present in the domain for each site, while the second only shows the violating vocabularies. Some bars do not add up to 100% because NULL values are excluded from the computation of vocabulary makeup.
Raw Output
This check produces a raw data output containing 14 columns of data:
| Column | Data Type | Definition |
|---|---|---|
vocabulary_id |
character | the vocabulary identifier associated with the counts |
table_application |
character | the name of the table for which the vocabulary distribution was evaluated |
measurement_column |
character | the name of the column in the table_application for which the vocabulary distribution was evaluated |
concepts |
numeric | violating concepts - defaults to 0 |
total_viol_ct |
character | the number of rows with concepts belonging to that vocabulary_id |
total_viol_pt_ct |
character | the number of patients with concepts belonging to that vocabulary_id |
total_viol_concept_ct |
character | the number of distinct concepts belonging to that vocabulary_id |
site |
character | the name of the site being targeted |
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 |
accepted_value |
boolean | indicator of whether or not the vocabulary is acceptable for that table + field |
concept_name |
character | the name of the vocabulary |
total_denom_ct |
character | the total number of rows in the table |
total_pt_ct |
character | the total number of patients in the table |
total_concept_ct |
character | the total number of distinct concepts in the table |

