IRV_SUBJ_ROLLUP_STUDY
This view contains subject detail summarized at the study level.
Columns in the IRV_SUBJ_ROLLUP_STUDY view
IRV_SUBJ_ROLLUP_STUDY |
IRV_SUBJ_ROLLUP_STUDY |
---|---|
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. |