Column Name (key indicator)

Description

COMMENTID

Comment ID

COMMENTREV

Comment revision number

COMMENTTIME

When comment was entered

COMMENTUSERID

User ID who entered the comment

COMMENTHIST

Historical order in a transaction

CONTEXTID

Item context ID

SUBJECTID

Subject ID

SITEID

Site ID

VISITID

Visit ID

VISITINDEX

Visit index

FORMID

Form ID

FORMREV

Form revision number

FORMINDEX

Form index

SECTIONID

Section ID

ITEMSETID

Itemset ID

ITEMSETINDEX

Itemset index

ITEMID

Item ID

COMMENTTYPE

Comment Type. 0 form level comment, 1 item level comment

CITEMCOMMENT

If comment is an item level comment. 1 yes, 0 no

CFORMCOMMENT

If comment is a form level comment. 1 yes, 0 no

COMMENTTEXT

Comment text

CREATEDDATETIME

Date and time when the view row was created.

CREATEDBYUSERID

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

MODIFIEDDATETIME

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

MODIFIEDBYUSERID

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