IRV_SUBJ_ROLLUP_STUDYVERSIONS

This view contains subject detail summarized at the study version level.

Column Name (Key indicator)	Column Description
STUDYVERSION	Always 1; indicates that the row represents one study version.
STUDYVERSIONID (PK)	Numeric identifier for the study version.
SUBJECTS	Number of subjects for the study version.
SUBJECTSSCREENED	Number of subjects currently in the Screened state for the study version.
SUBJECTSEVERSCREENED	Number of subjects that have ever been screened for the study version.
SUBJECTSSCREENFAIL	Number of subjects currently in the Screen Failed state for the study version.
SUBJECTSEVERSCREENFAIL	Number of subjects that have ever failed screening for the study version.
SUBJECTSENROLLFAIL	Number of subjects currently in the Enroll Failed state for the study version.
SUBJECTSEVERENROLLFAIL	Number of subjects that have ever failed enrollment for the study version.
SUBJECTSENROLLED	Number of subjects currently in the Enrolled state for the study version.
SUBJECTSEVERENROLLED	Number of subjects that have ever been enrolled for the study version.
SUBJECTSRAMDOMIZED	Number of subjects currently in the Randomized state for the study version.
SUBJECTSEVERRAMDOMIZED	Number of subjects that have ever been randomized for the study version.
SUBJECTSCOMPLETED	Number of subjects currently in the Completed state for the study version.
SUBJECTSEVERCOMPLETED	Number of subjects that have ever been completed for the study version.
SUBJECTSINCOMPLETE	Number of subjects currently in the Dropped Out state for the study version.
SUBJECTSEVERINCOMPLETE	Number of subjects that have ever been dropped out for the study version.
COUNTBOOKSIGNED	Number of signed case books for the study version.
COUNTBOOKFROZEN	Number of frozen case books for the study version.
COUNTBOOKLOCKED	Number of locked case books for the study version.
COUNTBOOKSDVREADY	Number of SV Ready case books for the study version.
FIRSTBOOKSIGNED	Date of first signed case book for the study version.
LASTBOOKSIGNED	Date of most recent signed case book for the study version.
FIRSTBOOKFROZEN	Date of first frozen case book for the study version.
LASTBOOKFROZEN	Date of most recent frozen case book for the study version.
FIRSTBOOKLOCKED	Date of first locked case book for the study version.
LASTBOOKLOCKED	Date of most recent locked case book for the study version.
FIRSTBOOKSDVREADY	Date of first SV Ready case book for the study version.
LASTBOOKSDVREADY	Date of most recent SV Ready case book for the study version.