IRV_SUBJ_ROLLUP_SITES
This view contains subject detail summarized at the site level.
Column Name (Key indicator) | Column Description |
---|---|
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. |
Parent topic: Subject summaries