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