IRV_CSV_ROLLUP_STUDY

This view contains visit detail summarized at the study level.

Column Name (Key indicator) Column Description
STUDY Always 1; indicates that the row represents one study.
STUDYID (PK) Numeric identifier for the study.
SVVISITS Count of visits for the study.
STUDY_FIRST_ENTRY First time data was entered for the study.
STUDY_LAST_ENTRY Date when data was most recently modified for the study.
FIRSTDOV First date of visit for the study.
LASTDOV Most recent date of visit for the study.
VISITSDELETED Count of deleted visits for the study.