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

IRV_STUDYVERSION_FORMS

This view contains one row for each form installed into the study (MedML FormRef element).

Column Name (Key Indicator) Column Description
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
  2. Enrollment
  3. Custom
  4. Custom Study
  5. Cystom Admin
  6. Custom Rules
  7. Custom Auth
  8. Monitor Regdoc
  9. 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 common:

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 alternate:

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.

Parent topic: Study design metadata