|
|
|
|
IRV_STUDYVERSION_FORMS
This view contains one row for each form installed into the study (MedML FormRef element).
Columns in the IRV_STUDYVERSION_FORMS view
IRV_STUDYVERSION_FORMS |
IRV_STUDYVERSION_FORMS |
|---|---|
STUDYID |
Numeric identifier for the study in which the form exists. |
STUDYVERSIONID (PK) |
Numeric identifier for the current study version for the study in which the form exists. |
VISITID (PK) |
Numeric identifier for the visit in which the form exists. |
VISITREV |
Revision number for the visit in which the form exists. |
FORMID (PK) |
Numeric identifier for the form. |
FORMREV |
Revision number for the form. |
FORMREFNAME |
RefName for the form. |
FORMNAME |
Form name. |
FORMMNEMONIC |
Abbreviated name for the form. |
FORMNOTE |
Form note, as displayed below the form name in the user interface. |
FORMTYPE |
Form type: 1 - CRF 3 - Enrollment 4 - Custom 5 - Custom study 6 - Custom Admin 7 - Custom Rules 8 - Custom Auth 101 - Monitor Regdoc 102 - Monitor Visit Report |
FORMHELPURL |
URL for the sponsor-provided form Help. |
QUESTIONWIDTH |
Question width for the items on the form. |
CONTROLWIDTH |
Width for the controls on the form. |
REPEATINGFORM |
Form can appear multiple times in a visit: 0 - No 1 - Yes |
COMMONFORM |
Form is a common form: 0 - No 1 - Yes |
FORMUNIQUEKEY |
Each combination of forms having KEYFORM=1. Must be unique within the visit: 0 - No 1 - Yes |
FORMDESIGNNOTE |
Design note for the form, as provided by the study designer. |
FORMORDER |
Order of the form in the visit. |
DYNAMICFORM |
Form is dynamic: 0 - No 1 - Yes |
EXPECTINGALTFORM |
Form is expected, and has an alternate form: 0 - No 1 - Yes |
ALTFORM |
Form is an alternate form: 0 - No 1 - Yes |
ALTFORMID |
Numeric identifier for the alternate form. |
ALTFORMREV |
Revision number for the alternate form. |
ASSOCVISIT |
Form is repeating, with one or more instances associated with one or more visits: 0 - No 1 - Yes |
ASSOCVISITID |
Numeric identifier for the visit associated with an instance of the repeating form. |
ASSOCVISITREV |
Revision number for the visit associated with an instance of the repeating form. |
FORMINCOMMONVISIT |
Form appears in the Common CRF visit: 0 - No 1 - Yes |
Copyright © 2014, 2017 Oracle and/or its affiliates. All rights reserved.