Previous Topic

Next Topic

Book Contents

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
Column Name (Key indicator)

IRV_SUBJ_ROLLUP_SITES
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.

Send Feedback