Data Extraction Office of Informatics

Providing research investigators data resources through the Translational Data Warehouse (TDW) and WakeOne system.

Mission

The Informatics Program supports biomedical and clinical informatics needs of WF investigators by providing expert guidance, informatics tools, programming support, and management of WF’s Translational Data Warehouse. The Informatics Program will increase the use of electronic health record (EHR) data for clinical and translational research and maximize the impact of research on health through an integrated CTSA informatics network.

Open Consultation Hours

Have questions about data requests or resources such as i2b2, ACT, TriNetX, etc?

Join us during our open consultation hours or contact us to schedule a meeting.

Mondays

10-11 am

Monday
WebEx

Thursdays

1-2 pm

Thursday
WebEx

Request Consultation

All open office hours held virtually via WebEx.

See standing WebEx links above or search Informatics on events page to add specific dates to your calendar.

i2b2 Training Hours

Each 1-hour training session will cover how to access and use basic and advanced
features of i2b2, including obtaining feasibility numbers and pulling patient data (with appropriate approval).

First Fridays

10-11 am

Friday
WebEx

Third Thursdays

3-4 pm

Thursday
WebEx

Please contact us at

ctsidata@wakehealth.edu
with questions or for more information.

All i2b2 training sessions held virtually via WebEx.
See standing WebEx links above or search the CTSI Calendar to add specific date to your calendar.

Translational Data Warehouse (TDW)

The Translational Data Warehouse (TDW) is a comprehensive research data warehouse integrating clinical data from our WakeOne system and other research information from multiple data sources. Currently the TDW consists of clinical data which includes demographics, diagnoses, procedures, medications, lab results, vitals, and visit details from the medical record (historical and current).

Data can be used for retrospective chart reviews and analysis, identify patients for recruitment, or to pull aggregate numbers for cohort identification and build projected enrollment tables.

Program Spotlight

View the Informatics Program one-sheet summary!

Download PDF

Self-Service Model

The i2b2 platform is a query tool that allows investigators to query clinical data in the Translational Data Warehouse for cohort identification and pull detailed data for research projects. Medical Center users can automatically log in to i2b2 with valid CITI certification. Use of i2b2, as well as training on i2b2 or the Data Puller tool, is available at no cost.

View our Quick Tutorial Videos or Learn more about CITI certification/training

i2b2	SKAN
Prior to IRB approval, i2b2 can be used to pull aggregate numbers and enrollment tables based on inclusion and exclusion criteria. For IRB-approved studies, the Data Puller tool within i2b2 can be used to select and receive data elements based on HIPAA Waiver criteria approved in your IRB application. Log in to i2b2	The SKAN (Search Kibana Accessible Notes) NLP (Natural Language Processing) system can be used to pull aggregate numbers based on inclusion and exclusion of content in clinical notes. Log in to SKAN

i2b2

SKAN

Prior to IRB approval, i2b2 can be used to pull aggregate numbers and enrollment tables based on inclusion and exclusion criteria. For IRB-approved studies, the Data Puller tool within i2b2 can be used to select and receive data elements based on HIPAA Waiver criteria approved in your IRB application.

Log in to i2b2

The SKAN (Search Kibana Accessible Notes) NLP (Natural Language Processing) system can be used to pull aggregate numbers based on inclusion and exclusion of content in clinical notes.

Log in to SKAN

Frequently Asked Questions

How can I find out what data/information is available to me?

There’s general information on our Translational Data Warehouse above and more specifics on it here. You can also browse the ontologies in i2b2. But the best way to get to know what data is available to you is to attend one of our open consultation hours (Mondays 10-11am and Thursdays 1-2pm) or to consult directly with our team.

What does it cost to request data? How long does it take to receive the data?

Our self-service tools, i2b2, the DataPuller, and SKAN NLP are available at no cost and data is returned within minutes
Most simple requests for data extraction can be completed at no cost within two weeks of finalizing the details of the request
For complex/larger requests for data extraction our team will provide a cost and time estimate to you for review before beginning work on the request. To receive an estimate prior to submitting your request email ctsidata@wakehealth.edu

