SELECT
ce.charttime,
cg.label AS caregiver_role,
d.label AS clinical_event
FROM chartevents ce
INNER JOIN caregivers cg
ON ce.cgid = cg.cgid
LEFT JOIN d_items d
ON ce.itemid = d.itemid
WHERE ce.icustay_id = 264446
AND d.label IN
(
'Heart Rate',
'Respiratory Rate',
'O2 saturation pulseoxymetry',
'Systolic Blood Pressure'
)
ORDER BY ce.charttime;Analysis Report Four - Health Privacy and Data Profiling
Executive Summary
Electronic Health Records (EHRs) have changed the way healthcare organizations manage patient information by replacing paper charts with digital records. While these systems have improved communication, documentation, and access to patient information, they have also changed the daily responsibilities of non-technical healthcare workers, especially caregivers such as nurses and nursing assistants. Learning a new documentation system can be stressful, particularly when caregivers are expected to continue providing high-quality patient care while adapting to new technology. This report examines how hospitals can make the transition to an EHR system easier for caregivers by providing meaningful training, involving frontline staff in the implementation process, and offering continued support after the system goes live. It also uses two SQL queries from the MIMIC-III caregivers table to demonstrate how EHR data can help caregivers work more efficiently and provide managers with valuable information about documentation patterns and workload. Together, the research and data analysis show that successful EHR implementation depends just as much on supporting people as it does on installing new technology (Brach and Borsky 2020) ## Introduction Electronic Medical Records (EMRs) and Electronic Health Records (EHRs) have become a normal part of healthcare today. Instead of relying on paper charts, hospitals now use electronic systems to record patient information, document treatments, communicate with other healthcare professionals, and track patient outcomes. These systems allow healthcare providers to quickly access important information, helping improve coordination between departments and supporting safer, more informed patient care. The widespread use of EHRs was largely driven by the Health Information Technology for Economic and Clinical Health (HITECH) Act, which encouraged hospitals to adopt electronic records through financial incentives. As a result, hospitals eligible for the program experienced a significant increase in EHR adoption compared to those that were not eligible, demonstrating how national policy accelerated the transition to digital healthcare.
Although EHRs offer many benefits, implementing them is not always easy. For many caregivers, learning a new documentation system while continuing to care for patients can feel overwhelming. New workflows, increased documentation requirements, and unfamiliar technology often create frustration during the transition. Because of this, hospitals should think of EHR implementation as more than just an information technology project. It is also a change in how caregivers perform their daily work (Brach and Borsky 2020). This report discusses how hospitals can help caregivers successfully adapt to EHR systems, the responsibilities caregivers and managers share during implementation, and how EHR data can be used to improve both patient care and organizational decision-making.
The Healthcare Context
Caregivers are among the healthcare professionals who use EHR systems the most. Throughout every shift, nurses and other caregivers document patient assessments, medications, vital signs, treatments, and changes in a patient’s condition. Because they spend so much time working within the EHR, their willingness to accept and effectively use the system has a major impact on whether implementation is successful (Zadvinskis, Smith, and Yen 2018). The HITECH Act played a major role in increasing EHR adoption across the United States. According to the readings, annual adoption rates among eligible hospitals increased from about 3% before the incentive program to more than 14% after it was introduced. Even with this rapid growth, many hospitals continue to face challenges related to system usability and interoperability, making it difficult for caregivers to use the technology as efficiently as intended (Adler-Milstein and Jha 2017). Hospitals can make the transition easier by involving caregivers from the very beginning of the implementation process. Instead of making decisions only at the leadership level, organizations should ask nurses, nursing assistants, and other frontline staff for input on documentation workflows and system design. Since these employees work directly with patients every day, they understand where technology fits naturally into patient care and where it creates unnecessary obstacles. The Agency for Healthcare Research and Quality (AHRQ) recommends involving frontline staff throughout health information technology implementation because collaboration leads to smoother adoption and more sustainable improvements.
Managers also have an important responsibility during implementation. Rather than expecting caregivers to adjust immediately, leaders should provide role-specific training, offer hands-on practice before the system goes live, and make experienced “super users” available to answer questions on each unit. Managers should also recognize that productivity may temporarily decrease while staff learn the new system. Creating a supportive environment where caregivers can ask questions and provide feedback helps reduce anxiety and increases confidence during the transition. Another important consideration is cybersecurity. As hospitals become more dependent on electronic records, they also become more vulnerable to cyberattacks (Sittig et al. 2025). The second assigned reading found that ransomware attacks on U.S. healthcare organizations more than doubled between 2016 and 2021, and nearly half of those attacks disrupted patient care through electronic system downtime, appointment cancellations, and ambulance diversions (Brach and Borsky 2020). During these situations, caregivers may suddenly lose access to patient records and medication information, making it essential for hospitals to provide training on downtime procedures and emergency documentation processes. Preparing caregivers for these situations helps maintain patient safety even when technology temporarily fails. Overall, successful EHR implementation depends on much more than installing new software. Hospitals that invest in caregiver training, encourage open communication, and continue providing support after implementation are more likely to achieve successful adoption while improving both employee satisfaction and patient care. When caregivers feel confident using the technology, they can spend less time struggling with documentation and more time focusing on what matters most—caring for their patients.
Data Visualization
Patient Profile-
The patient selected for this analysis was Subject ID 10013, who was admitted to the hospital with a primary diagnosis of sepsis (Hospital Admission ID 165520). Sepsis is a life-threatening condition caused by the body’s overwhelming response to infection and often requires intensive monitoring because patients can deteriorate rapidly. During this admission, the patient was transferred to the intensive care unit (ICU Stay ID 264446) where caregivers documented thousands of observations, medications, laboratory results, and clinical assessments through the hospital’s Electronic Health Record system. Although demographic information such as age and gender provides important context for understanding the patient’s health history, the primary focus of this analysis is the patient’s terminal hospitalization. Throughout the admission, nurses, physicians, respiratory therapists, and other caregivers continuously documented changes in the patient’s condition. These records created a detailed timeline that illustrates how electronic health records support communication, clinical decision-making, and continuity of care during critical illness.
ggplot(myquery1,
aes(x = as.POSIXct(charttime),
y = clinical_event,
color = caregiver_role)) +
geom_point(size = 2, alpha = 0.7) +
theme_minimal() +
labs(
title = "Key Clinical Events Recorded During the ICU Stay",
subtitle = "Subject ID 10013 | Diagnosis: Sepsis",
x = "Date and Time",
y = "Clinical Event",
color = "Caregiver Role"
) +
theme(axis.text.x = element_text(angle = 45, hjust = 1))
The first visualization demonstrates how different caregivers interacted with the patient throughout the ICU stay. Each point represents a documented clinical activity recorded in the Electronic Health Record. Nurses are expected to contribute the largest number of documentation events because they perform continuous bedside assessments, medication administration, and routine monitoring. Physicians and other healthcare professionals document less frequently but provide essential treatment decisions and progress notes. As the patient’s condition worsened, documentation is expected to become increasingly frequent. This pattern reflects the need for closer observation as sepsis progresses toward organ dysfunction and death. Rather than relying on verbal communication alone, caregivers were able to use the EHR to continuously share patient information across multiple disciplines. This illustrates one of the greatest advantages of EHR implementation: providing every caregiver with immediate access to the patient’s most current clinical information while creating a permanent record of care delivered.
Second Visualization
SELECT
ce.charttime,
d.label,
ce.valuenum
FROM chartevents ce
INNER JOIN d_items d
ON ce.itemid = d.itemid
WHERE ce.icustay_id = 264446
AND d.label IN
(
'Heart Rate',
'Systolic Blood Pressure',
'Respiratory Rate',
'O2 saturation pulseoxymetry'
)
AND ce.valuenum IS NOT NULL
ORDER BY ce.charttime;ggplot(myquery2,
aes(x = as.POSIXct(charttime),
y = valuenum,
group = label)) +
geom_line(color = "steelblue", linewidth = 1) +
facet_wrap(~label, scales = "free_y", ncol = 1) +
theme_minimal() +
labs(
title = "Patient Vital Signs During the ICU Stay",
x = "Date and Time",
y = "Measurement"
) +
theme(axis.text.x = element_text(angle = 45, hjust = 1))
This visualization illustrates how the patient’s clinical condition changed throughout the hospitalization. Patients with sepsis often experience declining blood pressure, increasing heart rate, abnormal respiratory rates, and decreasing oxygen saturation as the infection progresses. Displaying these measurements over time allows caregivers to recognize worsening physiological trends that may not be obvious from a single observation. The EHR makes these trends immediately visible to every member of the healthcare team. Instead of reviewing isolated measurements, caregivers can identify patterns of deterioration and communicate changes more effectively. Continuous electronic documentation also supports clinical decision-making by allowing providers to evaluate how the patient’s condition responds to medications and other treatments. For critically ill patients such as this one, timely access to these trends is essential for providing coordinated, evidence-based care.
Connection between the visualizations
The patient’s hospitalization demonstrates the important role Electronic Health Records play in caring for critically ill patients. After being admitted with sepsis, the patient required intensive monitoring and frequent assessments throughout the ICU stay. Nurses documented vital signs, medication administration, and changes in the patient’s condition throughout each shift, while physicians and other clinicians recorded treatment decisions and diagnostic findings. The first visualization highlights the continuous involvement of caregivers during the patient’s hospitalization, while the second illustrates the patient’s gradual physiological decline leading to death. Together, these visualizations show that EHRs are much more than electronic versions of paper charts. They provide caregivers with real-time access to patient information, improve communication across the healthcare team, and create a complete clinical history that supports timely medical decision-making. For patients with rapidly changing conditions such as sepsis, this continuous flow of information is essential for delivering safe and coordinated care.
Recommendations for Industry
Frontline caregivers should participate in workflow design, usability testing, and implementation planning before the system goes live. Their involvement ensures that documentation reflects actual clinical practice rather than administrative assumptions (AHRQ). Also, provide role-specific education, that is, rather than offering identical training for all employees, hospitals should tailor education to each caregiver’s daily responsibilities. Nurses, nursing assistants, therapists, and technicians all use different EHR functions and require specialized instruction. Another recommendation would be that experienced caregivers should receive advanced training so they can provide immediate assistance to coworkers during implementation. Peer support reduces frustration while increasing confidence in the new system. Lastly, because ransomware attacks increasingly disrupt patient care, caregivers should receive annual training on downtime procedures, secure documentation practices, and cybersecurity awareness. This ensures continuity of care even when electronic systems become unavailable.
References
Adler-Milstein, Julia, and Ashish K Jha. 2017. “HITECH Act Drove Large Gains in Hospital Electronic Health Record Adoption.” Health Affairs 36 (8): 1416–22.
Brach, Cindy, and Amanda Borsky. 2020. “How the US Agency for Healthcare Research and Quality Promotes Health Literate Health Care.” Studies in Health Technology and Informatics 269: 313.
Sittig, Dean F, Trisha Flanagan, Patricia Sengstack, Rosann T Cholankeril, Sara Ehsan, Amanda Heidemann, Daniel R Murphy, Hojjat Salmasian, Jason S Adelman, and Hardeep Singh. 2025. “Revisions to the Safety Assurance Factors for Electronic Health Record Resilience (SAFER) Guides to Update National Recommendations for Safe Use of Electronic Health Records.” Journal of the American Medical Informatics Association 32 (4): 755–60.
Zadvinskis, Inga M, Jessica Garvey Smith, and Po-Yin Yen. 2018. “Nurses’ Experience with Health Information Technology: Longitudinal Qualitative Study.” JMIR Medical Informatics 6 (2): e8734.