We have located links that may give you full text access.
Journal Article
Research Support, Non-U.S. Gov't
An Approach to Acquiring, Normalizing, and Managing EHR Data From a Clinical Data Repository for Studying Pressure Ulcer Outcomes.
Journal of Wound, Ostomy, and Continence Nursing 2016 January
Changes in the methods that individual facilities follow to collect and store data related to hospital-acquired pressure ulcer (HAPU) occurrences are essential for improving patient outcomes and advancing our understanding the science behind this clinically relevant issue. Using an established electronic health record system at a large, urban, tertiary-care academic medical center, we investigated the process required for taking raw data of HAPU outcomes and submitting these data to a normalization process. We extracted data from 1.5 million patient shifts and filtered observations to those with a Braden score and linked tables in the electronic health record, including (1) Braden scale scores, (2) laboratory outcomes data, (3) surgical time, (4) provider orders, (5) medications, and (6) discharge diagnoses. Braden scores are important measures specific to HAPUs since these scores clarify the daily risk of a hospitalized patient for developing a pressure ulcer. The other more common measures that may be associated with HAPU outcomes are important to organize in a single data frame with Braden scores according to each patient. Primary keys were assigned to each table, and the data were processed through 3 normalization steps and 1 denormalization step. These processes created 8 tables that can be stored efficiently in a clinical database of HAPU outcomes. As hospitals focus on organizing data for review of HAPUs and other types of hospital-acquired conditions, the normalization process we describe in this article offers directions for collaboration between providers and informatics teams using a common language and structure.
Full text links
Related Resources
Trending Papers
Challenges in Septic Shock: From New Hemodynamics to Blood Purification Therapies.Journal of Personalized Medicine 2024 Februrary 4
Molecular Targets of Novel Therapeutics for Diabetic Kidney Disease: A New Era of Nephroprotection.International Journal of Molecular Sciences 2024 April 4
The 'Ten Commandments' for the 2023 European Society of Cardiology guidelines for the management of endocarditis.European Heart Journal 2024 April 18
A Guide to the Use of Vasopressors and Inotropes for Patients in Shock.Journal of Intensive Care Medicine 2024 April 14
Diagnosis and Management of Cardiac Sarcoidosis: A Scientific Statement From the American Heart Association.Circulation 2024 April 19
Essential thrombocythaemia: A contemporary approach with new drugs on the horizon.British Journal of Haematology 2024 April 9
Get seemless 1-tap access through your institution/university
For the best experience, use the Read mobile app
All material on this website is protected by copyright, Copyright © 1994-2024 by WebMD LLC.
This website also contains material copyrighted by 3rd parties.
By using this service, you agree to our terms of use and privacy policy.
Your Privacy Choices
You can now claim free CME credits for this literature searchClaim now
Get seemless 1-tap access through your institution/university
For the best experience, use the Read mobile app