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