Previous Topic

Next Topic

Book Contents

IRV_CUR_SYSTEMVERSION

This view contains current InForm version information.

Columns in the IRV_CUR_SYSTEMVERSION view

IRV_CUR_SYSTEMVERSION
Column Name (Key indicator)

IRV_CUR_SYSTEMVERSION
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.

Send Feedback