SELECT
admissions.subject_id,
admissions.hadm_id,
admissions.admittime,
admissions.dischtime,
admissions.deathtime,
admissions.admission_type,
admissions.diagnosis,
icustays.first_careunit,
ROUND((julianday(admissions.dischtime) - julianday(admissions.admittime)), 2) AS hospital_days
FROM admissions
JOIN icustays
ON admissions.hadm_id = icustays.hadm_id
WHERE admissions.deathtime IS NOT NULL
LIMIT 10Analysis Report Four - Health Privacy and Data Profiling
Executive Summary
Electronic Health Records (EHRs) have fundamentally transformed how healthcare organizations collect, manage, and share patient information. While these systems improve access to clinical data and strengthen decision-making, successful implementation depends on more than technology alone. Nurses, respiratory therapists, and other frontline caregivers must adapt to new documentation workflows while continuing to provide safe, high-quality patient care. This report combines SQL analysis of the MIMIC-III database with current healthcare research to evaluate how EHR implementation affects caregivers and to identify organizational practices that promote successful adoption. The findings indicate that hospitals achieve the best outcomes when managers provide strong leadership, continuous training, workflow redesign, and active caregiver involvement throughout implementation.
Introduction
Healthcare organizations generate enormous volumes of patient information every day, including admission records, medication histories, laboratory results, physician documentation, and vital signs. Before Electronic Medical Records (EMRs) and Electronic Health Records (EHRs), this information was often stored in paper charts across multiple departments, making communication slower and increasing the risk of duplicate testing and medical error (Menachemi and Collum 2011).
Modern EHR systems allow authorized healthcare providers to securely access patient information across departments and care settings, improving communication, reducing unnecessary testing, and supporting better clinical decision-making. However, implementing an EHR represents a major organizational change rather than simply installing new software. Because nurses, respiratory therapists, technicians, and other caregivers interact with these systems every day, successful implementation depends heavily on employee acceptance, workflow redesign, and organizational support (McAlearney et al. 2015).
The Healthcare Context
Although EHR systems provide significant clinical benefits, implementation often creates substantial challenges for frontline caregivers. Employees must learn new documentation procedures while maintaining patient care responsibilities, frequently resulting in temporary reductions in productivity, frustration, and resistance to organizational change. McAlearney et al. (2015) describe this transition as similar to the stages of grief, arguing that successful implementation depends less on the software itself than on leadership, communication, and employee engagement throughout the implementation process (McAlearney et al. 2015).
Long-term studies further support these findings. Rather et al. (2019) reported that physicians and nurses continued experiencing documentation burdens and workflow challenges years after Meaningful Use implementation (Rathert et al. 2019). These findings demonstrate that EHR implementation should be viewed as an ongoing organizational change initiative rather than a one-time technology project.
Research also shows that successful EHR implementation depends on how well the technology fits into caregivers’ daily workflow. Holden (2010) found that healthcare professionals are more likely to accept electronic health record systems when the software improves efficiency, supports patient care, and is accompanied by adequate training and organizational support. These findings reinforce the importance of involving frontline caregivers throughout implementation so that technology enhances, rather than disrupts, clinical practice (Holden 2010).
Data Visualizations
Visualization One - Hospital Length of Stay by ICU Unit
ggplot(data = myquery1,
aes(x = reorder(first_careunit, hospital_days),
y = hospital_days)) +
geom_col() +
coord_flip() +
labs(
title = "Hospital Length of Stay by ICU Unit",
x = "ICU Unit",
y = "Hospital Days"
)
The first SQL query combines the admissions and icustays tables to examine the total hospital length of stay while identifying each patient’s primary ICU assignment. Rather than reviewing isolated patient records, the query demonstrates how EHR systems integrate information from multiple clinical sources into a single patient profile.
Figure 1 demonstrates that patients admitted to the Medical Intensive Care Unit (MICU) experienced longer hospital stays than patients admitted to several other ICU units within this sample. Longer hospitalizations generally require greater interdisciplinary communication, increased documentation, and more coordinated patient management. These findings illustrate how EHR systems improve caregiver access to patient information by integrating clinical data from multiple departments into a single electronic record.
From a caregiver perspective, centralized access to patient information supports faster clinical decision-making, reduces time spent locating paper records, and improves communication among healthcare professionals (Menachemi and Collum 2011).
Visualization Two - Caregiver Charting Activity in the EHR
SELECT
caregivers.label,
COUNT(chartevents.row_id) AS chart_count
FROM chartevents
JOIN caregivers
ON chartevents.cgid = caregivers.cgid
WHERE caregivers.label IS NOT NULL
AND TRIM(caregivers.label) != ''
AND TRIM(caregivers.label) != '-'
GROUP BY caregivers.label
ORDER BY chart_count DESC
LIMIT 10ggplot(data = myquery2,
aes(x = reorder(label, chart_count),
y = chart_count)) +
geom_col() +
coord_flip() +
labs(
title = "Caregiver Charting Activity in the EHR",
x = "Caregiver Role",
y = "Number of Charted Events"
)
The second SQL query analyzes documentation activity by combining caregiver and chartevents data to determine which caregiver roles contribute the greatest number of chart entries within the electronic health record.
Figure 2 demonstrates that Registered Nurses complete substantially more documentation than any other caregiver group represented in the dataset. Respiratory therapists and several additional nursing classifications also contribute documentation but at considerably lower frequencies.
These findings emphasize that nurses serve as the primary users of electronic health record systems. Because nurses interact with the EHR throughout nearly every stage of patient care, they often experience the greatest impact from workflow changes introduced during implementation. Rather et al. (2019) similarly found that documentation burden remains one of the largest concerns among nursing staff following EHR adoption (Rathert et al. 2019).
These results suggest that hospitals should actively involve frontline caregivers during software testing, workflow redesign, and implementation planning. Including caregivers in these decisions improves system usability while increasing employee acceptance of new technology.
Recommendations for Industry
Leadership and Change Management - Successful EHR implementation depends as much on organizational leadership as on technology itself. Managers should communicate clear expectations, involve caregivers early in planning, and provide opportunities for employees to express concerns throughout implementation. Research by McAlearney et al. (2015) suggests that acknowledging caregiver concerns significantly improves acceptance of new technology (McAlearney et al. 2015).
Training - Hospitals should provide phased implementation strategies that begin with comprehensive employee education before deployment and continue through ongoing support after implementation. Continuous training reduces anxiety, improves employee confidence, and helps caregivers adapt to changing documentation requirements (McAlearney et al. 2015; Holden 2010).
Caregiver Involvement - Frontline caregivers should actively participate in workflow redesign, software testing, and system evaluation because they use the EHR more frequently than any other employee group. Their feedback allows organizations to identify usability issues before implementation negatively affects patient care (Rathert et al. 2019).
Patient Privacy - Finally, healthcare organizations must continue strengthening cybersecurity practices while maintaining compliance with patient privacy regulations. Protecting sensitive health information remains essential for maintaining public trust and ensuring uninterrupted clinical operations as healthcare becomes increasingly dependent on electronic information systems (Menachemi and Collum 2011).
References
Holden, Richard J. 2010. “Physicians’ Beliefs about Using EMR and CPOE: In Pursuit of a Contextualized Understanding of Health IT Use Behavior.” International Journal of Medical Informatics 79 (2): 71–80. https://doi.org/10.1016/j.ijmedinf.2009.12.003.
McAlearney, Ann S., Jennifer L. Hefner, Cynthia J. Sieck, and Timothy R. Huerta. 2015. “The Journey Through Grief: Insights from a Qualitative Study of Electronic Health Record Implementation.” Health Services Research 50 (2): 462–88. https://doi.org/10.1111/1475-6773.12227.
Menachemi, Nir, and Taleah H. Collum. 2011. “Benefits and Drawbacks of Electronic Health Record Systems.” Risk Management and Healthcare Policy 4: 47–55. https://doi.org/10.2147/RMHP.S12985.
Rathert, Cheryl, Tracy H. Porter, Jessica N. Mittler, and Michelle Fleig-Palmer. 2019. “Seven Years After Meaningful Use: Physicians’ and Nurses’ Experiences with Electronic Health Records.” Health Care Management Review 44 (1): 30–40.