Previous Topic

Next Topic

Book Contents

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
Column Name (Key indicator)

IRV_FORM_REVS
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

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.

Send Feedback