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.