Clinical Data Research Consultations

Service Description

Clinical Data Research Consultations is a service that extracts data sets from UCSF Medical Center and San Francisco General Hospital (SFGH) hospital data sources for research purposes. The available SFGH data sets include longitudinal data from clinical databases on Community Health Network (CHN) patients from SFGH and other DPH facilities. The available UCSF Medical Center data sets include longitudinal patient data sets from the APeX and UCare clinical systems.  Typical uses of Clinical Data Research Consultations data include:

  • Summary statistics.
  • Generation of condition-specific patient populations for study recruitment / chart review.
  • Outcomes research using historical data in hospital databases.

Additional Features and Functions

The Clinical Data Research Consultations service includes the two primary service offerings of data extractions and the honest broker service provider.

Data Extractions – The data extraction service offering includes the extraction of de-identified, aggregate, and identified patient data sets from UCSF Medical Center and San Francisco General Hospital data sources. A current and relevant CHR protocol is required for all identified data extractions. The extracted data sets are delivered to you through your MyResearch account. This service offering includes both one-time and recurring data pulls.

Honest Broker – The honest broker service offering includes the de-identification of extracted patient data sets. All identifying information is removed from a data set and retained by the ARS team for future use by your research team under the auspices of your current and relevant CHR protocol. A proxy medical record number is generated and attached to each patient record in your data set. ARS then maintains a mapping between the proxy medical record number and the real medical record number for all patient records in your data set. This enables ARS to re-identify the patient records for your research team when the need to do so may arise in the future stages of your study. The deliverable that you will receive in your MyResearch account as a result of the initial honest broker service request is the de-identified patient data set that includes the proxy medical record numbers.

Request a Clinical Data Research Consultation

Please complete the CTSI Consulting Services Request form.

Learn More about the CDRC service


Research data extraction and REDCap development consulting services are provided to the UCSF Research Community at the hourly rate of $120/hour, with the first 8 hours of service free of charge for each Principal Investigator each fiscal year.


This service is available during regular business hours: M – F, 8 a.m. – 5 p.m.


For additional Clinical Data Research Consultations support questions and information, contact the Academic Research Systems team at [email protected].

Policy Information

University of California Electronic Communications Policy (ECP)