IRV_IC_ROLLUP_VISITS
This view contains item detail summarized at the visit level.
Column Name (Key indicator) | Column Description |
---|---|
SUBJECTVISIT | Always 1; indicates that the row represents one visit. |
SUBJECTVISITID | Numeric identifier for the subject visit instance. |
SUBJECTFORMS | Count of forms for the visit. |
ITEMS | Count of items for the visit. |
SECTIONITEMS | Count of items in each section for the visit. |
ITEMSETITEMS | Count of items in itemsets for the visit. |
FIRSTSDVTIME | First time an item associated with the visit was source verified. |
LASTSDVTIME | Most recent time an item associated with the visit was source verified. |
FIRSTDATATIME | First time an item associated with the visit had data. |
LASTDATATIME | Most recent time an item associated with the visit had data. |
FIRSTDATATRANSACTIONID | First data transaction for the visit. |
LASTDATATRANSACTIONID | Most recent data transaction for the visit. |
FIRSTSTATETIME | First date and time the item state changed for the visit. |
LASTSTATETIME | Most recent date and time the item state changed for the visit. |
FIRSTSTATETRANSACTIONID | First item state transaction for the visit. |
LASTSTATETRANSACTIONID | Most recent item state transaction for the visit. |
ITEMSSDVED | Count of source verified items for the visit. |
ITEMSWITHDATA | Count of items that have data for the visit. |
CONTROLS | Count of controls for the visit. |
CONTROLSWITHDATA | Count of controls with data for the visit. |
QUERIES | Count of queries for the visit. |
QTYPEAUTO | Count of autoqueries for the visit. |
QTYPEMANUAL | Count of manual queries for the visit. |
QTYPECONFLICT | Count of conflict queries for the visit. |
QREISSUED | Count of reissued queries for the visit. |
QCANDIDATE | Count of candidate queries for the visit. |
QOPENED | Count of opened queries for the visit. |
QANSWERED | Count of answered queries for the visit. |
QCLOSED | Count of closed queries for the visit. |
QDELETED | Count of deleted queries for the visit. |
ITEMCOMMENTS | Count of item comments for the visit. |
FORMCOMMENTS | Count of form comments for the visit. |
Parent topic: Item summaries