How can I get help with i2b2?

Virtual i2b2 trainings are available First Fridays10-11am and Third Thursdays 3-4pm
You can attend one of our open consultation hours, available Mondays 10-11amand Thursdays 1-2pmto ask questions on i2b2
Written instructions available here
Training videos available here
You can always contact the Office of Informatics directly at ctsidata@wakehealth.eduto schedule a 1-on-1 training with a member of our staff

I’m not even sure where to start, help?

You can attend one of our open consultation hours, available Mondays 10-11am and Thursdays 1-2pm or contact the Office of Informatics directly at ctsidata@wakehealth.edu. Our team will meet with you individually to orient you to our data and services, and consult with you on your project/research interest.

How can I share this information with my colleagues?

The Office of Informatics is available to present to your colleagues/group/department. We also have an email summarizing our services that can be distributed to listservs. Contact ctsidata@wakehealth.eduto learn more.

Data Extraction Services

If you are unable to complete your request utilizing our self-service tools or have a more complex data pull, you can submit a Data Extraction request through our CTSI Service Request Form. Initial consultations on data needs and data requests for simple queries and/or data pulls are available at no cost.

To help us fulfill your request in a timely manner, here are some tips on how to submit a high quality data request.

Advanced consultations and complex queries and/or data pulls (generally > 2 hours of work) are available for direct FTE support or utilizing the following CTSI's Fee-for-Service rates. Service lines typically billed are Data Coordinator and Data/Informatics Programming.

Please refer to the CTSI Hourly Services Pricing Grid.

Data Networks


The ACT Network is a real-time, open-access platform allowing researchers throughout the CTSA consortium to explore and validate feasibility for clinical studies using electronic health record data. ACT is an NIH-funded and HIPAA-compliant federated network with data contributed from over 50 CTSA hubs. — Explore patient populations in depth, in real time, from their desktop. — Confirm study feasibility by iteratively testing and refining inclusion and exclusion criteria. — Demonstrate study feasibility in funding proposals and IRB submissions. — Identify potential partners for multi-site studies by searching for patients across the CTSA network.	The N3C is a partnership among the NCATS-supported Clinical and Translational Science Awards (CTSA) Program hubs and the National Center for Data to Health (CD2H) with overall stewardship by NCATS. Collaborators will contribute and use COVID-19 clinical data and EHR data on COVID-19 patients to answer critical research questions to address the pandemic. Researchers are now able to request access to the N3C Data Enclave, a centralized national COVID-19 data analytics platform to enable collaboration on the rapid collection and analysis of clinical, laboratory and diagnostic data.
Access ACT Now	Access N3C Now

The STAR CRN (formerly known as the Mid-South CDRN) encompasses eight health systems: Vanderbilt VUMC, Vanderbilt VHAN, Meharry, Duke, UNC, Wake Forest, Health Sciences of SC and Mayo Clinic. With data on over 12 million patients, the STAR CRN network consists of academic health centers, community hospitals and a range of outpatient practices including primary care, specialty practices and safety net facilities that serve diverse populations. STAR is particularly focused on research to improve health in the southern US which has the highest rates of obesity, diabetes, cardiovascular disease, certain cancers, and other conditions, as well as significant disparities in health status and health care delivery. Through this network and other PCORnet CDRNs, we have access to a broad array of clinical data, informatics tools, patients, providers, and systems to address an array of research questions.	TriNetX is a global health research network that connects the world of drug discovery and development from pharmaceutical company to study site, and investigator to patient by sharing real-world data to make clinical and observational research easier and more efficient. Though the primary usage of TriNetX is to allow potential clinical trial opportunities determine availability of cohorts at Wake Forest, researchers are able to query our local data on the TriNetX network and utilize their built-in analytics tools for aggregate counts.
Access STAR Now	Contact Us to Access TriNetX

Data Security

Interested in learning more about data requirements?

Download our security overview sheets.

Regulatory

Quick Links

Sponsored Research