IRV_IC_ROLLUP_STUDY
This view contains item detail summarized at the study level.
Columns in the IRV_IC_ROLLUP_STUDY view
IRV_IC_ROLLUP_STUDY |
IRV_IC_ROLLUP_STUDY |
---|---|
STUDY |
Always 1; indicates that the row represents one study. |
STUDYID (PK) |
Numeric identifier for the study. |
SUBJECTVISITS |
Count of subject visits for the study. |
SUBJECTFORMS |
Count of forms for the study. |
ITEMS |
Count of items for the study. |
SECTIONITEMS |
Count of items in each section for the study. |
ITEMSETITEMS |
Count of items in itemsets for the study. |
FIRSTSDVTIME |
First time an item associated with the study was source verified. |
LASTSDVTIME |
Most recent time an item associated with the study was source verified. |
FIRSTDATATIME |
First time an item associated with the study had data. |
LASTDATATIME |
Most recent time an item associated with the study had data. |
FIRSTDATATRANSACTIONID |
First data transaction for the study. |
LASTDATATRANSACTIONID |
Most recent data transaction for the study. |
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 |
First item state transaction for the study. |
LASTSTATETRANSACTIONID |
Most recent item state transaction for the study. |
ITEMSSDVED |
Count of source verified items for the study. |
ITEMSWITHDATA |
Count of items that have data for the study. |
CONTROLS |
Count of controls for the study. |
CONTROLSWITHDATA |
Count of controls with data for the study. |
QUERIES |
Count of queries for the study. |
QTYPEAUTO |
Count of autoqueries for the study. |
QTYPEMANUAL |
Count of manual queries for the study. |
QTYPECONFLICT |
Count of conflict queries for the study. |
QREISSUED |
Count of reissued queries for the study. |
QCANDIDATE |
Count of candidate queries for the study. |
QOPENED |
Count of opened queries for the study. |
QANSWERED |
Count of answered queries for the study. |
QCLOSED |
Count of closed queries for the study. |
QDELETED |
Count of deleted queries for the study. |
ITEMCOMMENTS |
Count of item comments for the study. |
FORMCOMMENTS |
Count of form comments for the study. |