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. |
Parent topic: Visit summaries