Previous Topic

Next Topic

Book Contents

IRV_STUDYVERSION_VISITS

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

Columns in the IRV_STUDYVERSION_VISITS view

IRV_STUDYVERSION_VISITS
Column Name (Key indicator)

IRV_STUDYVERSION_VISITS
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
16 - 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.

Send Feedback