Server (Cells) Architecture Home
Space shortcuts
Space Tools
Skip to end of metadata
Go to start of metadata

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

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



  • No labels