what is a database a collection of information organized
play

What is a Database? A collection of information organized to - PowerPoint PPT Presentation

The Boston Medical Center Clinical Data Warehouse lots of answers whats the question? Linda Rosen, MSEE Clinical Data Warehouse Research Manager What is a Database? A collection of information organized to provide efficient


  1. The Boston Medical Center Clinical Data Warehouse …lots of answers … what’s the question? Linda Rosen, MSEE Clinical Data Warehouse Research Manager

  2. What is a Database? A collection of information organized to provide efficient retrieval.

  3. 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.

  4. 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. •

  5. BMC Clinical Data Warehouse IBEX * SDK Daily/ Weekly SCM * EWS Daily PICIS * EPIC Clarity CDW Daily Logician * Tumor Registry CHCs Weekly Static

  6. 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?

  7. 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 •

  8. 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

  9. FAQs Where do I start? 

  10. FAQs Where do I start?  Start with a research question (or two).

  11. FAQs Where do I start?  Start with a research question (or two). Get cohort size to see if pursuing an IRB protocol is worthwhile.

  12. 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?

  13. 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 •

  14. 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

  15. 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? •

  16. FAQs Where do I start?  What do you need from me to process my data request? 

  17. 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? 

  18. 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? 

  19. 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. 

  20. 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? 

  21. 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 

  22. 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? 

  23. 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 

  24. 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?

  25. 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 

  26. 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