IRV_FORM_REVS
This view contains one row for each form installed into the study (MedML Form element).
Columns in the IRV_FORM_REVS view
IRV_FORM_REVS |
IRV_FORM_REVS |
---|---|
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 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 |
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. |