Page History
...
| Column Name | Data Type |
|---|---|
| Group_Id | Varchar (50) |
Database Changes- Data table definition
...
creation
New rows are dynamically logged in db tables when the user creates the data table definition or submits a data request
...
Data table design variables and values are dynamically updated inserted in the RPDO_TABLE_REQUEST at the time of data table Definition Save.
...
QT_QUERY_RESULT_TYPE
The data table definitions are definition is logged as breakdowns breakdown in the QT_QUERY_RESULT_TYPE table. The rows are inserted when the user saves the data table definition.
...
A new row is logged when the user saves the data table defintiondefinition.
- Name column logs the Table_instance_id when the user saves the table_definition.
- Value column logs the EXEC statement of the stored procedure that generates the data file.
- Group_id has the value of project_id
- The result_instance_id variable gets updated with the numeric value from the QUERY_RESULT_INSTANCE where the result_type_id (Ptset)=1 at the time of creation of Data file.
...
| NAME | VALUE | Group_id |
|---|---|---|
RPDO_<Table_instance_id> Example: RPDO_17 | EXEC i2b2synthea8.dbo.usp_rpdo2 @TABLE_INSTANCE_ID=<Table_instance_id> @RESULT_INSTANCE_ID={{{RESULT_INSTANCE_ID}}} @MIN_ROW=0 @MAX_ROW=10000 | SQLServerLarge |
Database Changes- Data request submission
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_id generated in the QT_Result_type
| Column Name | Value (Example) |
|---|---|
| Result_Type_ id | 144 |
| Result_instance_id | 1729 |
QT_BREAKDOWN_
...
PATH
The Value column is updated with for table_instance_id and result_instance_id in the EXEC statement and the stored procedure to generate the Data file is executed
...
