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.