1. InForm Reporting Database Schema Guide
  2. Operational view descriptions
  3. Study design metadata
  4. IRV_STUDYVERSION_VISITS

IRV_STUDYVERSION_VISITS

This view contains one row for each formset (visit) installed into the study (MedML FormSet element).

Column Name (Key indicator) Column Description
STUDYVERSIONID (PK) Numeric identifier for the current study version associated with the formset.
VISITID (PK) Numeric identifier for the visit.
VISITREV Revision number for the visit.
VISITREFNAME RefName for the visit.
VISITNAME Name of the visit.
VISITMNEMONIC Abbreviated name for the visit.
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
  10. Relation
VTSUBJECTVISIT

Visit type is CRF:

0 - No

1 - Yes
VTENROLLMENT

Visit type is Enrollment:

0 - No

1 - Yes
VTSCREENING

Visit type is Screening:

0 - No

1 - Yes
VTMONITOR

Visit type is Monitor:

0 - No

1 - Yes
VTSTATUS

Visit type is Status:

0 - No

1 - Yes
VTCOMMONCRF

Visit type is Common CRF:

0 - No

1 - Yes
VTREGDOCS

Visit type is Regulatory Document:

0 - No

1 - Yes
VTVISITREPORT

Visit type is Visit Report:

0 - No

1 - Yes
VTCONFLICT

Visit type is Conflict:

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
VISITOPTIONAL

Visit is optional:

0 - No

1 - Yes
VISITSREPEATING

Visit can be repeated:

0 - No

1 - Yes
VISITDYNAMIC

Visit is dynamic:

0 - No

1 - Yes
VISITRELATION

Visit type is Relation:

0 - No

1 - Yes
HELPTEXT Help text for the visit.
DESIGNNOTE Design note for the visit, as provided by the study designer.
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.
MAXTABS

Indicates the maximum number of Page-tabs that appear in one row. The default value is 8.

The column is ignored if the number of Pages is greater than twice the value of MAXTABS, because a maximum number of rows supported is 2.

Reserved for internal Oracle use.
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.

Parent topic: Study design metadata