Data Management & Extraction Consultation

Data Management & Extraction Consultation provides help with:

  • Data extraction services - see below to prepare for your request
  • Data cleaning & formatting
  • General management advice
  • Choosing platform
  • Querying existing database
  • REDCap database advice
  • Grant preparation
  • Merging datasets
  • Comparative Effectiveness Large Dataset Analysis - see below for details
  • Other data management issues

Clinical Data for Research: Summary for Five Common Scenarios

ScenarioSelf-serve (Free)Consult Required (may have recharge)IRB neededRequires MyResearch account or other secure environmentIncludes clinical notesUC Health data available in addition to UCSF data
CountsYesNoNoNoNoYes   
De-ided dataYesNoNoNoNoYes *
Limited dataNoYesYesYesNoYes *
Id’ed dataNoYesYesYesYesYes *
RecruitmentNoYesYesYesNoYes *

* Process to obtain data from UC Health sites can be very lengthy

Data Extraction from UCSF Medical Records:

Use the APeX Pick List (Excel 26MB) tool to prepare for your extraction request. Explore the most commonly used data codes to help define variables needed for your research and to define your cohort.

  • Diagnoses
  • Meds
  • Labs
  • Procedures
  • Flowsheet
  • Departments
  • Smart Data Elements

Comparative Effectiveness Large Dataset Analysis:

  • Study design/conceptualization
  • Addressing common methodological issues in analysis of observational data
  • Data dataset selection
  • Dataset acquisition
  • Administrative support
  • Dataset uploading and downloading
  • Query design and cohort selection
  • Dataset cleaning
  • Dataset linking
  • Programming support
  • Collaboration, building collaborative relationships for data sharing

Login to request consultation UCSFnon-UCSF