Skip to main content
Home

Navigation controls

  • Search
  • Menu
September 9 – 12, 2025 | NIH Main Bethesda, Campus

Social

  • Twitter
  • Facebook
  • Email

Current Research Festival

  • 2025
  • 2024
    • General Schedule of Events
    • 2024 NIH Distinguished Scholars Program
    • Poster Sessions
    • Concurrent Workshops
    • NIH Resource Information Fair
    • National Academy of Science Mini-Symposium
    • Special Wednesday Events
    • Vendor Exhibit Information
    • Green Labs Fair
    • Research Festival Committee
  • 2023
    • General Schedule of Events
    • NIH Early–Career Investigator Lectures
    • Poster Sessions
    • Concurrent Workshops
    • NIH Resource Information Fair
    • Vendor Exhibit Information
    • Research Festival Committee
  • 2021
  • 2019
    • General Schedule of Events
    • Plenary Sessions
    • Poster Session
    • Data Blitz
    • FARE Award Ceremony
    • Special Exhibits on Resources for Intramural Research
    • Technical Sales Association (TSA) Research Festival Exhibit Tent Show
    • Research Festival Committee
  • 2018
    • General Schedule of Events
    • Plenary Sessions
    • Concurrent Symposia Sessions
    • Poster Sessions
    • FARE Award Ceremony
    • Special Exhibits on Resources for Intramural Research
    • Technical Sales Association (TSA) Research Festival Exhibit Tent Show
    • Research Festival Committees
  • 2017
    • General Schedule of Events
    • Plenary Sessions
    • Concurrent Symposia Sessions
    • Poster Sessions
    • FARE Award Ceremony
    • Future Research Leaders
    • Special Exhibits on Resources for Intramural Research
    • Technical Sales Association (TSA) Research Festival Exhibit Tent Show
    • Research Festival Committees
  • 2016
    • General Schedule of Events
    • Plenary Sessions
    • Concurrent Symposia Sessions
    • Poster Sessions
    • Browse by Presenter Name
    • Browse by Presenter IC
    • FARE Award Ceremony
    • Future Research Leaders
    • Special Exhibits on Resources for Intramural Research
    • Technical Sales Association (TSA) Research Festival Exhibit Tent Show
    • Tours of the National Library of Medicine and Clinical Center
    • Research Festival Committees
  • 2015
    • General Schedule of Events
    • Plenary Sessions
    • Concurrent Workshop Sessions
    • Poster Sessions
    • Browse by Presenter Name
    • Browse by Presenter IC
    • FARE Award Ceremony
    • Future Research Leaders
    • Special Exhibits on Resources for Intramural Research
    • TSA Research Festival Exhibit Show
    • NIH Tours
    • Research Festival Committees
  • 2014
  • 2013
  • 2012
  • 2011
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • 2004
  • 2003
  • 2002
  • 2001
  • 2000

Main navigation

  • All Research Festivals
    • 2025
    • 2024
    • 2023
    • 2021
    • 2019
    • 2018
    • 2017
    • 2016
    • 2015
    • 2014
    • 2013
    • 2012
    • 2011
    • 2010
    • 2009
    • 2008
    • 2007
    • 2006
    • 2005
    • 2004
    • 2003
    • 2002
    • 2001
    • 2000

NIH Research Festival

September 12 – 14, 2018

Quality Control For A CDISC+SDTM Based Clinical Data Warehouse

Wednesday, September 12, 2018 – Poster Session I
12:00 – 1:30 p.m.

FAES Terrace

NIAID

RSCHSUPP-22

Authors

  • G Wei
  • J Xiao
  • KK Bajwa
  • SK Debrincat
  • C Whalen
  • M Tartakovsky

Abstract

