Clinical Data Research Consultations (formerly THREDS and IDR Data Extraction Service)

Rhett Hillary's picture

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: 1) Summary statistics; 2) Generation of condition-specific patient populations for study recruitment / chart review; 3) 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 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 reoccurring 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. A mapping is then maintained by ARS 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.

How to Request a Clinical Data Research Consultation

Please complete the CTSI Consulting Services Request form.


Effective October 1, 2014, the first eight hours of consulting services received by an investigator each fiscal year are complimentary. Consulting services beyond the initial eight hours will be billed at a rate of $106/hour.


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

Getting Help

For additional Clinical Data Research Consultations support questions and information, contact the Academic Research Systems team at [email protected] or visit the Clinical Data Research Consultation page on the MyResearch site.

Policy Information

University of California Electronic Communications Policy (ECP)

Migration Status