Previous Topic

Next Topic

Book Contents

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

IRV_SYSTEMVERSIONS
Column Description

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.

Send Feedback