The QT_PDO_QUERY_MASTER table is used as an audit table for the PDO query. The PDO request information will be stored in this table.
QT_PDO_QUERY_MASTER |
|
|
|
Key |
Column Name |
Column Definition |
Nullable? |
PK |
QUERY_MASTER_ID |
Unique id for the patient encounter set |
NO |
|
USER_ID |
The user's login id |
NO |
|
GROUP_ID |
The project id of the user |
NO |
|
CREATE_DATE |
The timestamp of when the PDO query was created |
NO |
|
REQUEST_XML |
The query definition part of the PDO request |
YES |
|
I2B2_REQUEST_XML |
The full PDO request including the i2b2 header |
NO |