Server (Cells) Architecture Home
Space shortcuts
Space Tools

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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

...