...

The i2b2 breakdown architecture has been modified to support new breakdown types for data request and export. These display in the run query dialog corresponding to the entries in the QT_RESULT_TYPE table. When a manager user exports user request option, an export file is generated based on the entries in QT_BREAKDOWN_PATH table. Email notification sent to the manager is also based on the entries in the QT_BREAKDOWN_PATH table. The generated file is formatted as per the entries in HIVE_CELL_PARAMS. 

Database changes

Currently QT_BREAKDOWN_PATH .value column has datatype of varchar(2000). Inorder to support the XML  structure needed for the Data Exporter, the value column has been modified to CLOB datatype. 

Image Added

Configuring Database Parameters

...