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

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

 Sample Letter generated for Data Manager