--Put your SQL code in this block
SELECT
COUNT(*) AS documentation_count,
icustays.first_careunit
FROM caregivers
INNER JOIN chartevents
ON caregivers.cgid = chartevents.cgid
INNER JOIN icustays
ON chartevents.icustay_id = icustays.icustay_id
WHERE caregivers.label LIKE '%Nurse%'
GROUP BY icustays.first_careunit
ORDER BY documentation_count DESCAnalysis Report Three - Information Systems and Healthcare Provider Interactions
Executive Summary
The implementation of Electronic Medical Record (EMR) and Electronic Health Record (EHR) systems has transformed the way healthcare organizations deliver care. While EHR systems provide important benefits such as improved access to patient information, better communication, and stronger care coordination, they also create challenges for non-technical healthcare workers, especially caregivers such as nurses and clinical support staff. Successful implementation requires hospitals to focus on the people using the technology, not only the technology itself. This report examines how EHR implementation affects caregivers and identifies strategies hospitals can use to support adoption. The analysis uses findings from the assigned readings, external healthcare research, and MIMIC-III caregiver data examples to demonstrate how electronic data visibility can improve caregiver performance. The findings show that caregivers play an essential role in successful adoption because they provide feedback, use the system during daily care, and help ensure accurate documentation. Managers support this transition by providing training, communication, and organizational support.
Introduction
Healthcare organizations have increasingly adopted EHR systems to improve healthcare quality, patient safety, and information sharing. Unlike paper records, EHR systems allow healthcare workers to access patient information electronically, including medical histories, medications, laboratory results, and treatment plans. However, implementing an EHR system changes the daily responsibilities of caregivers and requires employees to adapt to new workflows. The reading “Seven Years after Meaningful Use” explains that healthcare workers experienced both benefits and challenges after EHR implementation. Employees valued improved access to patient information but also reported concerns related to documentation workload, workflow changes, and system usability. The “Journey through Grief” article explains that EHR adoption should be viewed as an organizational change process. Healthcare workers may experience frustration, resistance, and adjustment before reaching acceptance of the new technology. Therefore, successful EHR adoption requires hospitals to support caregivers throughout the transition.
The Healthcare Context
Caregivers are one of the most important groups affected by EHR implementation because they interact with patient information throughout the entire care process. Nurses, medical assistants, and other caregivers use EHR systems to document patient conditions, communicate with other healthcare workers, and monitor treatment progress. One major advantage of EHR systems is increased visibility of patient information. The Office of the National Coordinator for Health Information Technology (ONC) explains that health information technology improves care coordination by allowing healthcare professionals to securely exchange patient information and make more informed decisions (Gabriel et al. 2024). However, increased visibility also creates new responsibilities. Caregivers may spend more time documenting information instead of directly interacting with patients. The assigned reading found that healthcare workers often experienced increased documentation demands and workflow disruption after EHR implementation. (Adler-Milstein and Jha 2017) also found that while EHR adoption has increased across hospitals, organizations must continue improving usability and workflow integration. Hospitals can reduce these challenges by involving caregivers in the implementation process. The “Journey through Grief” study identified communication, employee involvement, leadership support, and proper training as important strategies for successful EHR adoption. Training is especially important because caregivers use EHR systems differently depending on their role. Healthcare informatics research emphasizes that healthcare workers require ongoing education and support to effectively use changing technologies (McGonigle and Mastrian 2024). Training should continue after implementation to address new problems and improve confidence.
Data Visualizations
Visualization One
This analysis uses the MIMIC-III caregivers table to examine how EHR data visibility can help healthcare organizations understand nursing workload and documentation patterns. The SQL query connects the caregivers table with the chartevents table to identify electronic documentation completed by nurses and then links this information with the icustays table to determine the ICU unit where the documentation occurred. The query filters the data to focus only on caregiver roles containing “Nurse” and calculates the total number of documentation events for each nursing role across ICU care units. The purpose of this analysis is to demonstrate how EHR systems provide valuable information about caregiver activity. The documentation recorded in an EHR creates visibility into how frequently nurses contribute to patient records and where nursing workload is concentrated. This type of data can help healthcare organizations identify high-demand units, evaluate staffing needs, and improve workflow planning.
ggplot(data = myquery1,
aes(x = first_careunit, y = documentation_count)) +
geom_col() +
labs(
title = "Nurse Documentation Activity by ICU Unit",
subtitle = "EHR visibility of nursing workload in MIMIC-III",
x = "ICU Care Unit",
y = "Number of Documentation Events",
caption = "Source: MIMIC-III Clinical Database v1.4"
)The geom_col() bar chart displays the number of nurse documentation events by ICU care unit. By comparing documentation activity across different units, healthcare managers can better understand differences in nursing workload and use this information to provide additional support where needed. This visualization demonstrates that EHR systems are not only tools for storing patient information but also provide operational insights that can help caregivers perform their jobs more effectively.
Visualization Two
--Put your SQL code in this block
SELECT
chartevents.subject_id,
chartevents.hadm_id,
COUNT(DISTINCT caregivers.cgid) AS number_of_caregivers
FROM caregivers
INNER JOIN chartevents
ON caregivers.cgid = chartevents.cgid
WHERE caregivers.cgid IS NOT NULL
GROUP BY
chartevents.subject_id,
chartevents.hadm_id
ORDER BY number_of_caregivers DESC
LIMIT 10;This analysis examines how EHR visibility improves communication and coordination among caregivers by measuring the number of unique caregivers involved in each patient admission. The SQL query uses the chartevents table from the MIMIC-III database and analyzes the caregiver IDs (cgid) associated with each hospital admission. By counting the number of distinct caregivers contributing documentation to each patient stay, the analysis identifies how many healthcare workers participate in a patient’s care. The purpose of this visualization is to demonstrate the role of EHR systems in supporting teamwork and continuity of care. In a hospital setting, patients often interact with multiple caregivers, including nurses and other healthcare professionals. The electronic health record creates a shared information system where different caregivers can access documentation, review patient information, and coordinate care more effectively. (Quality of Health Care in America 2001) emphasized that healthcare technology can improve quality and safety when systems support communication, teamwork, and better information sharing. Improved information sharing is especially important during shift changes or when patients require care from multiple departments. The EHR becomes a shared communication tool that supports continuity of care.
ggplot(data = myquery2,
aes(x = reorder(hadm_id, number_of_caregivers),
y = number_of_caregivers)) +
geom_col() +
coord_flip() +
theme_minimal() +
labs(
title = "Number of Caregivers Involved per Patient Admission",
subtitle = "Caregiver participation recorded through EHR documentation",
x = "Hospital Admission ID",
y = "Number of Unique Caregivers",
caption = "Source: MIMIC-III Clinical Database v1.4"
)The geom_col() bar chart displays the number of unique caregivers involved in each hospital admission. A higher number of caregivers indicates greater participation from the healthcare team and highlights the importance of having a centralized electronic record. This visualization demonstrates how EHR data can improve care coordination by making caregiver involvement visible and allowing healthcare organizations to better understand communication patterns across patient care teams.
Recommendations for Industry
Based on the research and data analysis, hospitals should focus on supporting caregivers throughout the EHR implementation process by combining technology improvements with effective change management strategies. First, organizations should provide continuous and role-specific training so caregivers understand how to use EHR systems effectively without disrupting patient care. Training should continue after implementation because healthcare technology and workflows continue to change over time (McGonigle & Mastrian, 2021). Hospitals should also involve caregivers in EHR planning and decision-making because frontline workers understand patient-care processes and can identify workflow problems that may not be visible to technology teams. Creating caregiver advisory groups and using trained “super users” can improve confidence and reduce resistance during adoption. Managers should communicate the purpose of the EHR system, explain how it supports better patient outcomes, and acknowledge that adjusting to new technology can be challenging. The “Journey through Grief” study found that successful EHR adoption requires managing expectations, communicating goals, providing training, and allowing employees time to adapt. Healthcare organizations should also focus on improving EHR usability and reducing unnecessary documentation tasks because excessive administrative burden can reduce caregiver satisfaction and take time away from direct patient care (Association 2019). Finally, hospitals should continue using EHR data analytics to understand caregiver workload, improve staffing decisions, and strengthen communication between healthcare teams. By supporting caregivers and using data to guide improvements, organizations can create a smoother transition and maximize the benefits of electronic health records.