Page History
...
The User created data requests are managed by the data Manager using the Data Request Manager tool.
Data Request Manager - Users Data Requests List
- Click on Tools=> Data Request Manager plugin.
...
The Manager User can view the details of the Requests using VIEW DETAILS button and generate the Data files using Create File(s) button)
View Data Request Details
Click on View Details.
The View Details panel is similar in display for non-Manager user, except the Manager User can change the Data Request Status..
...
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 the default data table parameters
- HIVE_CELL_PARAMS has new parameters for global and email configurations and the export data file generation location (currently on local drive)
- QT_RESULT_TYPE table has new entries for data table definition breakdown types
- QT_BREAKDOWN_PATH logs modified to log the data table definition id definition and the data export execution details.
- QT_XML_RESULT logs XML documents containing e-mail details.
...
The Value column is updated with result_instance_id from the Q_Result_Instance in the EXEC statement and the stored procedure to generate the Data flle is executed
Example:
| NAME | VALUE |
|---|---|
RPDO_<Table_instance_id> Example: RPDO_144 | EXEC i2b2synthea8.dbo.usp_rpdo2 @TABLE_INSTANCE_ID=<Table_instance_id> @RESULT_INSTANCE_ID=541 @MIN_ROW=0 @MAX_ROW=10000 |
QT_XML_RESULT
Metadata about data request queries are stored in the QT_XML_RESULT table, in the XML_VALUE field. The Value column gets updated with the change in Status of the Data Request. Following are the staus change in the <data column> tag
...
