Accrual to Clinical Trials
Space shortcuts
Space Tools

 

 

 

Partners Founded By_horizontal_4.15_color_minsize_oldcmyk.png

 

 

 

 

 

 

 

 

ACT i2b2 Plug-Ins User Guide

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Document Version:

1.0

ACT i2b2 Plug-ins User Guide

18Dec17

 

ACT i2b2 Plug-Ins User Guide

For Version 1.0 Plugins, Document updated: December 18, 2017
Latest guides can be found at: http://community.i2b2.org/wiki/display/ACT/
 

Introduction

As part of ACT Aim 3, three i2b2 web client plugins have been developed. The plugins facilitate finding original flagged SHRINE queries from within ACT i2b2 webclient, reviewing and selecting patients based on SHRINE queries, and finally exporting a list of i2b2 numbers of selected patients of interest for clinical trials. These plugins are tools meant to assist local ACT sites to identify patient cohorts for ACT clinical trials. Version 1.0 plugins are as follows:

  1. SHRINE to i2b2 Connector
  2. Patient Set Viewer, and
  3. Patient List Exporter

At present, the ACT i2b2 plugins support two different workflows:

  1. Self-service workflow, and
  2. Concierge workflow

In the self-service workflow, it is intended that users use all 3 plugins to review the original SHRINE queries, and then select and download a list of patients of interest.

In the concierge workflow, it is intended that users will only use the SHRINE to i2b2 Connector and Patient List Exporter plugins to download the local patient list from a SHRINE query. That patient list will then be used by an institution’s local concierge service to retrieve further patient identifiers for review.

i2b2 users need the following roles to be able to use these plugins:

ACT i2b2 Plugin

Used By

Requires the i2b2 user role of:

SHRINE to i2b2 Connector

Local Site Admin

MANAGER

Patient Set Viewer

Researcher

DATA_LDS

Patient List Exporter

Researcher

DATA_LDS

 

 


Usage guidelines

Below are some guidelines to utilize ACT i2b2 plugins

 

  1. How to use “SHRINE to i2b2 Connector” plugin

This plugin displays all flagged queries that were executed on ACT SHRINE network, inside the ACT i2b2 webclient. Users will be able to view any of the SHRINE queries and run them locally in their local i2b2.

An ACT site is required to be connected to SHRINE network to use this plugin. User should create and flag a SHRINE query using their SHRINE webclient in order to proceed with the test. To create a SHRINE query, drag and drop the “Antihistamines” folder from “ACT Medications” ontology into the query tool panel of the SHRINE client.

Name it “Antihistamines Test” + [YourSite]

Example : “Antihistamines Test Partners” or “Antihistamines Test PHS” for Partners Healthcare.

Pick query topic and run the query.

Once you get back results, flag the query in the SHRINE client

 

 

 

Once the SHRINE query is flagged, log into your local ACT i2b2 webclient and proceed with the following steps:

 

 

a)      Select “Analysis Tools” from the menu bar on top right of the i2b2 webclient and load the “Shrine to i2b2 Connector” plugin. This will display all flagged SHRINE queries executed by different sites on the ACT network. Identify the SHRINE query that you just executed.

 

 

b)      View the SHRINE query in local i2b2 webclient by clicking on associated View button

 

 

 

 

 

 

 

 

 

 

c)      Run the SHRINE query and create a local ACT i2b2 query

 

 

 

 

 

 

 

 

 

 

 

d)      Drag and drop the newly created query “(SHRINE>Local)Antihistamines Test [YourSite]@Timestamp” into i2b2 webclient query panel (refining the query is optional). Rerun it with a patient set. Name the query “Antihistamines Test [YourSite] Local” (e.g.  Antihistamines Test Partners Local)

 

 

 

  1. How to use “Patient Set Viewer” Plugin

This plugin enables users to select individual patients by looking at their data in a table

a)      Load the plugin from the “Analysis Tools” tab on the menu bar

 

b)      Find the query “Antihistamines Test [YourSite] Local” in the Previous Query panel on bottom left of the query tool (e.g.  Antihistamines Test Partners Local)

 

c)      Drag and drop that query from Previous Query panel into the “Patient(s)” input box in the

“Step 1: Select Patients and Concepts to view” section of “Patient Set Viewer” plugin

 

 

d)      Check that the concepts from the dropped previous query have been populated below the “Concept(s)” input box

 

 

 

 

 

 

 

e)      Drag and drop additional concepts from the Ontology (Navigate Terms panel on top left) into the “Concept(s)” input box in the “Select Patients and Concepts to view” section (Optional)

 

 

 

f)        Change aggregation option for any of the concepts (Optional). There are multiple aggregation options available in the plugin that are listed in Table 1.1

 

 

 

 

 

g)      Click on “Step 2: Select a Workplace folder to store patients” section. Find your workplace folder displayed inside. Right click on that folder and create a new workplace folder by clicking on “New Folder” option. Name the new workplace folder as “Test_[YourSite]” (e.g. Test_Partners). This folder will be used to store selected patients

 

 

 

 

h)      Select “Test_[YourSite]” folder by clicking on it

 

 

 

 

i)        Click on the “View and select patients” section and view the patients loaded in a table

 

 

 

 

 

 

 

 

 

j)        Select any patients of interest by checking the corresponding box to the left

 

 

 

 

 

 

k)      Selected patients will appear in your workplace folder on the left side of the query tool

 

 

 

 

 

  1. How to use “Patient List Exporter” plugin

This plugin allows users to download patient identifiers either from a workplace folder or from a previous query.

To download patients from a workplace folder:

a)      Load the plugin from “Analysis Tools” menu

b)      Click on “ Select a Workplace Folder ” link

 

 

c)      Expand your workplace folder and find the workplace folder “Test_[YourSite]” (e.g. Test_Partners) that you had created earlier. Select the folder by clicking on it

 

 

 

 

 

 

d)      Download a csv file with the i2b2 numbers of the patients in the selected workplace folder by clicking on the “Download Patient List” button

 

 

 

 

 

 

 

 

 

 

 

 

 

To download patients from a previous query:

a)      Load the plugin from Analysis Tools menu

b)      Click on “ Select a Previous Query ” link

 

 

c)      Drag and drop your previous query “Antihistamines Test [YourSite] Local” from Previous Query panel on the bottom left of the webclient into the “Your Previous Query” input box of the plugin on right

 

 

d)      Click on the “Download Patient List” button to download a csv file with the i2b2 patient numbers of all patients in the patient set. Check that the patient numbers in the query patient set and the downloaded file match.

Table 1.1: Available Aggregates

Aggregation Option

Description

Existence (Yes/No)

"Yes', when a patient has at least one fact for the concept

Minimum Value

Lowest value for the concept(s) for a patient

Maximum Value

Highest value for the concept(s) for a patient

Average Value

The average of all values for the concept(s) for a patient

Median Value

The median value for the concept(s) for a patient

Date (First)

DATETIME of first instance for the concept(s) for a patient

Date (Most Recent)

DATETIME of last instance for the concept(s) for a patient

Count

Number of distinct facts for the concept(s) for a patient

List of All Values

List of ALL values for the concept(s) for a patient

Mode (Most Frequent Value)

The value that occurs most often of all values

All Concepts (Names/Text)

Listing of all DISTINCT concept names

Most Frequent Concept (Names/Text)

The concept name(s) that occurs most often

All Concepts (Codes)

Listing of all concept codes

Most Frequent Concept (Codes)

The concept code(s) that occurs most often