COMMENTCOUNT

Always 1; indicates that the row represents one comment.

COMMENTID (PK)

Numeric identifier for the comment.

COMMENTTIME

Time of the most recent comment revision.

COMMENTUSERID

Numeric identifier of the user who last revised the comment.

COMMENTHIST

Sequential numeric identifier that corresponds to the revision transaction of the last comment revision.

CONTEXTID

Numeric identifier of the item or form context associated with the comment.

SUBJECTVISITID

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

SUBJECTID

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

SITEID

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

STUDYVERSIONID

Numeric identifier for the study version with which the comment is associated.

VISITID

Numeric identifier for the visit in which the comment exists.

VISITREV

Revision number for the visit in which the comment exists.

VISITINDEX

Instance identifier for the visit in which the comment exists:

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

VISITIDX

Ordinal number of the visit instance starting from 1.

FORMID

Numeric identifier for the form with which the comment is associated.

FORMREV

Revision number for the form with which the comment is associated.

FORMINDEX

Identifier for the form instance with which the comment is associated:

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

FORMIDX

Ordinal number of the form instance starting from 1.

SECTIONID

Numeric identifier for the section with which the comment is associated.

SECTIONREV

Revision number for the section with which the comment is associated.

ITEMSETID

Numeric identifier for the itemset with which the comment is associated.

ITEMSETREV

Revision number for the itemset with which the comment is associated.

ITEMSETINDEX

Identifier for the itemset instance with which the comment is associated.

ITEMSETIDX

Ordinal number of the itemset instance starting from 1.

ITEMID

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

ITEMREV

Revision number for the item with which the comment is associated.

CREVS

Number of times the comment has been revised.

MINCOMMENTREV

First time the comment was revised.

MAXCOMMENTREV

Most recent time the comment was revised.

COMMENTTYPE

Type of comment:

0 - Form Comment
1 - Item Comment

CITEMCOMMENT

Comment is an item comment:

0 - No

1 - Yes

CFORMCOMMENT

Comment is a form comment:

0 - No

1 - Yes

COMMENTTEXT

Comment text.

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.