THE DEPARTMENT OF BIOMEDICAL AND HEALTH INFORMATICS DBHI

THE DEPARTMENT OF BIOMEDICAL AND HEALTH INFORMATICS (DBHI) Clinical Reporting Unit (CRU) Daniel Singleton RN BSN Manager of Reporting and Data Management

CLINICAL REPORTING UNIT • The Clinical Reporting Unit is part of the Department of Biomedical and Health Informatics (DBHi – Bryan Wolf) • CRU Leadership • Dr. Robert Grundmeier Attending Physician and Director of Clinical Informatics • Daniel Singleton, Manager Reporting and Data Management • CRU Team Members • • • Diego Campos, Principle Information Analyst Evanette Burrows, Information Analyst Mark Ramos, Information Analyst Svetlana Ostapenko, Information Analyst Jesse Dudley, Information Analyst Matt Miller, Information Analyst https: //dbhi. chop. ed 2

CLINICAL REPORTING UNIT • The CRU is DBHi’s primary resource for accessing data contained within the Electronic Health Record (EHR) system • Directed by IRB approved protocols Our Mission • To work collaboratively with clinical researchers • Deliver actionable data • Provide meaningful insights into the EHR Data • Provide tools for efficient data management 3

CRU ACTIVITIES : ACCESS • Gain access to Electronic Health Record (EHR) • Primary data sources • Epic: encounter information, diagnoses, procedures, immunizations, medications, laboratory (Quest, Labcorp and Hospital), flowsheet data… • CDW: CHOP Data Warehouse containing data from both legacy systems and EPIC • Including inpatient and ambulatory data from all care network practices and specialties 4

CRU ACTIVITIES : REVIEW • Resolve inconsistencies and anomalies with the data • Iteratively tweak queries • Collaboration between the CRU and the research teams to find and minimize the effects of these anomalies • Inconsistency • Not all sites populate the same data fields with the same degree of precision (e. g. fully clothed weight on a hallway scale) • Just because a template exists and should be used does not mean it is actually used • Reset expectations about what data is available for research purposes 5

CRU ACTIVITIES : OUTPUT • Provide custom formatted deliverables • REDCap databases • XML • tab- or comma-delimited text • Excel spreadsheets • Qlik. View • PEDSnet/OMOP/PCORNET formats 6

CRU ACTIVITIES : SERVICES • Data de-identification • Honest broker services • Identification of matched controls Outside the Box • Geo-spatial coding of data • Integration of EHR data with prospectively captured data • Natural Language Processing 7

HOW DO YOU CONTACT US? • Data and Analytics Request Portal • Centralized intake portal for data and analytics support • Email : singletond@email. chop. edu • Phone : (267)-425 -5533 8

LINKS • Data and Analytics Request Portal • DBHi Home page • Data and Reporting Management • Arcus Education Portal 9

THANK TOU! 10