IRV_IC_ROLLUP_STUDY

This view contains item detail summarized at the study level.

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