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