Previous Topic

Next Topic

Book Contents

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

IRV_CSV_ROLLUP_SUBJECTS
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.

Send Feedback