IRV_CSV_ROLLUP_SUBJECTS
This view contains visit detail summarized at the subject level.
Columns in the IRV_CSV_ROLLUP_SUBJECTS view
IRV_CSV_ROLLUP_SUBJECTS |
IRV_CSV_ROLLUP_SUBJECTS |
---|---|
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. |