IRV_CUR_SYSTEMVERSION

This view contains current InForm version information.

Column Name (Key indicator) Column Description
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.