IRV_IC_ROLLUP_FORMS
This view contains item detail summarized at the form instance level.
Columns in the IRV_IC_ROLLUP_FORMS view
IRV_IC_ROLLUP_FORMS |
IRV_IC_ROLLUP_FORMS |
---|---|
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 |
FORMID |
Numeric identifier for the form instance. |
FORMINDEX |
Identifier for the form instance: 0 - expected 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. |