...

The i2b2 breakdown architecture is modified to  support  the data table definition and new breakdown types for User created data requests. The database tables have been modified to support the data table definition parameters

• RPDO_TABLE_REQUEST is updated to store table stores the default data table parameters
• HIVE_CELL_PARAMS has new parameters for global and email configurations and the data file generation location (currently on local drive)
• QT_RESULT_TYPE table has new entries for data table definition breakdown types
• QT_BREAKDOWN_PATH modified to log the data table definition  and the data export  execution details.
• QT_XML_RESULT logs XML documents containing e-mail details.  

...

In order to support the data Table design, a new table RPDO_TABLE_REQUEST is added.  The metadata in Data Table design is stored in the table when the data Table is saved.

Image RemovedImage Added

There are 4 Four patient_dimension default concepts that rows are loaded into the RPDO_TABLE_REQUEST which are required. These are: race  vital_status_cd (ethnicity), reacerace_cd(race), age_in_years_num, sex_cd and gender

Image RemovedImage Added

...