Page History
...
QT_Breakdown_Path table has been modified to include a new column Group_id. It logs the Project_id value.
| Column Name | Data Type |
|---|---|
| Group_Id | Varchar (50) |
Database Updates
RPDO_TABLE_REQUEST
...
The data table definitions are logged as breakdowns in the QT_QUERY_RESULT_TYPE table. The values are populated dynamically when the user saves the data table definition.
Following values are stored
RESULT_TYPE_ID: Auto generated number
NAME: RPDO_<<TABLE_INSTANCE_ID>>
VISUAL_ATTRIBUTE_TYPE_ID is set to LU
USER_ROLE_CD is set to DATA_LDS /NULL?
DISPLAY_TYPE_ID: CATNUM
CLASSNAME:
Example:
| RESULT_TYPE_ID | NAME | DESCRIPTION | DISPLAYTYPE_ID | VISUAL_ATTRIBUTE_TYPE_ID | USER_ROLE_CD | CLASSNAME | ||
| Auto generated number | RPDO_<TABLE_INSTANCE_ID> example: | 1159 | RPDO_78 | User-created Demographics Data Request | CATNUM | LU | DATA_LDS | edu.harvard.i2b2.crc.dao.setfinder.QueryResultPatientRequest |
...
QT_breakdown_path logs the table_instance_id and the stored procedure EXEC statement for creating the Data file . at the time of Data Table Definition creation
- The Table_instance_id is logged in the Name column when the user saves the table_definition.
- The Value column logs the EXEC statement of the stored procedure that generates the data file.
- The result_instance_id variable gets updated with the numeric value from the QUERY_RESULT_INSTANCE where the Ptset query result_type_id =1 at the time of creation of Data file.
...
