Previous Topic

Next Topic

Book Contents

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
Column Name (Key indicator)

IRV_IC_ROLLUP_VISITS
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.

Send Feedback