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.