Previous Topic

Next Topic

Book Contents

IRV_STUDYVERSION_FORMS

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

Columns in the IRV_STUDYVERSION_FORMS view

IRV_STUDYVERSION_FORMS
Column Name (Key Indicator)

IRV_STUDYVERSION_FORMS
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

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

COMMONFORM

Form is a common form:

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

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.

Send Feedback