ITEMCOUNT

Always 1; indicates that the row represents one item on a form.

STUDYVERSIONID

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

CONTEXTID (PK)

Numeric identifier for the item context.

SUBJECTID

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

SITEID

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

SUBJECTVISITID

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

VISITID

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

VISITREV

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

VISITINDEX

Instance identifier for the visit in which the item exists on an activated form:

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

FORMID

Numeric identifier for the activated form on which the item exists.

FORMREV

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

FORMINDEX

Identifier for the form instance on which the item exists:

0 - unstarted form
1 - non-repeating form
<revisionnumber> - repeating form

FORMSECTIONORDER

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

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.

ITEMSETID

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

ITEMSETREV

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

ITEMSETINDEX

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

ITEMSETINDEXORDINAL

Itemset ordinal (0, 1, 2, 3...n ordered by itemset index).

SECTIONITEMORDER

Item/itemset order within the section 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.

INFORMPARTIALURL_CRFVIEW

Partial InForm URL for the activated form on which the item exists.

SECTIONITEM

Item is the child of a section:

0 - No

1 - Yes

ITEMSETITEM

Item is the child of an itemset:

0 - No

1 - Yes

IHREVS

Count of times the item state has changed.

MINCONTEXTREV

First item state change revision.

MAXCONTEXTREV

Most recent item state change revision.

STATEUSERID

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

STATETIME

Time of the most recent item state change.

STATETRANSACTIONID

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

STATEREASON

Reason for the most recent item state change.

ITEMDELETED

Item has been deleted:

0 - No

1 - Yes

ITEMSDVED

Item has been source verified:

0 - No

1 - Yes

SDVSELECTEDSTATE

Form is selected for source verification:

0 - No

1 - Yes

ITEMFIRSTSDV

First time the item was source verified.

SDVTIME

Most recent time the item was source verified.

IDREVS

Count of times the item data has changed.

MAXAUDITORDER

Most recent item data change revision.

DATAUSERID

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

DATATIME

Time of the most recent item data change.

DATATRANSACTIONID

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

DATAREASON

Reason for the most recent item data change.

ITEMFIRSTDATA

First time the item had data.

ITEMHASQUERIES

Item has queries:

0 - No

1 - Yes

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.

ITEMHASCOMMENTS

Item has comments:

0 - No

1 - Yes

ITEMCOMMENTS

Count of comments associated with the item.

CONTROLS

Count of controls in the item.

CONTROLSWITHDATA

Count of controls in the item that contain data.

ITEMEMPTY

Item has no data in any controls:

0 - No

1 - Yes

NOTDONE

Item has queries:

0 - No

1 - Yes

NOTDONEREASON

Reason entered when item was marked Not Done.

BLANK

The item exists in a Repeating Data itemset, and is blank 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

CREATEDBYUSERID

User ID of the user whose action resulted in the given view row being created.

CREATEDBYDATETIME

Date and time when the view row was created.

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.