Dataset Information

Establishment of a Simple Pediatric Lower Respiratory Tract Infections Database Based on the Structured Electronic Medical Records.

ABSTRACT:

Objective

This study aimed to establish a pediatric lower respiratory tract infections (PLRTIs) database based on the structured electronic medical records (SEMRs), to provide a brief overview and the usage process of the SEMRs and the database.

Methods

All the medical information is recorded by a clinical information system developed by Eureka Systems Company. A plugin of the software was used to set the properties of items of the SEMR. Children with lower respiratory tract infections (LRTIs) who were admitted to the department of respiratory medicine of our hospital from May 2020 were included. PostgreSQL 13.1 software was used to construct the PLRTIs database.

Results

Seven kinds of SEMRs were established, and the admission record was the most important and complex among them. It was mainly composed of 10 parts, i.e., basic information, history of present illness, past history (without respiratory disease), past history of respiratory diseases, personal history, family history, physical examination, the score of LRTIs, auxiliary examination, and diagnosis. With the three-level doctor ward round, the recorded information of the SEMR would be checked repeatedly, thus guaranteeing the correctness of the information. The data of the SEMR and laboratory tests could be extracted directly from the hospital information system (HIS) by PostgreSQL 13.1 software with the specific structured query language (SQL) code. After manually checking the original records, the datasets were imported into PostgreSQL 13.1 software, and a simple PLRTIs database was constructed. According to the inclusion criteria of this study, a total of 1,184 children with LRTIs were included in this database from 1 May 2020 to 30 April 2021.

Conclusion

A series of SEMRs for PLRTIs were designed and used during the hospitalization. A simple PLRTIs database was established based on the SEMR. The SEMRs will provide complete and high-quality data on LRTIs in children.

SUBMITTER: Lin J

PROVIDER: S-EPMC9243234 | biostudies-literature |

REPOSITORIES: biostudies-literature

ACCESS DATA

Similar Datasets

Project description:IntroductionBy linking datasets, electronic records can be used to build large birth-cohorts, enabling researchers to cost-effectively answer questions relevant to populations over the life-course. Currently, around 5.8 million Palestinian refugees live in five settings: Jordan, Lebanon, Syria, West Bank, and Gaza Strip. The United Nations Relief and Works Agency for Palestine Refugees in the Near East (UNRWA) provides them with free primary health and elementary-school services. It maintains electronic records to do so.We aimed to establish a birth cohort of Palestinian refugees born between 1st January 2010 and 31st December 2020 living in five settings by linking mother obstetric records with child health and education records and to describe some of the cohort characteristics. In future, we plan to assess effects of size-at-birth on growth, health and educational attainment, among other questions.MethodsWe extracted all available data from 140 health centres and 702 schools across five settings, i.e. all UNRWA service users. Creating the cohort involved examining IDs and other data, preparing data, de-duplicating records, and identifying live-births, linking the mothers' and children's data using different deterministic linking algorithms, and understanding reasons for non-linkage.ResultsWe established a birth cohort of Palestinian refugees using electronic records of 972,743 live births. We found high levels of linkage to health records overall (83%), which improved over time (from 73% to 86%), and variations in linkage rates by setting: these averaged 93% in Gaza, 89% in Lebanon, 75% in Jordan, 73% in West Bank and 68% in Syria. Of the 423,580 children age-eligible to go to school, 47% went to UNRWA schools and comprised of 197,479 children with both health and education records, and 2,447 children with only education records. In addition to year and setting, other factors associated with non-linkage included mortality and having a non-refugee mother. Misclassification errors were minimal.ConclusionThis linked open birth-cohort is unique for refugees and the Arab region and forms the basis for many future studies, including to elucidate pathways for improved health and education in this vulnerable, understudied population. Our characterization of the cohort leads us to recommend using different sub-sets of the cohort depending on the research question and analytic purposes.