IRV_SUBJ_ROLLUP_SITES
This view contains subject detail summarized at the site level.
Columns in the IRV_SUBJ_ROLLUP_SITES view
IRV_SUBJ_ROLLUP_SITES |
IRV_SUBJ_ROLLUP_SITES |
---|---|
SITE |
Always 1; indicates that the row represents one site. |
SITEID (PK) |
Numeric identifier for the site. |
SUBJECTS |
Number of subjects for the site. |
SUBJECTSSCREENED |
Number of subjects currently in the Screened state for the site. |
SUBJECTSEVERSCREENED |
Number of subjects who have ever been screened for the site. |
SUBJECTSSCREENFAIL |
Number of subjects currently in the Screen Failed state for the site. |
SUBJECTSEVERSCREENFAIL |
Number of subjects who have ever failed screening for the site. |
SUBJECTSENROLLFAIL |
Number of subjects currently in the Enroll Failed state for the site. |
SUBJECTSEVERENROLLFAIL |
Number of subjects who have ever failed enrollment for the site. |
SUBJECTSENROLLED |
Number of subjects currently in the Enrolled state for the site. |
SUBJECTSEVERENROLLED |
Number of subjects who have ever been enrolled for the site. |
SUBJECTSRAMDOMIZED |
Number of subjects currently in the Randomized state for the site. |
SUBJECTSEVERRAMDOMIZED |
Number of subjects who have ever been randomized for the site. |
SUBJECTSCOMPLETED |
Number of subjects currently in the Complete state for the site. |
SUBJECTSEVERCOMPLETED |
Number of subjects who have ever been complete for the site. |
SUBJECTSINCOMPLETE |
Number of subjects currently in the Dropped Out state for the site. |
SUBJECTSEVERINCOMPLETE |
Number of subjects who have ever been dropped out for the site. |
COUNTBOOKSIGNED |
Number of signed case books for the site. |
COUNTBOOKFROZEN |
Number of frozen case books for the site. |
COUNTBOOKLOCKED |
Number of locked case books for the site. |
COUNTBOOKSDVREADY |
Number of SV Ready case books for the site. |
FIRSTBOOKSIGNED |
Date of first signed case book for the site. |
LASTBOOKSIGNED |
Date of most recent signed case book for the site. |
FIRSTBOOKFROZEN |
Date of first frozen case book for the site. |
LASTBOOKFROZEN |
Date of most recent frozen case book for the site. |
FIRSTBOOKLOCKED |
Date of first locked case book for the site. |
LASTBOOKLOCKED |
Date of most recent locked case book for the site. |
FIRSTBOOKSDVREADY |
Date of first SV Ready case book for the site. |
LASTBOOKSDVREADY |
Date of most recent SV Ready case book for the site. |