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.