QUERYID

Query ID

QUERYREV

Query revision number

QREVS

Number of Query revisions.

MINQUERYREV

Min Query revision number

MAXQUERYREV

Max Query revision number

FIRSTQUERYREV

If Query revision number equals the MINQUERYREV. 1 yes, 0 no

CURRENTQUERYREV

If Query revision number equals the MAXQUERYREV. 1 yes, 0 no

QUERYTIME

Date when Query changed.

QUERYUSERID

User ID who made the Query change

QUERYHIST

Query change historical order within a transaction.

CONTEXTID

Query item context ID

SUBJECTVISITID

Subject visit ID

SUBJECTID

Subject ID

STUDYID

Volume (study) ID

SITEID

Site ID

STUDYVERSIONID

Study version ID

VISITID

Visit ID

VISITINDEX

Visit index

FORMID

Form ID

FORMREV

Form revision number

FORMINDEX

Form index

SECTIONID

Section ID

ITEMSETID

Itemset ID

ITEMSETINDEX

Itemset index

ITEMID

Item ID

QUERYTYPE

Query type.

0: auto query

1: manual query

2: conflict query

QTYPEAUTO

Is query an auto query. 1 yes, 0 no

QTYPEMANUAL

Is query a manual query. 1 yes, 0 no

QTYPECONFLICT

Is query a conflict query. 1 yes, 0 no

QUERYSTATE

Query state.

0: candidate state

1: open state

2: Answer state

3: close state

4: delete state

5: Sponsor conflict state

6: site conflict state

QREISSUED

If query is reissued. 1 yes, 0 no

QCANDIDATE

If query is at candidate state. 1 yes, 0 no.

QOPENED

If query is at open state. 1 yes, 0 no.

QANSWERED

If query is at answer state. 1 yes, 0 no

QCLOSED

If query is at close state. 1 yes, 0 no

QDELETED

If query is at deleted state. 1 yes, 0 no

QUERYGROUP

Query group ID where the user belongs to.

QUERYDATA

Query data.

RULEITEMID

Rule item ID responsible for this query.

RULEID

Rule ID responsible for this query

CONFLICTSTATE

Reserved column.

CREATEDDATETIME

Date and time when the view row was created.

CREATEDBYUSERID

User ID of the user whose action resulted in the given view row being created.

MODIFIEDDATETIME

Date and time when the data in the view row was most recently updated.

MODIFIEDBYUSERID

User ID of the user whose action resulted in the most recent change to data in the given view row.