IRV_FORM_ITEMS
This view contains information about items on activated forms. This view does not contain information about expected forms.
| Column Name (Key indicator) | Column Description |
|---|---|
| ITEMCOUNT | Always 1; indicates that the row represents one item on a form. |
| STUDYVERSIONID | Numeric identifier for the study version in which the item exists on an activated form. |
| CONTEXTID (PK) | Numeric identifier for the item context. |
| SUBJECTID | Numeric identifier for the subject for which the item exists on an activated form. |
| SITEID | Numeric identifier for the site for which the item exists on an activated form. |
| SUBJECTVISITID | Numeric identifier for the subject visit in which the item exists on an activated form. |
| VISITID | Numeric identifier for the visit in which the item exists on an activated form. |
| VISITREV | Revision number for the visit in which the item exists on an activated form. |
| VISITINDEX |
Instance identifier for the visit in which the item exists on an activated form: 0 - expected visit 1 - started, non-repeating visit <revisionnumber> - repeating visit |
| FORMID | Numeric identifier for the activated form on which the item exists. |
| FORMREV | Revision number for the activated form on which the item exists. |
| FORMINDEX |
Identifier for the form instance on which the item exists: 0 - unstarted form 1 - non-repeating form <revisionnumber> - repeating form |
| FORMSECTIONORDER | Order of the section in which the item exists on an activated form. |
| SECTIONID | Numeric identifier for the section in which the item exists on an activated form. |
| SECTIONREV | Revision number for the section in which the item exists on an activated form. |
| ITEMSETID | Numeric identifier for the itemset in which the item exists on an activated form. |
| ITEMSETREV | Revision number for the itemset in which the item exists on an activated form. |
| ITEMSETINDEX | Itemset instance identifier for the itemset in which the item exists on an activated form. |
| ITEMSETINDEXORDINAL | Itemset ordinal (0, 1, 2, 3...n ordered by itemset index). |
| SECTIONITEMORDER | Item/itemset order within the section in which the item exists on an activated form. |
| ITEMSETITEMORDER | Item order within itemset in which the item exists on an activated form. |
| ITEMID | Numeric identifier for the item. |
| ITEMREV | Revision number for the item. |
| INFORMPARTIALURL_CRFVIEW | Partial InForm URL for the activated form on which the item exists. |
| SECTIONITEM |
Item is the child of a section: 0 - No 1 - Yes |
| ITEMSETITEM |
Item is the child of an itemset: 0 - No 1 - Yes |
| IHREVS | Count of times the item state has changed. |
| MINCONTEXTREV | First item state change revision. |
| MAXCONTEXTREV | Most recent item state change revision. |
| STATEUSERID | Numeric identifier of the user who made the most recent item state change. |
| STATETIME | Time of the most recent item state change. |
| STATETRANSACTIONID | Transaction numeric identifier associated with the most recent item state change. |
| STATEREASON | Reason for the most recent item state change. |
| ITEMDELETED |
Item has been deleted: 0 - No 1 - Yes |
| ITEMSDVED |
Item has been source verified: 0 - No 1 - Yes |
| SDVSELECTEDSTATE |
Form is selected for source verification: 0 - No 1 - Yes |
| ITEMFIRSTSDV | First time the item was source verified. |
| SDVTIME | Most recent time the item was source verified. |
| IDREVS | Count of times the item data has changed. |
| MAXAUDITORDER | Most recent item data change revision. |
| DATAUSERID | Numeric identifier of the user that made the most recent item data change. |
| DATATIME | Time of the most recent item data change. |
| DATATRANSACTIONID | Transaction numeric identifier associated with the most recent item data change. |
| DATAREASON | Reason for the most recent item data change. |
| ITEMFIRSTDATA | First time the item had data. |
| ITEMHASQUERIES |
Item has queries: 0 - No 1 - Yes |
| QUERIES | Count of queries against the item. |
| QTYPEAUTO | Count of autoqueries against the item. |
| QTYPEMANUAL | Count of manual queries against the item. |
| QTYPECONFLICT | Count of conflict queries against the item. |
| QREISSUED | Count of reissued queries against the item. |
| QCANDIDATE | Count of candidate queries against the item. |
| QOPENED | Count of open queries against the item. |
| QANSWERED | Count of answered queries against the item. |
| QCLOSED | Count of closed queries against the item. |
| QDELETED | Count of deleted queries against the item. |
| ITEMHASCOMMENTS |
Item has comments: 0 - No 1 - Yes |
| ITEMCOMMENTS | Count of comments associated with the item. |
| CONTROLS | Count of controls in the item. |
| CONTROLSWITHDATA | Count of controls in the item that contain data. |
| ITEMEMPTY |
Item has no data in any controls: 0 - No 1 - Yes |
| NOTDONE |
Item has queries: 0 - No 1 - Yes |
| NOTDONEREASON | Reason entered when item was marked Not Done. |
| BLANK |
The item exists in a Repeating Data itemset, and is blank in the itemset. 0 - No 1 - Yes |
| ITEMSDVOVERRIDE |
Critical setting for the item is overridden: 0 - No 1 - Yes |
| ITEMSDVSELECTED |
Item is selected for source verification: 0 - No 1 - Yes |
| 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. |
Parent topic: Study operational data