Michael Kahl, MBA, PMP, a Senior Data Analyst for Information Management & Enterprise Reporting at Duke Health Technology Solutions (DHTS), presented a poster titled “Traceability in Healthcare Data Sharing Projects Through the Use of Data Warehousing Artifacts:Methods from the Southeastern Diabetes Initiative (SEDI)” at the Healthcare Data Warehouse Association (HDWA) conference October 1-3, 2013 in Scottsdale, Arizona. The poster, authored by the members of the Southeastern Diabetes Initiative (SEDI) Informatics team—including Kahl and fellow DHTS Information Management department staff members Felicia Dunston, Lori Morris, and Shelley Rusincovitch—details the standard process followed by the team to gather, analyze, profile, and evaluate data shared from varying EHR platforms in use at the current data sharing partner sites, which are located in four counties across the southeastern United States (Cabarrus County and Durham County, NC; Mingo County, WV; Quitman County, MS).
The goal of the process is to provide a mechanism that drives data traceability within data sourced from each EHR platform and facilitates thorough analysis and profiling of the shared data during Phase 1 of the SEDI Datamart development. To meet the goal, output documentation is created during each step of the process that serves as input documentation for the next step. As a result, the output artifacts that are created ultimately serve as cross-references and reality checks during the development of the SEDI Datamart. The SEDI Informatics team has determined that by following the process as well as by creating thorough documentation in the way of Source System Analysis Documentation, Data Dictionaries for the Data Extracts, and Data Submission Reports throughout each step of the approach, the building of the SEDI Datamart will be more consistent across data sharing partners. Less duplication of effort when future data sharing partners are integrated into the datamart is also expected to be a tangible benefit. As a result, the team believes adequate flexibility and scalability is allowed for while still keeping the level of stability necessary in order to ensure quality data exists when integration is implemented as part of Phase 2 of the SEDI Datamart development.