IRV_STUDYVERSIONS
This view contains one row for each study version installed into the study (MedML StudyVersion element).
Columns in the IRV_STUDYVERSIONS view
IRV_STUDYVERSIONS |
IRV_STUDYVERSIONS |
---|---|
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. |