Data Management & Extraction Consultation

We offer data expertise in three areas:

Request Clinical Data for Research

Select the Data Extraction option in your consultation request. A consultant will help you define a data specification, coordinate the request process, and estimate time required (initial hour is free).

Data Management Services

  • Data cleaning & formatting
  • General management advice
  • Choosing platform
  • Querying existing database
  • REDCap database advice
  • Grant preparation
  • Merging datasets
  • Other data management issues

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

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

Explore APeX Data Codes

Use the APeX Pick List (Excel 26MB) tool to prepare for your UCSF Medical Record 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

Login to request consultation UCSFnon-UCSF