QUERYCOUNT

Always 1; indicates that the row represents one query.

QUERYID (PK)

Numeric identifier for the query.

QUERYTIME

Time of most recent query revision.

QUERYUSERID

Numeric identifier of the user who last revised the query.

QUERYHIST

Sequential numeric identifier that corresponds to the state revision transaction of the last query revision.

CONTEXTID

Numeric identifier of the item context with which the query is associated.

SUBJECTVISITID

Numeric identifier for the subject visit with which the query is associated.

SUBJECTID

Numeric identifier for the subject with whom the query is associated.

STUDYID

Numeric identifier for the study with which the query is associated.

SITEID

Numeric identifier for the site with which the query is associated.

STUDYVERSIONID

Numeric identifier for the study version with which the query is associated.

VISITID

Numeric identifier for the visit in which the query exists.

VISITREV

Revision number for the visit in which the query exists.

VISITINDEX

Instance identifier for the visit in which the query exists:

0 - expected visit
1 - started, non-repeating visit
<revisionnumber> - repeating visit

VISITSTUDYVERSIONID

Numeric identifier for the study version for the visit in which the query exists.

FORMID

Numeric identifier for the form with which the query is associated.

FORMREV

Revision number for the form with which the query is associated.

FORMINDEX

Identifier for the form instance with which the query is associated:

0 - unstarted form
1 - non-repeating form
<revisionnumber> - repeating form

SECTIONID

Numeric identifier for the section with which the query is associated.

SECTIONREV

Revision number for the section with which the query is associated.

ITEMSETID

Numeric identifier for the itemset with which the query is associated.

ITEMSETREV

Revision number for the itemset with which the query is associated.

ITEMSETINDEX

Instance identifier for the itemset with which the query is associated.

ITEMID

Numeric identifier for the item with which the query is associated.

ITEMREV

Revision number for the item with which the query is associated.

QREVS

Number of times the query has been revised.

MINQUERYREV

First time the query was revised.

MAXQUERYREV

Most recent time the query was revised.

QUERYTYPE

Query type:

0 - Auto
1 - Manual
2 - Conflict

QTYPEAUTO

Query type is Autoquery:

0 - No

1 - Yes

QTYPEMANUAL

Query type is Manual:

0 - No

1 - Yes

QTYPECONFLICT

Query type is Conflict:

0 - No

1 - Yes

QUERYSTATE

Query state:

0 - Candidate
1 - Opened
2 - Answered
3 - Closed
4 - Deleted

QREISSUED

Query is reissued:

0 - No

1 - Yes

QCANDIDATE

Query state is Candidate:

0 - No

1 - Yes

QOPENED

Query state is Open:

0 - No

1 - Yes

QANSWERED

Query state is Answered:

0 - no

1 - yes

QCLOSED

Query state is Closed:

0 - No

1 - Yes

QDELETED

Query state is Deleted:

0 - No

1 - Yes

QUERYGROUP

Numeric identifier for the query group with which the query is associated.

QUERYDATA

Current query text.

RULEITEMID

Numeric identifier of the rule item that generated the query.

RULEID

Numeric identifier of the rule that generated the query.

CONFLICTSTATE

Contains an explanation of a query that is in conflict.

INFORMPARTIALURL_QUERY

Partial InForm URL for the query.

QDAYSOPENTOANSWER

Number of days from query open to answered.

QDAYSANSWERTOCLOSE

Number of days from query answered to closed.

QDAYSOPENTOCLOSE

Number of days from query opened to closed.

QCOUNTREISSUED

Count of times the query was reissued.

QMINREISSUED

First time the query was reissued.

QMAXREISSUED

Most recent time the query was reissued.

QCOUNTCANDIDATE

Count of times the query was in the Candidate state.

QMINCANDIDATE

First time the query was assigned the Candidate state.

QMAXCANDIDATE

Most recent time the query was assigned the Candidate state.

QCOUNTOPENED

Count of times the query was in the Open state.

QMINOPENED

First time the query was assigned the Opened state.

QMAXOPENED

Most recent time the query was assigned the Opened state.

QCOUNTANSWERED

Count of times the query was in the Answered state.

QMINANSWERED

First time the query was assigned the Answered state.

QMAXANSWERED

Most recent time the query was assigned the Answered state.

QCOUNTCLOSED

Count of times the query was in the Closed state.

QMINCLOSED

First time the query was assigned the Closed state.

QMAXCLOSED

Most recent time the query was assigned the Closed state.

QCOUNTDELETED

Count of times the query was in the Deleted state.

QMINDELETED

First time the query was assigned the Deleted state.

QMAXDELETED

Most recent time the query was assigned the Deleted state.

QORIGUSER

Numeric identifier of the user who generated the query.

QSTATUSTIME

Time of current query revision.

QDAYSINSTATE

Number of days the query has been in its current state.

Note: Don't use this column if you load data incrementally from this view through updates to the MODIFIEDDTETIME value. This column updates dynamically every time data is retrieved from this View, changing values for date and time continuously as a result. As such, the MODIFIEDDATETIME column purposely ignores changes in this column.

FIRSTREISSUEDTEXT

Query text associated with first reissue.

LASTREISSUEDTEXT

Query text associated with most recent reissue.

FIRSTCANDIDATETEXT

Query text when the query was first assigned the Candidate state.

LASTCANDIDATETEXT

Query text when the query was most recently assigned the Candidate state.

FIRSTOPENEDTEXT

Query text when the query was first assigned the Opened state.

LASTOPENEDTEXT

Query text when the query was most recently assigned the Opened state.

FIRSTANSWEREDTEXT

Query text when the query was first assigned the Answered state.

LASTANSWEREDTEXT

Query text when the query was most recently assigned the Answered state.

FIRSTCLOSEDTEXT

Query text when the query was first assigned the Closed state.

LASTCLOSEDTEXT

Query text when the query was most recently assigned the Closed state.

FIRSTDELETEDTEXT

Query text when the query was first assigned the Deleted state.

LASTDELETEDTEXT

Query text when the query was first assigned the Deleted state.

CREATEDBYUSERID

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

CREATEDBYDATETIME

Date and time when the view row was created.

MODIFIEDBYUSERID

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

MODIFIEDDATETIME

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