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