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. |
Parent topic: Item summaries