Page History
...
| RPDO_TABLE_REQUEST PARAMETERS | DATA TABLE Values |
|---|---|
| Table_Request_id | auto generated incremental value, corresponding to each concept in the data table. Unique for each concept |
| Table_instance_id | unique for each Data table , auto generated incremental value ( same value for all the concepts underneath) example: 78144 |
QT_QUERY_RESULT_TYPE
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.
...
| RESULT_TYPE_ID | NAME | DESCRIPTION | DISPLAYTYPE_ID | VISUAL_ATTRIBUTE_TYPE_ID | USER_ROLE_CD | CLASSNAME |
Auto generated number example : 256 | RPDO_<TABLE_INSTANCE_ID> example: RPDO_78144 | User-created Demographics Data Request<Table_Name>Request | CATNUM | LU | DATA_LDS | edu.harvard.i2b2.crc.dao.setfinder.QueryResultPatientRequest |
...
| Info |
|---|
We recommend data requests be limited to DATA_LDS users and data exports be limited to MANAGER users. The user role determines if exports/requests are visible and runnable. Refer to section on User Roles and Actions |
QT_BREAKDOWN_PATH - Table Definition Creation
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 the QUERY_RESULT_INSTANCE where the Ptset query the result_type_id (Ptset)=1 at the time of creation of Data file.
Example:
| NAME | VALUE |
|---|---|
RPDO_<Table_instance_id> Example: RPDO_144 | EXEC i2b2synthea8.dbo.usp_rpdo2 @TABLE_INSTANCE_ID=<Table_instance_id> @RESULT_INSTANCE_ID={{{RESULT_INSTANCE_ID}}} @MIN_ROW=0 @MAX_ROW=10000 |
QT_QUERY_RESULT_INSTANCE
When the User runs a query with User created Data Request option selected, a row is logged in the QT_Query_Result_Instance for the result_type_oid generated in the QT_Result_type
| Column Name | Value (Example) |
|---|---|
| Result_Type_ id | 256 |
| Result_instance_id | 541 |
QT_BREAKDOWN_PATH - Data File Creation
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
Data file format/location and Email parameters set-up: HIVE_CELL_PARAMS
...
