IRV_SV_SUBJECTVISITS

This view contains the most current information about started and expected visits for each subject.

Note:

Dynamic visits are considered expected when they are currently triggered for a given subject. However, dynamic visits not yet triggered or un-triggered (permitting they were not started) are intentionally excluded from this view.

Column Name (Key indicator)	Column Description
SUBJECTVISITCOUNT	Always 1; indicates that the row represents one subject visit.
SUBJECTID (PK)	Numeric identifier for the subject.
SUBJECTSTATE	Numeric value for the subject state: 1 - Screened 2 - Screening Failure 3 - Enrollment Failure 4 - Enrolled 5 - Randomized 6 - Completed 7 - Dropped Out
SITEID	Numeric identifier for the site with which the subject and visit are associated.
STUDYVERSIONID	Numeric identifier for the current study version with which the subject and visit are associated.
VISITID (PK)	Numeric identifier for the visit with which the subject and visit are associated.
VISITREV	Revision number for the visit with which the subject and visit are associated.
VISITINDEX (PK)	Instance identifier for the visit with which the subject is associated. Population dependent on Visit Type: Standard visit: 0 - expected visit 1 - started visit Repeating visit: 0 - expected visit <Repeating Visit Index> - started visit instance
VISITORDINAL	Visit ordinal (0, 1, 2, 3...n ordered by visit index).
SUBJECTVISITID	Subject visit numeric identifier.
VISITACTIVATED	Visit is started: 0 - No 1 - Yes
VISITINCURSV	Visit is in current study version: 0 - No 1 - Yes
VISITORDER	Order of the visit in the study.
STARTHOURSFROMPREVIOUS	Number of hours from enrollment to when the visit is scheduled to start.
STARTHOURSFROMENROLL	Number of hours from enrollment to when the visit is scheduled to start.
VISITTYPE	Numeric value for the type of visit: 1 - Visit 2 - Enrollment 3 - Screening 4 - Monitor 5 - Status 6 - Common CRF 7 - Regdocs 8 - Visitreports 9 - Conflict 16 - Relation
VTSUBJECTVISIT	Visit type is CRF: 0 - No 1 - Yes
VTCOMMONCRF	Visit type is Common CRF: 0 - No 1 - Yes
VISITPROPERTIES	Contains the same data as the VISITTYPE column. For internal Oracle use only.
VISITSCHEDULED	Visit is scheduled: 0 - No 1 - Yes
VISITSREPEATING	Visit can be repeated: 0 - No 1 - Yes
VISITDYNAMIC	Visit is dynamic: 0 - No 1 - Yes
EXPECTEDSTARTDATE	Visit expected start date: (STARTHOURSFROMENROLL + subject enrolled date)
VISIT_FIRST_ENTRY	Date when data was first entered for the visit.
VISIT_LAST_ENTRY	Date when data was most recently modified for the visit.
PROJECTEDSTARTHOURS	Not used.
STARTDATETIME	Not used.
SUBJECTVISITREV	Revision number for the subject visit.
DOV	Date of visit, as entered in the InForm user interface.
DOVDTMASK	Indicates valid date components that comprise the DOV. Sum of the following values for each valid date part: Year (0x01) 1, Month (0x02) 2, Day (0x04) 4, Hour (0x08) 8, Minute (0x10) 16, Second (0x20) 32.
DELETED	Not used. The value for this column is always NULL.
USERID	Numeric identifier of the user who last modified the visit.
SVTIME	Time of last visit revision.
TRANSACTIONID	Transaction associated with last visit revision.
REASON	Reason for last visit revision.
VISITCOMPLETE	All expected forms in the visit are complete: 0 - No 1 - Yes
RDEVISITFROZEN	All expected forms in the visit are frozen: 0 - No 1 - Yes
VISITSDVCOMPLETE	All expected forms in the visit are Verified: 0 - No 1 - Yes
VISITSIGNED	All expected forms in the visit are signed: 0 - No 1 - Yes
VISITLOCKED	All expected forms in the visit are locked: 0 - No 1 - Yes
CREATEDBYUSERID	User ID of the user whose action resulted in the given view row being created.
CREATEDBYDATETIME	Date and time when the view row was created.
MODIFIEDBYUSERID	User ID of the user whose action resulted in the most recent change to data in the given view row.
MODIFIEDDATETIME	Date and time when the data in the view row was most recently updated.