Please use this identifier to cite or link to this item:
Title: Establishing a sorting protocol for healthcare databases
Authors: Ghabi, Elie
Farah, Wehbeh
Abboud, Maher
Chalhoub, Elias
Ziade, Nelly
Annesi-Maesano, Isabella
Abi-Habib, Laurie
Mrad, Myriam A. 
Affiliations: Faculty of Medicine 
Department of Public Health 
Keywords: Data cleaning
Health record
Sorting protocol
Issue Date: 2021
Part of: Journal of Public Health Research
Volume: 10
Issue: 173
Background: Health information records in many countries, especially developing countries, are still paper based. Compared to electronic systems, paper-based systems are disadvantageous in terms of data storage and data extraction. Given the importance of health records for epidemiological studies, guidelines for effective data cleaning and sorting are essential. They are, however, largely absent from the literature. The following paper discusses the process by which an algorithm was developed for the cleaning and sorting of a database generated from emergency department records in Lebanon.

Design and methods: Demographic and health related information were extracted from the emergency department records of three hospitals in Beirut. Appropriate categories were selected for data categorization. For health information, disease categories and codes were selected according to the International Classification of Disease 10th Edition.

Results: A total of 16,537 entries were collected. Demographic information was categorized into groups for future epidemiological studies. Analysis of the health information led to the creation of a sorting algorithm which was then used to categorize and code the health data. Several counts were then performed to represent and visualize the data numerically and graphically.

Conclusions: The article describes the current state of health information records in Lebanon and the associated disadvantages of a paper-based system in terms of storage and data extraction. Furthermore, the article describes the algorithm by which health information was sorted and categorized to allow for future data analysis using paper records.
ISSN: 2279-9028
DOI: 10.4081/jphr.2021.1722
Open URL: Link to full text
Type: Journal Article
Appears in Collections:Faculty of Medicine

Show full item record

Record view(s)

checked on Dec 1, 2023

Google ScholarTM


Dimensions Altmetric

Dimensions Altmetric

Items in DSpace are protected by copyright, with all rights reserved, unless otherwise indicated.