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
