The Boston Medical Center Clinical Data Warehouse …lots of answers … what’s the question? Linda Rosen, MSEE Clinical Data Warehouse Research Manager
What is a Database? A collection of information organized to provide efficient retrieval.
What is the Clinical Data Warehouse? In 2005, Boston Medical Center embarked on a major project to collect data spread throughout its many electronic systems into a consolidated, organized and accessible database for analysis, reporting and research purposes. The Clinical Data Warehouse currently has about 12-15 years of clinical data -- depending on the application. The CDW is a resource for many different purposes — Quality Control, Improvement in Care, Regulatory Reporting, Daily Business Reporting, State Reporting… and for research.
The CDW is A database containing data from multiple sources. • Many years of historical data extracted from BMC’s various • clinical software packages – some now static. A database containing data related to each other with unique • identifiers. A database that is only as good as the data entered. • A significant resource for researchers. • NOT real time data. •
BMC Clinical Data Warehouse IBEX * SDK Daily/ Weekly SCM * EWS Daily PICIS * EPIC Clarity CDW Daily Logician * Tumor Registry CHCs Weekly Static
How to use the CDW for Research? What’s available? How do I get data? Why can’t I search myself? When do I need IRB approval?
Data currently available in the CDW SDK – Registration, billing, visit dx Info (ICD-9 codes) • *Logician – Outpatient, Labs, Vitals, Visits, Problems, Meds • *SCM – Inpatient Data, Labs, Documents, Meds • *IBEX – Emergency Department, Meds, • *PICIS – Surgery • Tumor Registry • EWS – Appointments • Anesthesia Manager • EPIC • EPIC Notes – accessible, but not in the CDW • Some Community Health Center Data • * static data •
Person Encounter Medications Orders PID ClientVisits PAT_ID EXTERNALID PAT_ID SEX PAT_MRN_ID MRN PAT_MRN_ID IDCODE GENDER ACCOUNT_NUMBER ACCOUNT_NUMBER ACCOUNT_NUMBER GUID PAT_NAME DATEOFBIRTH MAR_DESCRIPTION PAT_ID CLIENTGUID ADDR1 PAT_ENC_CSN_ID ORDER_ID ORDER_PROC_ID ADMITDTM CONTACT_DATE ADDR2 DISPLAY_NAME CHILD_ORD_PROC_ID DISCHARGDTM CITY INPATIENT_DATA_ID START_DATE ORDERING_DATE TYPECODE Observations STATE ADMIT_DTM END_DATE ORDER_TIME VISITIDCODE DISCHARGE_DTM ZIP ORDER_START_TIME PROC_CODE SERVICEGUID PID PCP_ID ED_DEPARTURE_DTM ORDER_END_TIME ORDER_CLASS HDID TRIAGE_STATUS STATUS TAKEN_TIME COSIGNED_USER_ID Patient OBSDATE LANGUAGE HOSP_ADMSN_TYPE SIG PROC_ID OBSVALUE APPT_STATUS INFUSION_RATE STANDING_PRDER PAT_MRN_ID SDID ENCOUNTER_TYPE TASK_STATUS PAT_UD STANDING_OCCURS CHANGE_DATE REGISTRATION_STAT DOSE_UNIT PAT_NAME STAND_INTERVAL OBS_TYPE DISCH_DISPO Visits SDK Appointments MEDICATION_DOSE BIRTH_DATE INSTANTIATED_TIME DESCRIPTION HEIGHT MEDICATION_FREQ SEX RANGE MRN ID WEIGHT PAT_FIRST_NAME STATE ACCOUNT_NUMB DTM SMOKING _STATUS PAT_LAST_NAME USRID ER STATUS PAT_MIDDLE_NAME ClientVisitLocation STATE ADMIT_DTM SCHED_PROV ADD_LINE_1 DISCH_DTM DEPARTMENT ADD_LINE_2 GUID PCP_CODE LOCATION Results CITY CLIENTVISITGUID SERVICE_AREA CANCEL DT STATE CLIENTGUID ORDER_PROC_ID LOCATION_CODE RESECHED DT Problems ZIP TRANSFERREQUESTDTM PROC_ID COMPLAINT COMMENTS HOME_PHONE LOCATIONGUID LINE PROBLEM_LIST_ID CHARGES WHEN SCHED WORK_PHONE CREATEDWHEN PAT_ID DX1…DX100 PAT_ID DURATION LANGUAGE SERV_AREA_ID BALANCE REASON DX_ID ETHNICITY COMPONENT_NAME DISCH_STATUS ICD9_CODE MARITAL_STATUS RESULT_TEXT NOTE_DATE RACE RESULT_NUM PROBLEM_STATUS SPECIMN_TAKEN_TIME CLASS_OF_PROBLEM Surgery IBEX visits RESULT_FLAG_TXT PROBLEM_CMT Patient SDK MEDREC RESULT_DATE PRIORITY CASE_ID Problems COMPLAINT COMPONENT_ID RESOLVED_DATE MRN SCHED_SURGERY_DT ID ORDER_TIME CHRONIC_YN GENDER CASE_SCHED_STATUS PID ACUITY PRINCIPAL_PL_YN DOB CANCEL_REASON CODE ADMIT_DATE_TIME Documents HOSPITAL_PL_YN ADDR CANCEL_DATE DESCRIPTION EXIT DATE IS_PRESENT_ON_ADM SURGERY_DATE CITY QUALIFIER SDID DISCH STATUS STATE ACCOUNT_NUMBER START_DATE LNAME PID Observations ZIP PAT_ID STOP_DATE SUMMARY FNAME RACE1 PAT_MRN STOP_REASON ITEMNAME DOC_TYPE DOB RACE2 RESULT_FLAG_TXT CHANGE_DATE CLIENTGUID GENDER USR_ID RESULT_DATE RACE3 ANNOTATE CLIENTVISITGUI LOCATION_OF_CARE ACCTNUM ETHNICITY1 COMPONENT_ID USED_ID D CHANGE_DATE ETHNICITY2 PNL_1_PRIM_PROC_NM_ ENTRY_DTM VALUE PUBUSER PATIENT_NAME WID SIGNED_DTM GUID PUBTIME STATUS ORDER_GUID JOBTITLE CLINICALDATE
FAQs Where do I start?
FAQs Where do I start? Start with a research question (or two).
FAQs Where do I start? Start with a research question (or two). Get cohort size to see if pursuing an IRB protocol is worthwhile.
FAQs Where do I start? Start with a research question (or two). Get cohort size to see if pursuing an IRB protocol is worthwhile. What kind of data IRB or Not? Counts De-identified Data Identified Data Do you need subjective data? Is your research dependent on highly textual data?
Regulatory Issues Permission is the same as for accessing other databases, • individual paper records or electronic files IRB approval for anything other than counts • Researcher must be part of the covered entity • Researchers must complete Human Subjects Research training •
What type of Data do you need? Data Counts: Fill out online data request. • Anonymous Data: • IRB exempt application and relevant HIPAA forms Identifiable Data: • IRB Expedited/Full Board Application and relevant HIPAA forms
Applying to Use the data in the Clinical Data Warehouse Am I doing human subjects research? • Do I need to have data that identifies patients? • Will I need to return to find additional information after a data • set is created? Does my data request restrict a count to a very small number? •
FAQs Where do I start? What do you need from me to process my data request?
FAQs Where do I start? What do you need from me to process my data request? What can I do to make the process easier?
FAQs Where do I start? What do you need from me to process my data request? What can I do to make the process easier? What does it mean to query a database?
How do you query data? Contrary to popular belief, there is no magic button. Computers don’t spit out info. Software is needed. Data is often text information even if it looks like a number. Each single piece of data requested may require more than one query, but some can be retrieved in bulk queries. How many ways can info be represented? Data often needs to be cleaned or transformed. Access to the Clinical Data Warehouse is restricted. SQL is the database software structured query language. Each researcher’s set queries is unique.
FAQs Where do I start? What do you need from me to process my data request? What can I do to make the process easier? How will I get the data?
FAQs Where do I start? What do you need from me to process my data request? What can I do to make the process easier? How will I get the data? Password protected Excel file(s) sent via secure email or via Box.com
FAQs Where do I start? What do you need from me to process my data request? What can I do to make the process easier? How will I get the data? How should I send data (to merge) to you?
FAQs Where do I start? What do you need from me to process my data request? What can I do to make the process easier? How will I get the data? How should I send data (to merge) to you? Use secure email when sending any protected health info or private info
FAQs Where do I start? What do you need from me to process my data request? What can I do to make the process easier? How will I get the data? How should I send data (to merge) to you? Can I send a list of patients for whom I need lab data, demographics, comorbidities, address info?
FAQs Where do I start? What do you need from me to process my data request? What can I do to make the process easier? How will I get the data? How should I send data (to merge) to you? Can I send a list of patients for whom I need lab data, demographics, comorbidities, address info? Use secure email when sending the list
FAQs Where do I start? What do you need from me to process my data request? What can I do to make the process easier? How will I get the data? How should I send data (to merge) to you? Can I send a list of patients for whom I need lab data, demographics, comorbidities, address info? I’m not an Excel wizard, can you help me through issues?
Recommend
More recommend