An EHR data warehouse uses a common data model to standardize lab results across multiple facilities, but analysts notice there are mismatched elements or units. Describe one way a data dictionary entry should be defined and explain how that definition supports consistency and reliable reporting across the warehouse. 

Your supervisor asks you to evaluate use needs as part of a database design project. Which of the following phases is this task associated with? 

The Health Information Management Coding area is implementing a new coding and abstracting system.   The HIM Director wants to collect some new data elements in the abstracting system.  The HIM Director should create a ____________________to ensure that consistent definitions are provided for each data field within the electronic problem list and so that the coders are accurately entering the data into the problem list.

Exploratory data analysis is used regularly in healthcare settings to analyze trends and patterns in various data sources.   A HIM professional would be involved in exploratory data analysis for all of the topics EXCEPT ___________________________.

Melissa, HIM Director- Varsity Healthcare Organization, has been asked by the Director of Patient Financial Services to perform an audit on pneumonia discharges for the fiscal year 2020.    In order to ensure that she is capturing the correct population and that she defines any exclusion or inclusion criteria for the audit, she will need to create a ______________________.

Which SQL word is used to filter rows returned by a query? 

The Health Information Management Committee at UC Health is developing a guide for utilizing the Problem List within the organization’s EHR.   Physicians and other healthcare providers are not utilizing the data fields correctly and there is a lot of confusion as to whether or not the problem is active during the patient’s stay.     The goal of this guide is to provide a detailed road map of the items from the database that are utilized to create the problem list.   The HIM committee should develop a ____________________to ensure that consistent definitions are provided for each data field within the electronic problem list and so that physicians are accurately entering the data into the problem list.

A primary key in a table

A quality analyst needs to find all inpatient encounters for patients aged 65 and older. Tables:  Patients(PatientID, DateOfBirth) and Encounters(EncounterID, PatientID, EncounterType) In two sentences explain which columns and clause you would use to retrieve the encounters for patients aged 65 and older and why. 

The only source of national-level pediatric data is the