it.ucsf.edu

Announcing the Availability of STOR Data Warehouse

Jill Myers's picture


Historical EHR Data Loaded into the UCSF CDW

Beginning February 1, 2018, the STOR Data Warehouse is available for research use. Almost all data from UCSF’s legacy EHR (STOR) will be accessible through the Clinical Data Research Consultations (CDRC) data consulting process. Patient data starts around 1988 and includes structured data and clinical notes. Prior to this, most patient data for research was only available from APeX.

STOR was the primary Electronic Health Record for UCSF between 1988 and 2005 and was used by many providers between 2005 and the APeX Go-Live on 6/1/2012. STOR was one of the first electronic health record systems in the United States. As a result, it provides an invaluable longitudinal history of a patient's disease spanning up to 40 years, when combined with APeX data.

STOR is a rich source of patient information for research. STOR was designed by and for physicians so it focuses on capturing the most relevant patient information to guide clinical decision making. Full-text clinical notes were dictated by STOR providers and later transcribed into the system by support staff. Problems were coded by providers in a hierarchical form that could be specific to each department.

In addition, STOR captured and saved, through HL7 feeds, clinical information originating from other UCSF including visits from IDX, lab results, procedure codes from billing, and SNOMED codes from Pathology.

The data structure of the STOR-specific Data Warehouse tables is shown below: 

 

In addition, STOR data that conforms to the structure of the Epic Caboodle data warehouse will be merged into the Epic tables, providing individual tables that show a patient history spanning the time before and after the APeX Go-live. In the figure below, the new STOR data is indicated in blue, and the original APeX data is in orange:

Where needed, STOR-only clinical codes will also be merged with the existing APeX codes:

 

Date Ranges for STOR Patient Observations by Fact Table (excluding small year counts)

Table Name

First Year

Last Year

StorImmunizationFactX

1976

2011

StorLabFactX

1980

2012

StorMedicationListDetailFactX

1980

2012

StorProblemListDetailFactX and StorProblemListFactX

1980

2012

StorProcedureFactX

1999

2012

StorReportFactX,

1971

2012

StorReportFieldFactX

1977

2012

StorReportMicroResultFactX

1993

2012

StorReportMicroTestFactX

1993

2012

StorReportSnomedFactX

1982

2011

StorReportTextFactX

1983

2012

StorVisitFactX

1971

2012

 

How to Access Data from the STOR Data Warehouse

Around June 2018, the STOR data merged into the Epic Caboodle tables will be available, in deidentified form, for direct access by investigators through the Deidentified Clinical Data Warehouse.

Until that time and beyond that time (for the STOR-specific tables), the data contains PHI, and can be extracted for you by submitting data requests to CTSI and ARS, using the following request forms:

https://data.ucsf.edu/
-> https://data.ucsf.edu/data-assets/clinical-research
-> http://accelerate.ucsf.edu/consult/data
-> https://accelerate.ucsf.edu/research/data-consult