The metadata for the query result types are stored in the QT_QUERY_RESULT_TYPE table.

QT_QUERY_RESULT_TYPE

 

 

 

Key

Column Name

Column Definition

Nullable?
(Default = YES)

 

PK

RESULT_TYPE_ID

Unique id for the result type

NO

 

 

NAME

The name of the result type

NO

 

PK

DESCRIPTION

The description for the result type. This description is displayed to the user in the client (i2b2 Web client and Workbench)

NO

 

PK

DISPLAY_TYPE_ID

Information to UI as how to handle the result data. The values are:
LIST
CATNUM

NO

 

PK

VISUAL_ATTRIBUTE_TYPE_ID

Defines whether or not the result type is visible to the user. The values are:
LA = Visible
LH = Hidden

NO