IRV_SYSTEMVERSIONS
This view contains information about all the InForm versions against which the study has been run.
Columns in the IRV_SYSTEMVERSIONS view
IRV_SYSTEMVERSIONS |
IRV_SYSTEMVERSIONS |
---|---|
SYSTEMID (PK) |
Numeric identifier for the InForm software version. |
SYSTEMREV (PK) |
Revision number for the InForm software version. |
FIRSTSYSTEMVERSION |
First system version: 0 - No 1 - Yes |
CURRENTSYSTEMVERSION |
Most recent system version: 0 - No 1 - Yes |
REVTIME |
Time the system revision was entered into the database. |
SYSTEMTYPE |
Type of InForm version. |
SYSTEMNAME |
Study name associated with the InForm version. |
SYSTEMVERSIONID |
Numeric identifier for the current InForm version. |
SPONSORAPPROVALDATE |
Date when the sponsor approved the version change. |
VERSIONDESCRIPTION |
InForm version description. |
SYSTEMVERSION |
Protocol version associated with the InForm version. |
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. |