STUDYVERSIONID (PK)

Numeric identifier for the current study version.

STUDYID

Numeric identifier of the study.

STUDYREV

Revision number for the study.

REVTIME

Time the study version was entered into the database.

STUDYTYPE

Type of study (always 1 in reporting):

0 - system forms

1 - study forms

STUDYNAME

Name of the study associated with the study version.

TRADEDRUGNAME

Trade name for the drug associated with the study version.

GENERICDRUGNAME

Generic name for the drug associated with the study version.

SPONSORDRUGNAME

Name that the sponsor uses for the drug associated with the study version.

SPONSORAPPROVALDATE

Date when the sponsor approved the use of the study version.

EDITIONDESCRIPTION

Description of the study version.

STUDYVERSION

Study name.

PROTOCOLDESIGNNOTE

Design note for the protocol for the study version, as provided by the study designer.

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.