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.