IRV_IC_ROLLUP_SITES

This view contains item detail summarized at the site level.

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