Skip to main content

CHDI Children's Health Datamart Development

Friday, January 25, 2019
CHDI logo

Child health and well-being are affected by multiple factors, including patient intrinsic factors such as genes and biology and patient extrinsic factors such as the physical environment, social and economic factors of a child’s family and community, and the health behaviors of the child, the child’s family, and the larger community. In order to fully understand the factors that determine childhood as well as life-long health and well-being and to develop effective interventions to improve health and well-being, it is important to have a complete understanding of all of these factors. Duke University Health System (DUHS) has spent a substantial amount of time and money in developing a highly useful and flexible electronic health records (EHR) system based on the Epic Systems platform. While this system allows healthcare providers to easily record information on every patient seen at DUHS, the data from this system are stored in an enterprise data warehouse that requires significant expertise and time to navigate.

In order to make well-curated HER data more readily accessible to Duke researchers, the Children's Health and Discovery Initiative (CHDI) is working to create a Children’s Health Datamart. This datamart will provide a subset of consistently defined data elements from the EHR platform that can be used to investigate patient intrinsic and extrinsic factors that affect the health and well-being of children served by DUHS.

The datamart will include well-defined and curated variables, including (but not limited to):

  • Demographics
  • Time varying patient address (encoded as latitude/longitude)
  • Vital signs (Height, Weight, BMI, Temperature, Blood Pressure)
  • Encounter-specific data, including primary payer, encounter type, encounter ID, enoucnter date, provider specialty
  • Clinic information, including clinic ID and location
  • Laboratory and imaging results
  • Diagnosis codes
  • Vaccine records
  • Procedures
  • Medications

The datamart will be refreshed on a semiannual basis. Additionally, elements included in the datamart will be reviewed and curated regularly to ensure that the data contained within the datamart is meeting the needs of researchers and that it is being properly sourced from the DSR.

We are currently meeting with investigators from across Duke University to help determine which elements should be included in the datamart to help meet a variety of research needs.

If you would like to set up a meeting with the CHDI Datamart group, please email us at: