RV_SUBJ_ROLLUP_STUDY

This view contains subject detail summarized at the study level.

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