QT_QUERY_MASTER

Key

Column Name

Column Definition

Nullable?
(Default = YES)

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_IDCD

If it is a setfinder query this field will be empty.
If it is an Analysis plug-in, then this field will have the name of the plug-in.

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