Overview

The Data Exporter functionality enables an i2b2 user to request patient data for the patients found by a desired patient set query. The request is then processed by Manager role usequery. In the configured workflow, data is requested and generated through new breakdown types that can be selected in the Run Query dialog. Users will see "data request" breakdowns, which send an e-mail to a predefined data manager requesting a type of data. The data manager (Manager user role) processes the request by rerunning the query with a special "data export" breakdown. The patient data is exported as a file and stored in a specified location for retrieval.

The patient datasetdata export types, request options, and file specifications are configured in the database using specific request type entries and configuration parameters in the database.

Image Modified

Data Export Workflow

Image Added

Request/Export Process

• End user logs into webclient and creates a patientset query

• Selects a Data Request option and

• Click run Query

Image Added

• Email is sent to manager user to run the user request

• The manager logs into the webclient and finds the run query by matching the query master id

• Manager user then re-runs the previous query and clicks on export.  The export option is displayed selected in the Data export breakdown.

Image Added

• Data export runs in the background and file is generated in the folder specified in the HIVE_CELL_PARAM

• Manger user manually sends a confirmation email to the user on the file generation and retrieval info.

Image Added

Data Export Configuration

Design and Architecture

The existing i2b2 breakdown architecture is modified to display breakdowns for the request/Export Options display in the run query dialog corresponding to the entries in the QT_RESULT_TYPE table

...

include a new breakdown class for the file export process

Request/Export Process

• End user logs into webclient and creates a patientset query

• Selects a Data Request option and

• Click run Query

• Email is sent to manager user to run the user request

• The manager logs into the webclient and finds the run query by matching the query master id

• Manager user then re-runs the previous query and clicks on export.  The export option is displayed selected in the Data export breakdown.

• Data export runs in the background and file is generated in the folder specified in the HIVE_CELL_PARAM

• Manger user manually sends a confirmation email to the user on the file generation and retrieval info.

Process flow chart

Image Removed

Web client display for End User

Image Removed

Web client display for Manager user

Image Removed

Example Export files

Demographics

...

Sample Letter generated for Data Manager

Image Removed