...

The patient dataset, request options and file specifications are configured in the database using specific request type entries and XML files with embedded SQL select statements and other configuration parameters in the database

Design and Architecture

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

The QT_BREAKDOWN_PATH table has XML file entries with embedded SQL statements for each Request type. and file content generation 

Export File generation parameters are configurable 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

Request Scenario

...