IRV_ITEM_REVS

This view contains one row for each item installed into the study (MedML Item element).

Column Name (Key Indicator)	Column Description
ITEMID (PK)	Numeric identifier for the item.
ITEMREV (PK)	Revision number for the item.
FIRSTREV	This is the first revision of the item: 0 - No 1 - Yes
CURRENTREV	This is the most current revision of the item: 0 - No 1 - Yes
ITEMLAYOUT	Layout for the item, as set in the Central Designer application at the control level.
ITEMLABEL	Abbreviation for the item, which appears in itemsets or as a column heading in repeating page summaries.
ITEMQUESTION	Item question, as displayed on a form.
CONTROLID	Numeric identifier for the control with which the item is associated.
CONTROLREV	Revision number for the control with which the item is associated.
CALCULATED	Item is calculated: 0 - No 1 - Yes
SDVREQUIRED	Item is marked SV Required: 0 - No 1 - Yes
RANDOMIZE	Not used.
ITEMREQUIRED	Item is required.
ITEMREFNAME	RefName for the item.
DISPLAYOVERRIDE	Itemset display mode: 1 - ReadOnly—The item is visible but not editable. 2 - Editable—The item is visible and editable by any user, regardless of the rights assigned to the user. 3 - Hidden—The item is not visible. 0 - None—The item is visible to all users, and visible and editable by any user who has the rights to view and/or edit the item.
ITEMHELPURL	URL for the sponsor-provided item Help.
ITEMDESIGNNOTE	Design note for the item, as provided by the study designer.
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.