CONTEXTID

Numeric identifier for the item context.

ITEM

Always 1; indicates that the row represents one item or itemset.

SECTIONITEM

Item is in a section.

0 - No

1 - Yes

ITEMSETITEM

Item is in an itemset.

0 - No

1 - Yes

SITEID

Numeric identifier for the site with which the item is associated.

SUBJECTID

Numeric identifier for the subject with which the item is associated.

SUBJECTVISITID

Numeric identifier for the subject visit with which the item is associated.

VISITID

Numeric identifier for the visit with which the item is associated.

VISITINDEX

Instance identifier for the started or activated visit in which the item exists:

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

FORMID

Numeric identifier for the form on which the item exists.

FORMINDEX

Instance identifier for the started or activated form in which the item exists:

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

FORMREV

Revision number for the activated form on which the item exists.

SECTIONID

Numeric identifier for the section in which the item exists on an activated form.

SECTIONREV

Revision number for the section in which the item exists on an activated form.

SECTIONORDER

Order of the section in which the item exists on an activated form.

SECTIONITEMORDER

Item order within the section in which the item exists on an activated form.

ITEMSETID

Numeric identifier for the itemset in which the item exists.

ITEMSETREV

Revision number for the itemset in which the item exists.

ITEMSETINDEX

Itemset instance identifier for the itemset in which the item exists on an activated form.

ITEMSETITEMORDER

Item order within itemset in which the item exists on an activated form.

ITEMID

Numeric identifier for the item.

ITEMREV

Revision number for the item.

MAXAUDITORDER

Most recent item data change revision.

ITEMSDVED

Item has been source verified:

0 - No

1 - Yes

ITEMDELETED

Item has been deleted:

0 - No

1 - Yes

MINCONTEXTREV

First item state change revision.

MAXCONTEXTREV

Most recent item state change revision.

DATATRANSACTIONID

Transaction numeric identifier associated with the most recent item data change.

DATAUSERID

Numeric identifier of the user that made the most recent item data change.

DATATIME

Time of the most recent item data change.

DATAREASON

Reason for the most recent item data change.

SDVTIME

Most recent time the item was source verified.

ITEMHASDATA

Indicates whether the item contains data.

CONTROLS

Count of controls in the item.

CONTROLSWITHDATA

Count of controls in the item that contain data.

STATETRANSACTIONID

Transaction numeric identifier associated with the most recent item state change.

STATEUSERID

Numeric identifier of the user who made the most recent item state change.

STATETIME

Time of the most recent item state change.

STATEREASON

Reason for the most recent item state change.

QUERIES

Count of queries against the item.

QTYPEAUTO

Count of autoqueries against the item.

QTYPEMANUAL

Count of manual queries against the item.

QTYPECONFLICT

Count of conflict queries against the item.

QREISSUED

Count of reissued queries against the item.

QCANDIDATE

Count of candidate queries against the item.

QOPENED

Count of open queries against the item.

QANSWERED

Count of answered queries against the item.

QCLOSED

Count of closed queries against the item.

QDELETED

Count of deleted queries against the item.

ITEMCOMMENTS

Count of comments associated with the item or itemset.

ITEMMARKEDINCOMPLETE

Item is marked incomplete:

0 - No

1 - Yes

BLANK

The item exists in a Repeating Data itemset, and is blank in the itemset.

0 - No

1 - Yes

PREDEFINED

The item exists in a Repeating Data itemset, and is predefined in the itemset.

0 - No

1 - Yes

ITEMSDVOVERRIDE

Critical setting for the item is overridden:

0 - No

1 - Yes

ITEMSDVSELECTED

Item is selected for source verification:

0 - No

1 - Yes

CREATEDDATETIME

Date and time when the item was started; that is, when a user entered data in the item or triggered a rule that entered data in the item.

CREATEDBYUSERID

User ID of the user who started the item by entering data or triggering a rule that entered data in the item.

MODIFIEDDATETIME

Date and time when the item was most recently modified; that is, when a user most recently entered data in the item or triggered a rule that entered data in the item.

MODIFIEDBYUSERID

User ID of the user who most recently started the item by entering data or triggering a rule that entered data in the item.