Office of Informatics Specializing in Data Extraction and Programming Services

Providing research investigators data resources through the Translational Data Warehouse and Encompass system.

Mission

The Office of Informatics supports the biomedical and clinical informatics needs of Advocate Health and Wake Forest University School of Medicine investigators by providing expert guidance, informatics tools, programming support, and management of the Translational Data Warehouse (TDW). The Office of Informatics 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.

A Message from the Director

Translational Data Warehouse (TDW)

The Translational Data Warehouse (TDW) is a comprehensive research data warehouse integrating clinical data from legacy WakeOne, legacy Cerner, and Encompass systems 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).

Visit this resource to learn more about TDW data sets, integration of EHR data from sites across the enterprise, available calculated variables, and much more.

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.

To view and work with example data sets visit our Informatics wiki. (Note: You’ll need to be signed in with your wakehealth credentials and either on the network or VPNed in or using the Citrix portal to access the Informatics wiki.)

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?

Data extraction services are available at an hourly rate or through FTE support.
Initial consultations and requests for basic/simple data pulls are subsidized by the CTSI.
Most simple data requests can be completed in two weeks or less.
Larger, more complex requests may take longer than two weeks. Our team can provide an estimate of how long based on the size and complexity of request, and on the current volume of work in the data request queue.

How can I get help with i2b2?

Virtual i2b2 trainings are available First Fridays10-11am and Third Thursdays3-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.

Resources

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, pulling counts for NIH Enrollment Tables and pulling row level patient data (with IRB 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.

Testimonials

“The CTSI Informatics staff were amazing! They went above and beyond to assist me with i2b2 so I could have additional fields appended to my data. Your team is responsive and goes above and beyond. I’m thrilled to know we will be working with such a competent and invested team!”

- Clara Schommer, CCRP, Project Manager, Neurosciences Institute, Neurology - Charlotte

“I appreciate CTSI so much! They do an amazing job. I very much value all their help on multiple projects throughout my residency. They are always friendly, timely, and do a great job. I love working with y’all.”

- Bryanna Vesely DPM, MPH, Former Resident PGYIII, Podiatry – Orthopedic Department

“The CTSI Informatics staff were tremendously helpful in not only looking over my query to ensure it was appropriate for the IRB protocol submitted, but in retrieving old queries that had been deleted but were still needed thus saving hours of work. Two thumbs up!! 5/5!! Gold stars all around!!”

- Erica Anderson, PharmD, BCPS, Internal Medicine Pharmacist, Department of Pharmacy

The SUPERHERO Project: A Collaboration with the Office of Informatics

In this video, Dr. Andrew South, MD, associate professor of pediatric nephrology, discusses his ongoing SUPERHERO project and the valuable support from the Office of Informatics in improving patient care. Tune in to learn how this collaboration is making a difference in pediatric healthcare.

Self Service Tools

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 quick tutorial videos here, read written instructions here, and learn more about CITI certification/training here.

i2b2

The i2b2 platform is a query tool that allows investigators to query clinical data in the Translational Data Warehouse. Prior to IRB approval, i2b2 can be used to pull aggregate numbers and enrollment tables based on inclusion and exclusion criteria. Users can log in to i2b2 with their wakehealth.edu username and up-to-date CITI certification. Use of i2b2, as well as training, is available at no cost. View quick tutorial videos here, read written instructions here, and learn more about CITI certification/training here.

DataPuller

For IRB-approved studies, the DataPuller tool (accessible using the “Pull Data” link within i2b2) can be used to select and receive row level data elements based on HIPAA Waiver criteria approved in the IRB application. Use of the DataPuller, as well as training, is available at no cost. View quick tutorial videos here, read written instructions here, or attend an i2b2 training session to learn more.

Learn More

Clinic and Patient Feasibility Dashboard

The Atrium Health Clinic and Patient Feasibility Dashboard is a collaborative project led by the Informatics and Analytics group in the Department of Internal Medicine and the Center for Health System Sciences (CHASSIS). The dashboard complements tools such as i2b2, providing current, granular data (including filterable data on demographics and chronic conditions) to facilitate the planning of research and implementation initiatives across the Atrium Health Southeast Market. The dashboard currently includes summary data, with the potential to stratify by market and care location, for ambulatory care locations (primary care + specialty) and emergency departments. There are plans to add similar summary data for hospital locations in 2025. To access this dashboard click on the link and request access. Requests are reviewed twice weekly.

Request Now

SKAN

SKAN allows researchers to freely search clinical notes for keyword terms in order to identify a cohort of interest. The aggregate counts and demographic breakdowns returned from a search may be used for feasibility analysis and as inclusion criteria for data requests requiring additional data elements from the EHR and other sources. Researchers may also use it to view Natural Language Processing (NLP) de-identified notes for the purposes or confirming or adjusting their search criteria. Clinical note categories currently available for text search include radiology, pathology, and progress notes.

Data Extraction Services

If you are unable to complete your request utilizing our self-service tools you can submit a request for Data Extraction through our CTSI Service Request Form.

Data extraction services are available at an hourly rate or through FTE support. For more information on CTSI’s Fee-for-Service rates see the CTSI Hourly Services Pricing Grid, service lines typically billed are Data Coordinator and Data/Informatics Programming. Please contact our team for information on FTE informatics services.

Initial consultations on data needs and requests for basic/simple data pulls are available at no cost, supported by the CTSI Informatics team.

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

For information on your data request including inclusion/exclusion criteria, data elements being pulled, and where the request is in the process of being fulfilled, visit the Data Request Dashboard. Also available on this page is an indicator of the current volume of work in the data request queue.

Data Networks

ENACT

The ENACT 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. ENACT 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.

Learn More

The N3C Data Enclave

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.

Learn More

STAR CRN

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.

Learn More

TriNetX

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.

Learn More

Data Security

For information on data requirements, you can download our security overview sheets.

Regulatory

Quick Links

Sponsored Research

Quick Links

Helpful Resources

Office of Informatics Specializing in Data Extraction and Programming Services

Mission

A Message from the Director

Translational Data Warehouse (TDW)

Frequently Asked Questions

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

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

How can I get help with i2b2?

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

How can I share this information with my colleagues?

Resources

Open Consultation Hours

Mondays

Thursdays

Request Consultation

i2b2 Training Hours

First Fridays

Third Thursdays

Please contact us at

Testimonials

The SUPERHERO Project: A Collaboration with the Office of Informatics

Self Service Tools

Data Extraction Services

Data Networks

Data Security