Overview

Data Exporter functionality enables an i2b2 user to request patient data for a desired patient set query. The request is then processed by Manager role use. The patient data is exported as a file and stored in a specified location for retrieval.

The patient dataset, request options and file specifications are configured in the database using SQL select statements and parameters in HIVE_CELL_PARMS

Design and Architecture

The existing i2b2 breakdown architecture is modified to display additonal breakdowns for the show up in the run query dialog corresponding to the SQL statement entries in the HIVE_CELL_PARAMS

Java Changes include a new breakdown class for the file export process.

File format parameters are configurable in the HIVE_CELL_PARAMS

Flow chart

Display for End User

Request Scenario

Updating Database Configuration

Entry into HIVE_CELL_PARAMS

Variables for File names

Entry into QT_BREAKDOWN_PATH

Entry into QT_RESULT_TTPE

Example SQL statement entries

Demographics

Diagnosis

Labs

Procedures

Patient_Mapping