IRV_IC_ROLLUP_SUBJECTS

This view contains item detail summarized at the subject level.

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