IRV_IC_ROLLUP_VISITS
This view contains item detail summarized at the visit level.
Columns in the IRV_IC_ROLLUP_VISITS view
IRV_IC_ROLLUP_VISITS |
IRV_IC_ROLLUP_VISITS |
---|---|
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. |