IRV_IC_ROLLUP_STUDYVERSIONS

This view contains item detail summarized at the study version level.

Column Name (Key indicator)	Column Description
STUDYVERSION	Always 1; indicates that the row represents one study version.
STUDYVERSIONID (PK)	Numeric identifier for the study version.
SUBJECTVISITS	Count of subject visits for the study version.
SUBJECTFORMS	Count of forms for the study version.
ITEMS	Count of items for the study version.
SECTIONITEMS	Count of items in each section for the study version.
ITEMSETITEMS	Count of items in itemsets for the study version.
FIRSTSDVTIME	First time an item associated with the study version was source verified.
LASTSDVTIME	Most recent time an item associated with the study version was source verified.
FIRSTDATATIME	First time an item associated with the study version had data.
LASTDATATIME	Most recent time an item associated with the study version had data.
FIRSTDATATRANSACTIONID	First data transaction for the study version.
LASTDATATRANSACTIONID	Most recent data transaction for the study version.
FIRSTSTATETIME	First date and time the item state changed for the study version.
LASTSTATETIME	Most recent date and time the item state changed for the study version.
FIRSTSTATETRANSACTIONID	First item state transaction for the study version.
LASTSTATETRANSACTIONID	Most recent item state transaction for the study version.
ITEMSSDVED	Count of source verified items for the study version.
ITEMSWITHDATA	Count of items that have data for the study version.
CONTROLS	Count of controls for the study version.
CONTROLSWITHDATA	Count of controls with data for the study version.
QUERIES	Count of queries for the study version.
QTYPEAUTO	Count of autoqueries for the study version.
QTYPEMANUAL	Count of manual queries for the study version.
QTYPECONFLICT	Count of conflict queries for the study version.
QREISSUED	Count of reissued queries for the study version.
QCANDIDATE	Count of candidate queries for the study version.
QOPENED	Count of opened queries for the study version.
QANSWERED	Count of answered queries for the study version.
QCLOSED	Count of closed queries for the study version.
QDELETED	Count of deleted queries for the study version.
ITEMCOMMENTS	Count of item comments for the study version.
FORMCOMMENTS	Count of form comments for the study version.