IRV_CSV_ROLLUP_SUBJECTS

This view contains visit detail summarized at the subject level.

Column Name (Key indicator) Column Description
SUBJECT Always 1; indicates that the row represents one subject.
SUBJECTID (PK) Numeric identifier for the subject.
SUBJECTVISITS Count of visits with which the subject is associated.
SUBJECT_FIRST_ENTRY First time data was entered for the subject.
SUBJECT_LAST_ENTRY Date when data was most recently modified for the subject.
FIRSTDOV First date of visit for the subject.
LASTDOV Most recent date of visit for the subject.
VISITSDELETED Count of deleted visits for the subject.