...

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

Design and Architecture

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

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

...

Flow chart

Display for End User

Image RemovedImage Added

Display for Manager user

Image RemovedImage Added

Request Scenario

• 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.

...

Updating Database Configuration

...

Entry into HIVE_CELL_PARAMS

File parameter specification entries

Image Added

Image Added

Variables for File

...

name entries 

 Image Added

Image Added

Entry into QT_BREAKDOWN_PATH

...