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.