SUBJECT

Always 1; indicates that the row represents one subject.

SUBJECTID (PK)

Numeric identifier for the subject.

SUBJECTVISITS

Count of visits for the subject.

SUBJECTFORMS

Count of forms for the subject.

ITEMS

Count of items for the subject.

SECTIONITEMS

Count of items in each section for the subject.

ITEMSETITEMS

Count of items in itemsets for the subject.

FIRSTSDVTIME

First time an item associated with the subject was source verified.

LASTSDVTIME

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

FIRSTDATATIME

First time an item associated with the subject had data.

LASTDATATIME

Most recent time an item associated with the subject had data.

FIRSTDATATRANSACTIONID

First data transaction for the subject.

LASTDATATRANSACTIONID

Most recent data transaction for the subject.

FIRSTSTATETIME

First date and time the item state changed for the subject.

LASTSTATETIME

Most recent date and time the item state changed for the subject.

FIRSTSTATETRANSACTIONID

First item state transaction for the subject.

LASTSTATETRANSACTIONID

Most recent item state transaction for the subject.

ITEMSSDVED

Count of source verified items for the subject.

ITEMSWITHDATA

Count of items that have data for the subject.

CONTROLS

Count of controls for the subject.

CONTROLSWITHDATA

Count of controls with data for the subject.

QUERIES

Count of queries for the subject.

QTYPEAUTO

Count of autoqueries for the subject.

QTYPEMANUAL

Count of manual queries for the subject.

QTYPECONFLICT

Count of conflict queries for the subject.

QREISSUED

Count of reissued queries for the subject.

QCANDIDATE

Count of candidate queries for the subject.

QOPENED

Count of opened queries for the subject.

QANSWERED

Count of answered queries for the subject.

QCLOSED

Count of closed queries for the subject.

QDELETED

Count of deleted queries for the subject.

ITEMCOMMENTS

Count of item comments for the subject.

FORMCOMMENTS

Count of form comments for the subject.