Previous Topic

Next Topic

Book Contents

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

IRV_SUBJ_ROLLUP_STUDY
Column Description

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.

Send Feedback