BACKGROUND-Multiple data warehouses using data mart subsets are becoming common place in research environments. The continuous flow of data from one database to another creates the potential for errors. The OCICB has established a Clinical Data Warehouse (CDW) using CDISC+SDTM model. The clinical trial study data transfers from the Clinical Data Management System (CDMS) to the CDW via an Extract, Transform, and Load (ETL) process. We required a quality control (QC) process prior to the CDW release to the study teams. OBJECTIVES-Establish a reliable protocol to QC the CDW. METHODOLOGY- Using SAS programs, we developed a QC protocol to validate (1) the clinical data migration. Three key variables (CRF Page #, Subject ID and unique CDMS Sequence number) were extracted from CDW, sorted, and duplicate records removed. The records were compared with mapped variables from the CDMS database. SAS reports generate if inconsistencies identified. (2) A complete check of the Data structure in the CDW by each CDISC domain to ensure that the mapping fully follows the ETL specification which are generated based on SDTM data model. RESULTS- The clinical trial data for multiple protocols were validated using the methodology. It proved successful in identifying data errors and structure inconsistencies. CONCLUSION/DISCUSSION–By comparing the data in the CDW directly with data in CDMS database. The validation is a reliable QC approach for both the ETL and the mapping specifications.

Scientific Focus Area: Research Support Services

This page was last updated on Friday, March 26, 2021

  • General Schedule of Events
  • Plenary Sessions
  • Concurrent Symposia Sessions
  • Poster Sessions
  • FARE Award Ceremony
  • Special Exhibits on Resources for Intramural Research
  • Technical Sales Association (TSA) Research Festival Exhibit Tent Show
  • Research Festival Committees

2018 program

Download the 2018 Research Festival Schedule Overview (6 pages)

  • Email
  • Print
  • Share Twitter Facebook LinkedIn

Current Research Festival

  • 2025
  • 2024
    • General Schedule of Events
    • 2024 NIH Distinguished Scholars Program
    • Poster Sessions
    • Concurrent Workshops
    • NIH Resource Information Fair
    • National Academy of Science Mini-Symposium
    • Special Wednesday Events
    • Vendor Exhibit Information
    • Green Labs Fair
    • Research Festival Committee
  • 2023
    • General Schedule of Events
    • NIH Early–Career Investigator Lectures
    • Poster Sessions
    • Concurrent Workshops
    • NIH Resource Information Fair
    • Vendor Exhibit Information
    • Research Festival Committee
  • 2021
  • 2019
    • General Schedule of Events
    • Plenary Sessions
    • Poster Session
    • Data Blitz
    • FARE Award Ceremony
    • Special Exhibits on Resources for Intramural Research
    • Technical Sales Association (TSA) Research Festival Exhibit Tent Show
    • Research Festival Committee
  • 2018
    • General Schedule of Events
    • Plenary Sessions
    • Concurrent Symposia Sessions
    • Poster Sessions
    • FARE Award Ceremony
    • Special Exhibits on Resources for Intramural Research
    • Technical Sales Association (TSA) Research Festival Exhibit Tent Show
    • Research Festival Committees
  • 2017
    • General Schedule of Events
    • Plenary Sessions
    • Concurrent Symposia Sessions
    • Poster Sessions
    • FARE Award Ceremony
    • Future Research Leaders
    • Special Exhibits on Resources for Intramural Research
    • Technical Sales Association (TSA) Research Festival Exhibit Tent Show
    • Research Festival Committees
  • 2016
    • General Schedule of Events
    • Plenary Sessions
    • Concurrent Symposia Sessions
    • Poster Sessions
    • Browse by Presenter Name
    • Browse by Presenter IC
    • FARE Award Ceremony
    • Future Research Leaders
    • Special Exhibits on Resources for Intramural Research
    • Technical Sales Association (TSA) Research Festival Exhibit Tent Show
    • Tours of the National Library of Medicine and Clinical Center
    • Research Festival Committees
  • 2015
    • General Schedule of Events
    • Plenary Sessions
    • Concurrent Workshop Sessions
    • Poster Sessions
    • Browse by Presenter Name
    • Browse by Presenter IC
    • FARE Award Ceremony
    • Future Research Leaders
    • Special Exhibits on Resources for Intramural Research
    • TSA Research Festival Exhibit Show
    • NIH Tours
    • Research Festival Committees
  • 2014
  • 2013
  • 2012
  • 2011
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • 2004
  • 2003
  • 2002
  • 2001
  • 2000

Main navigation

  • All Research Festivals
    • 2025
    • 2024
    • 2023
    • 2021
    • 2019
    • 2018
    • 2017
    • 2016
    • 2015
    • 2014
    • 2013
    • 2012
    • 2011
    • 2010
    • 2009
    • 2008
    • 2007
    • 2006
    • 2005
    • 2004
    • 2003
    • 2002
    • 2001
    • 2000
  • Department of Health and Human Services
  • National Institutes of Health
  • USA.gov

Footer

  • Home
  • Contact Us
  • IRP
  • HHS Vulnerability Disclosure
  • Web Policies and Notices
  • Site Map
  • Search