IRV_CUR_COMMENT

This view contains the most recent information about each form and item comment.

Column Name (Key indicator)	Column Description
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.