Creation of a Multicenter Pediatric Inpatient Data Repository Derived from Electronic Health Records

Christoph P. Hornik, Andrew M. Atz, Catherine M Bendel, Francis Chan, Kevin Downes, Robert Grundmeier, Ben Fogel, Debbie Gipson, Matthew Laughon, Michael Miller, Michael Smith, Chad Livingston, Cindy Kluchar, Anne Heath, Chanda Jarrett, Brian McKerlie, Hetalkumar Patel, Christina Hunter

Research output: Contribution to journalArticle

Abstract

Background Integration of electronic health records (EHRs) data across sites and access to that data remain limited. Objective We developed an EHR-based pediatric inpatient repository using nine U.S. centers from the National Institute of Child Health and Human Development Pediatric Trials Network. Methods A data model encompassing 147 mandatory and 99 optional elements was developed to provide an EHR data extract of all inpatient encounters from patients <17 years of age discharged between January 6, 2013 and June 30, 2017. Sites received instructions on extractions, transformation, testing, and transmission to the coordinating center. Results We generated 177 staging reports to process all nine sites' 147 mandatory and 99 optional data elements to the repository. Based on 520 prespecified criteria, all sites achieved 0% errors and <2% warnings. The repository includes 386,159 inpatient encounters from 264,709 children to support study design and conduct of future trials in children. Conclusion Our EHR-based data repository of pediatric inpatient encounters utilized a customized data model heavily influenced by the PCORnet format, site-based data mapping, a comprehensive set of data testing rules, and an iterative process of data submission. The common data model, site-based extraction, and technical expertise were key to our success. Data from this repository will be used in support of Pediatric Trials Network studies and the labeling of drugs and devices for children.

Original languageEnglish (US)
Pages (from-to)307-315
Number of pages9
JournalApplied clinical informatics
Volume10
Issue number2
DOIs
StatePublished - Jan 1 2019

Fingerprint

Pediatrics
Electronic Health Records
Inpatients
Health
Data structures
Drug Labeling
National Institute of Child Health and Human Development (U.S.)
Professional Competence
Testing
Labeling
Equipment and Supplies

Keywords

  • data extraction
  • electronic heath record reuse
  • inpatient repository
  • NICHD Pediatric Trials Network
  • pediatric clinical trials

PubMed: MeSH publication types

  • Journal Article

Cite this

Creation of a Multicenter Pediatric Inpatient Data Repository Derived from Electronic Health Records. / Hornik, Christoph P.; Atz, Andrew M.; Bendel, Catherine M; Chan, Francis; Downes, Kevin; Grundmeier, Robert; Fogel, Ben; Gipson, Debbie; Laughon, Matthew; Miller, Michael; Smith, Michael; Livingston, Chad; Kluchar, Cindy; Heath, Anne; Jarrett, Chanda; McKerlie, Brian; Patel, Hetalkumar; Hunter, Christina.

In: Applied clinical informatics, Vol. 10, No. 2, 01.01.2019, p. 307-315.

Research output: Contribution to journalArticle

Hornik, CP, Atz, AM, Bendel, CM, Chan, F, Downes, K, Grundmeier, R, Fogel, B, Gipson, D, Laughon, M, Miller, M, Smith, M, Livingston, C, Kluchar, C, Heath, A, Jarrett, C, McKerlie, B, Patel, H & Hunter, C 2019, 'Creation of a Multicenter Pediatric Inpatient Data Repository Derived from Electronic Health Records', Applied clinical informatics, vol. 10, no. 2, pp. 307-315. https://doi.org/10.1055/s-0039-1688477
Hornik, Christoph P. ; Atz, Andrew M. ; Bendel, Catherine M ; Chan, Francis ; Downes, Kevin ; Grundmeier, Robert ; Fogel, Ben ; Gipson, Debbie ; Laughon, Matthew ; Miller, Michael ; Smith, Michael ; Livingston, Chad ; Kluchar, Cindy ; Heath, Anne ; Jarrett, Chanda ; McKerlie, Brian ; Patel, Hetalkumar ; Hunter, Christina. / Creation of a Multicenter Pediatric Inpatient Data Repository Derived from Electronic Health Records. In: Applied clinical informatics. 2019 ; Vol. 10, No. 2. pp. 307-315.
@article{24a4fdbbf45f42d9a226135e89bc911c,
title = "Creation of a Multicenter Pediatric Inpatient Data Repository Derived from Electronic Health Records",
abstract = "Background Integration of electronic health records (EHRs) data across sites and access to that data remain limited. Objective We developed an EHR-based pediatric inpatient repository using nine U.S. centers from the National Institute of Child Health and Human Development Pediatric Trials Network. Methods A data model encompassing 147 mandatory and 99 optional elements was developed to provide an EHR data extract of all inpatient encounters from patients <17 years of age discharged between January 6, 2013 and June 30, 2017. Sites received instructions on extractions, transformation, testing, and transmission to the coordinating center. Results We generated 177 staging reports to process all nine sites' 147 mandatory and 99 optional data elements to the repository. Based on 520 prespecified criteria, all sites achieved 0{\%} errors and <2{\%} warnings. The repository includes 386,159 inpatient encounters from 264,709 children to support study design and conduct of future trials in children. Conclusion Our EHR-based data repository of pediatric inpatient encounters utilized a customized data model heavily influenced by the PCORnet format, site-based data mapping, a comprehensive set of data testing rules, and an iterative process of data submission. The common data model, site-based extraction, and technical expertise were key to our success. Data from this repository will be used in support of Pediatric Trials Network studies and the labeling of drugs and devices for children.",
keywords = "data extraction, electronic heath record reuse, inpatient repository, NICHD Pediatric Trials Network, pediatric clinical trials",
author = "Hornik, {Christoph P.} and Atz, {Andrew M.} and Bendel, {Catherine M} and Francis Chan and Kevin Downes and Robert Grundmeier and Ben Fogel and Debbie Gipson and Matthew Laughon and Michael Miller and Michael Smith and Chad Livingston and Cindy Kluchar and Anne Heath and Chanda Jarrett and Brian McKerlie and Hetalkumar Patel and Christina Hunter",
year = "2019",
month = "1",
day = "1",
doi = "10.1055/s-0039-1688477",
language = "English (US)",
volume = "10",
pages = "307--315",
journal = "Applied Clinical Informatics",
issn = "1869-0327",
publisher = "Schattauer GmbH",
number = "2",

}

