STUDYVERSION

Always 1; indicates that the row represents one study version.

STUDYVERSIONID (PK)

Numeric identifier for the study version.

SUBJECTVISITS

Count of subject visits for the study version.

SUBJECTFORMS

Count of forms for the study version.

ITEMS

Count of items for the study version.

SECTIONITEMS

Count of items in each section for the study version.

ITEMSETITEMS

Count of items in itemsets for the study version.

FIRSTSDVTIME

First time an item associated with the study version was source verified.

LASTSDVTIME

Most recent time an item associated with the study version was source verified.

FIRSTDATATIME

First time an item associated with the study version had data.

LASTDATATIME

Most recent time an item associated with the study version had data.

FIRSTDATATRANSACTIONID

First data transaction for the study version.

LASTDATATRANSACTIONID

Most recent data transaction for the study version.

FIRSTSTATETIME

First date and time the item state changed for the study version.

LASTSTATETIME

Most recent date and time the item state changed for the study version.

FIRSTSTATETRANSACTIONID

First item state transaction for the study version.

LASTSTATETRANSACTIONID

Most recent item state transaction for the study version.

ITEMSSDVED

Count of source verified items for the study version.

ITEMSWITHDATA

Count of items that have data for the study version.

CONTROLS

Count of controls for the study version.

CONTROLSWITHDATA

Count of controls with data for the study version.

QUERIES

Count of queries for the study version.

QTYPEAUTO

Count of autoqueries for the study version.

QTYPEMANUAL

Count of manual queries for the study version.

QTYPECONFLICT

Count of conflict queries for the study version.

QREISSUED

Count of reissued queries for the study version.

QCANDIDATE

Count of candidate queries for the study version.

QOPENED

Count of opened queries for the study version.

QANSWERED

Count of answered queries for the study version.

QCLOSED

Count of closed queries for the study version.

QDELETED

Count of deleted queries for the study version.

ITEMCOMMENTS

Count of item comments for the study version.

FORMCOMMENTS

Count of form comments for the study version.