IRV_COMMENT_REVS

This view contains all comment revisions.

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.