Familial, Associational, & Incidental Relationships (FAIR) Initiative.
Space shortcuts
Space Tools
Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 3 Next »

About the FAIR DB Administrator's Toolset

Introduction

Part of the FAIR Initiative is to make it as easy as possible for a DB administrator (DBA) to insert or update the FAIR data for each patient into the i2b2 DB, after all the tedious upfront works has been done in compiling them.

The FAIR DBA Toolset consists of the following utilities:

  • PL/SQL scripts containing useful procedures to be stored and used in the i2b2 DB
    1. FAIRupdate.sql – contains the FAIRupdate( ) procedure.
    2. FAIRshow.sql – contains the FAIRshow( ) procedure.
  • VBS scripts for generating PL/SQL scripts to call the aforementioned stored procedures to update and show the FAIR XML for specified patients in the i2b2 DB
    1. FAIRxls2sqls.vbs – takes an XLS input file that contains the patient FAIR data.
    2. FAIRcsv2sqls.vbs - takes a CSV input file that contains the patient FAIR data.

Instructions

  1. Navigate to the "Specify Data" tab; then, drag and drop a desired Patient Set and one or more Concepts onto the input boxes provided.
  2. Click the "Select Subjects" tab to view the patients and their FAIR members.
  3. Select appropriate subjects for tracing the selected Concepts ("concept_cd") in the "related" individuals.
  4. Click the "View Results" tab to view the tabulated results.
  5. Optionally click the appropriate button to export the tabulated data into an Excel spreadsheet file and / or a CSV file conveniently.
  6. Optionally repeat steps 3-4 (or 3-5) to select different subjects and FAIRs for additional / different Concept tracing.

Caveats

N/A.

Browser Compatibilities

  • This plugin works on the following browsers: Firefox (v.4.0.1), Chrome (v.19.0), Safari (v.5.0.5), and Internet Explorer (v.8.0 & v.9.0.1).
  • The i2b2 Web client itself does not work on the following browser: Opera (v.11.50).

i2b2 Version Compatibilities

This version (v.1.0) of this plugin is developed on i2b2 v.1.6.0.2.

Version History

1.0

Inital release, for i2b2 v1.6.0.2.

(Q4 2012)

 

 

 

Availability

This plugin is free to the rest of the i2b2 community. It can be downloaded from the University of Massachusetts Medical School MICARD website for i2b2 related downloads. 

Terms of Use

This plugin is published under the GNU GPL v3 license. 

This software is distributed as a plugin to the i2b2 v1.6 webclient framework, and may be used free of charge. It is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.

About Us

This plugin was created by S. Wayne Chan, Tom English, Rajani Sadasivam, Thomas Houston, & the Bio-Medical Informatics (BMI) Core Team, University of Massachusetts Medical School, Worcester, MA.

Copyright 2012 University of Massachusetts Medical School. 

Acknowledgement

This plugin leveraged off the following:

  • the general construct / format /style / template used in the i2b2 web client plugin examples by N. Benik & G. Weber.
  • the XLS export feature of the ExportXLS plugin by M. Bucalo, Universita' di Pavia.
  • No labels