COVID-19 (Novel Coronavirus): Please click here for FAQs: Impact of COVID-19 on Human Subjects Research

Using BMC and CHC data for research purposes

Clinical Data Access for Researchers

The Clinical Data Warehouse.

In late 2005, Boston Medical Center embarked on a new project to bring data at the hospital into a single relational data warehouse. This means that clinical researchers who have IRB/HIPAA approval can, with the help of a database developer:

  • get data with a single query (rather than searching manually)
  • cross-reference data from EPIC, Logician, SDK, SCM, OR and ED
  • get simple patient counts defined by some user specified criteria
  • relate local data with BMC data
  • search text files (physician notes, pathology reports, etc.) for keywords
  • and more, depending on the researcher’s needs

Getting Started

For an overview of the Clinical Data Warehouse, click here.

If your protocol has been approved by HIPAA and/or the IRB, then click here to access the data request form. Note that there is a charge for accessing the Data Warehouse for research purposes. To find out more about charges, click here. E-mail the Clinical Data Warehouse Research Team, Linda Rosen or Melissa Hofman with questions or a meeting request to discuss your particular data needs.

Available Data:

EPIC [start date: Inpatient and ED start 05/23/2014; Outpatient start 05/06/2015 ]

  • Patient encounter data
  • Patient and Provider contact information
  • Diagnoses (ICD-9/10 codes) related to a visit
  • Procedure info
  • Laboratory data
  • Order data
  • Surgery info
  • Imaging info
  • Admission and Discharge date/time
  • Department Information
  • CHC data (with additional approvals)

Tumor Registry [start date: mid 1980’s ]

  • Patient Information
  • Tumor Site
  • Stage
  • Date of Initial Diagnosis

Legacy Data:

SDK – Registration [start date: 10/2003]

  • Patient demographics
  • Patient and Provider contact data
  • Diagnoses (ICD-9 codes) related to a visit
  • Procedure info (CPT codes) related to a visit
  • Admission and Discharge date/time
  • Service Area Information
  • ER Admission and Discharge date/time
  • Insurance Information
  • Visit Charges

Logician – Outpatient data [start date: 1999]

  • Patient contact information
  • Appointment Information
  • Observation Data – template info
  • Problem List items
  • Orders – referrals and tests
  • Laboratory Results
  • Pathology Reports
  • Physician Notes
  • Radiology (text format)
  • Allergy Information
  • Medication Information
  • Flags

SCM – Inpatient data [start date: 2001]

  • Patient Information
  • Visit Information
  • Lab Values
  • Orders
  • Documents
  • Allergy/Allergen Information

PICIS – Operating Room [start date: 03/2004]

  • Patient Demographic Information
  • Surgery Booking Information
  • Case Record data
  • Surgery Procedure Information

IBEX – Emergency Dept [start date: 11/2004]

  • Admit and Discharge Dates
  • Length of Stay
  • Transaction Data

EWS – Appointment Information

  • Date/Time of Appointment
  • Appointment Status
  • Appointment Location


The CDW Team can assist researchers in the development of identified/de-identified datasets, recurring reports, web access to formatted queries and other datasets.

Contact Linda Rosen  or Melissa Hofman with questions.

Data Security: Protected health information must be stored on a secure device–on a BMC or BU Medical Campus network drive, a password protected computer or on an encrypted peripheral device that is stored in a secured cabinet or office. Only the investigators approved by the IRB for the protocol may have access to the information. No protected health information shall be removed from BMC or the  BU Medical Campus. Identifiers should be destroyed when they are no longer required for the study. As soon as the investigator(s) have completed the study, the file/files should be destroyed.

The protected health information may not be re-used or disclosed to any other person or entity, except as required by law, for the authorized oversight of the research study, or for other research for which the use or disclosure of protected health information would be permitted by the Privacy Regulation 45CFR 164.512.