IRV_CUR_QUERY

This view contains the most recent information about each query.

Column Name (Key indicator)	Column Description
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.