TY - JOUR

T1 - Creation of a Multicenter Pediatric Inpatient Data Repository Derived from Electronic Health Records

AU - Hornik, Christoph P.

AU - Atz, Andrew M.

AU - Bendel, Catherine M

AU - Chan, Francis

AU - Downes, Kevin

AU - Grundmeier, Robert

AU - Fogel, Ben

AU - Gipson, Debbie

AU - Laughon, Matthew

AU - Miller, Michael

AU - Smith, Michael

AU - Livingston, Chad

AU - Kluchar, Cindy

AU - Heath, Anne

AU - Jarrett, Chanda

AU - McKerlie, Brian

AU - Patel, Hetalkumar

AU - Hunter, Christina

PY - 2019/1/1

Y1 - 2019/1/1

N2 - Background Integration of electronic health records (EHRs) data across sites and access to that data remain limited. Objective We developed an EHR-based pediatric inpatient repository using nine U.S. centers from the National Institute of Child Health and Human Development Pediatric Trials Network. Methods A data model encompassing 147 mandatory and 99 optional elements was developed to provide an EHR data extract of all inpatient encounters from patients <17 years of age discharged between January 6, 2013 and June 30, 2017. Sites received instructions on extractions, transformation, testing, and transmission to the coordinating center. Results We generated 177 staging reports to process all nine sites' 147 mandatory and 99 optional data elements to the repository. Based on 520 prespecified criteria, all sites achieved 0% errors and <2% warnings. The repository includes 386,159 inpatient encounters from 264,709 children to support study design and conduct of future trials in children. Conclusion Our EHR-based data repository of pediatric inpatient encounters utilized a customized data model heavily influenced by the PCORnet format, site-based data mapping, a comprehensive set of data testing rules, and an iterative process of data submission. The common data model, site-based extraction, and technical expertise were key to our success. Data from this repository will be used in support of Pediatric Trials Network studies and the labeling of drugs and devices for children.

AB - Background Integration of electronic health records (EHRs) data across sites and access to that data remain limited. Objective We developed an EHR-based pediatric inpatient repository using nine U.S. centers from the National Institute of Child Health and Human Development Pediatric Trials Network. Methods A data model encompassing 147 mandatory and 99 optional elements was developed to provide an EHR data extract of all inpatient encounters from patients <17 years of age discharged between January 6, 2013 and June 30, 2017. Sites received instructions on extractions, transformation, testing, and transmission to the coordinating center. Results We generated 177 staging reports to process all nine sites' 147 mandatory and 99 optional data elements to the repository. Based on 520 prespecified criteria, all sites achieved 0% errors and <2% warnings. The repository includes 386,159 inpatient encounters from 264,709 children to support study design and conduct of future trials in children. Conclusion Our EHR-based data repository of pediatric inpatient encounters utilized a customized data model heavily influenced by the PCORnet format, site-based data mapping, a comprehensive set of data testing rules, and an iterative process of data submission. The common data model, site-based extraction, and technical expertise were key to our success. Data from this repository will be used in support of Pediatric Trials Network studies and the labeling of drugs and devices for children.

KW - data extraction

KW - electronic heath record reuse

KW - inpatient repository

KW - NICHD Pediatric Trials Network

KW - pediatric clinical trials

UR - http://www.scopus.com/inward/record.url?scp=85065620090&partnerID=8YFLogxK

UR - http://www.scopus.com/inward/citedby.url?scp=85065620090&partnerID=8YFLogxK

U2 - 10.1055/s-0039-1688477

DO - 10.1055/s-0039-1688477

M3 - Article

VL - 10

SP - 307

EP - 315

JO - Applied Clinical Informatics

JF - Applied Clinical Informatics

SN - 1869-0327

IS - 2

ER -