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.