QT_QUERY_RESULT_INSTANCE

Key

Column Name

Column Definition

Nullable?
(Default = YES)

PK

RESULT_INSTANCE_ID

Unique id for the query

NO

FK

QUERY_INSTANCE_ID

Foreign key reference to the QT_QUERY_INSTANCE table

NO

FK

RESULT_TYPE_ID

Foreign key reference to the QT_QUERY_RESULT_TYPE table

NO

SET_SIZE

The size of the results; the size of the patient set or encounter set.
The value is based on the user role; an obfuscated value may be stored in this column.

YES

START_DATE

The timestamp for the start of each query result generated.

NO

END_DATE

The timestamp for the end of each query result generated.

YES

DELETE_FLAG

A flag to denote if this result instance is deleted (Y / N).

NO

FK

STATUS_TYPE_ID

Foreign key reference to the QT_STATUS_TYPE table.

NO

MESSAGE

To store the query error message, warning, etc.

YES

DESCRIPTION

The description displayed to the user in the client (i2b2 Web client and Workbench)

YES

REAL_SET_SIZE

The real set size. Unlike the SET_SIZE this column does NOT store obfuscated results.

YES

OBFUSC_METHOD

Method used to obfuscated the results, default is OBSUBTOTAL

YES