IRV_FORM_REVS

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

Column Name (Key indicator) Column Description
FORMID (PK) Numeric identifier for the form.
FORMREV (PK) Revision number for the form.
FIRSTREV

This is the first revision of the form:

0 - No

1 - Yes
CURRENTREV

This is the most current revision of the form:

0 - No

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