The setfinder query definition and the analysis plug-in definition information is stored in the QT_QUERY_MASTER table.
QT_QUERY_MASTER |
|
|
|
Key |
Column Name |
Column Definition |
Nullable? |
PK |
QUERY_MASTER_ID |
Unique id for the query |
NO |
|
NAME |
Name of the query |
NO |
|
USER_ID |
The user's login id |
NO |
|
GROUP_ID |
The project id |
NO |
|
MASTER_TYPE_ID |
If it is a setfinder query this field will be empty. |
YES |
|
PLUGIN_ID |
No used in the setfinder query |
YES |
|
GENERATED_SQL |
The database SQL transformation of the query definition. |
YES |
|
REQUEST_XML |
The query definition part of the request xml |
YES |
|
I2B2_REQUEST_XML |
The full request xml including the i2b2 header |
NO |
|
PM_XML |
The full request for from the PM cell |
YES |
|
CREATE_DATE |
Date that the request was created |
YES |
|
DELETE_DATE |
Date that the request was deleted |
YES |
|
DELETE_FLAG |
Y/N if the query is deleted |
YES |