IRV_STUDYVERSIONS

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

Column Name (Key indicator)	Column Description
STUDYVERSIONID (PK)	Numeric identifier for the current study version.
STUDYID	Numeric identifier of the study.
STUDYREV	Revision number for the study.
REVTIME	Time the study version was entered into the database.
STUDYTYPE	Type of study (always 1 in reporting): 0 - system forms 1 - study forms
STUDYNAME	Name of the study associated with the study version.
TRADEDRUGNAME	Trade name for the drug associated with the study version.
GENERICDRUGNAME	Generic name for the drug associated with the study version.
SPONSORDRUGNAME	Name that the sponsor uses for the drug associated with the study version.
SPONSORAPPROVALDATE	Date when the sponsor approved the use of the study version.
EDITIONDESCRIPTION	Description of the study version.
STUDYVERSION	Study name.
PROTOCOLDESIGNNOTE	Design note for the protocol for the study version, 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.