IRV_IC_ROLLUP_FORMS
This view contains item detail summarized at the form instance level.
| Column Name (Key indicator) | Column Description |
|---|---|
| SUBJECTID | Numeric identifier for the subject for whom the form instance exists. |
| VISITID | Numeric identifier for the visit in which the form instance exists. |
| VISITINDEX |
Identifier for the visit instance associated with the form: 0 - expected visit 1 - started, non-repeating visit <revisionnumber> - repeating visit |
| FORMID | Numeric identifier for the form instance. |
| FORMINDEX |
Identifier for the form instance: 0 - expected form 1 - started, non-repeating form <revisionnumber> - repeating form |
| FORMREV | Revision number for the form. |
| SITEID | Numeric identifier for the site with which the form instance is associated. |
| STUDYID | Numeric identifier for the study with which the form instance is associated. |
| STUDYVERSIONID | Numeric identifier for the study version with which the form instance is associated. |
| SUBJECTVISITID | Numeric identifier for the started or activated subject visit in which the form exists. |
| SUBJECTFORM | Always 1; indicates that the row represents one form instance. |
| ITEMS | Count of items on the form instance. |
| SECTIONITEMS | Count of items in each section on the form instance. |
| ITEMSETITEMS | Count of items in itemsets on the form instance. |
| FIRSTSDVTIME | First time the form instance was source verified. |
| LASTSDVTIME | Most recent time the form instance was source verified. |
| FIRSTDATATIME | First time data was entered for the form instance. |
| LASTDATATIME | Most recent time data was entered for the form instance. |
| FIRSTDATATRANSACTIONID | Numeric identifier for the first data transaction for the form instance. |
| LASTDATATRANSACTIONID | Numeric identifier for the most recent data transaction for the form instance. |
| FIRSTSTATETIME | First date and time the item state changed for the form instance. |
| LASTSTATETIME | Most recent date and time the item state changed for the form instance. |
| FIRSTSTATETRANSACTIONID | Numeric identifier for the first state transaction for the form instance. |
| LASTSTATETRANSACTIONID | Numeric identifier for the most recent state transaction for the form instance. |
| ITEMSDELETED | Count of deleted items on the form instance. |
| ITEMSSDVED | Count of Source Verified items on the form instance. |
| ITEMSWITHDATA | Count of items on the form instance that have data. |
| CONTROLS | Count of controls on the form instance. |
| CONTROLSWITHDATA | Count of controls with data on the form instance. |
| QUERIES | Count of queries associated with the form instance. |
| QTYPEAUTO | Count of autoqueries associated with the form instance. |
| QTYPEMANUAL | Count of manual queries associated with the form instance. |
| QTYPECONFLICT | Count of conflict queries associated with the form instance. |
| QREISSUED | Count of reissued queries associated with the form instance. |
| QCANDIDATE | Count of candidate queries associated with the form instance. |
| QOPENED | Count of opened queries associated with the form instance. |
| QANSWERED | Count of answered queries associated with the form instance. |
| QCLOSED | Count of closed queries associated with the form instance. |
| QDELETED | Count of deleted queries associated with the form instance. |
| ITEMCOMMENTS | Count of item comments associated with the form instance. |
| FORMCOMMENTS | Count of form comments associated with the form instance. |
| 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: Item summaries