SUBJECTID

Numeric identifier for the subject for whom the form instance exists.

VISITID

Numeric identifier for the visit in which the form instance exists.

VISITINDEX

Identifier for the visit instance associated with the form:

0 - expected visit
1 - started, non-repeating visit
<revisionnumber> - repeating visit

FORMID

Numeric identifier for the form instance.

FORMINDEX

Identifier for the form instance:

0 - expected form
1 - started, non-repeating form
<revisionnumber> - repeating form

FORMREV

Revision number for the form.

SITEID

Numeric identifier for the site with which the form instance is associated.

STUDYID

Numeric identifier for the study with which the form instance is associated.

STUDYVERSIONID

Numeric identifier for the study version with which the form instance is associated.

SUBJECTVISITID

Numeric identifier for the started or activated subject visit in which the form exists.

SUBJECTFORM

Always 1; indicates that the row represents one form instance.

ITEMS

Count of items on the form instance.

SECTIONITEMS

Count of items in each section on the form instance.

ITEMSETITEMS

Count of items in itemsets on the form instance.

FIRSTSDVTIME

First time the form instance was source verified.

LASTSDVTIME

Most recent time the form instance was source verified.

FIRSTDATATIME

First time data was entered for the form instance.

LASTDATATIME

Most recent time data was entered for the form instance.

FIRSTDATATRANSACTIONID

Numeric identifier for the first data transaction for the form instance.

LASTDATATRANSACTIONID

Numeric identifier for the most recent data transaction for the form instance.

FIRSTSTATETIME

First date and time the item state changed for the form instance.

LASTSTATETIME

Most recent date and time the item state changed for the form instance.

FIRSTSTATETRANSACTIONID

Numeric identifier for the first state transaction for the form instance.

LASTSTATETRANSACTIONID

Numeric identifier for the most recent state transaction for the form instance.

ITEMSDELETED

Count of deleted items on the form instance.

ITEMSSDVED

Count of Source Verified items on the form instance.

ITEMSWITHDATA

Count of items on the form instance that have data.

CONTROLS

Count of controls on the form instance.

CONTROLSWITHDATA

Count of controls with data on the form instance.

QUERIES

Count of queries associated with the form instance.

QTYPEAUTO

Count of autoqueries associated with the form instance.

QTYPEMANUAL

Count of manual queries associated with the form instance.

QTYPECONFLICT

Count of conflict queries associated with the form instance.

QREISSUED

Count of reissued queries associated with the form instance.

QCANDIDATE

Count of candidate queries associated with the form instance.

QOPENED

Count of opened queries associated with the form instance.

QANSWERED

Count of answered queries associated with the form instance.

QCLOSED

Count of closed queries associated with the form instance.

QDELETED

Count of deleted queries associated with the form instance.

ITEMCOMMENTS

Count of item comments associated with the form instance.

FORMCOMMENTS

Count of form comments associated with the form instance.

MODIFIEDBYUSERID

User ID of the user whose action resulted in the most recent change to data in the given view row.

MODIFIEDDATETIME

Date and time when the data in the view row was most recently updated.