IRV_CUR_SYSTEMVERSION
This view contains current InForm version information.
Columns in the IRV_CUR_SYSTEMVERSION view
IRV_CUR_SYSTEMVERSION |
IRV_CUR_SYSTEMVERSION |
---|---|
SYSTEMID (PK) |
Numeric identifier for the current InForm software version. |
SYSTEMREV |
Revision number for the current InForm software version. |
REVTIME |
Time the system revision was entered into the database. |
SYSTEMTYPE |
Type of study (always 1 in reporting): 0 - system forms 1 - study forms |
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 current 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. |