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_CD | 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 |
