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