IRV_QUERY_REVS
This view contains query revision information.
| Column Name (Key indicator) | Description |
|---|---|
| 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. |
Parent topic: Study operational data