Previous Topic

Next Topic

Book Contents

IRV_ITEM_REVS

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

Columns in the IRV_ITEM_REVS view

IRV_ITEM_REVS
Column Name (Key indicator)

IRV_ITEM_REVS
Column Description

ITEMID (PK)

Numeric identifier for the item.

ITEMREV (PK)

Revision number for the item.

FIRSTREV

This is the first revision of the item:

0 - No

1 - Yes

CURRENTREV

This is the most current revision of the item:

0 - No

1 - Yes

ITEMLAYOUT

Layout for the item, as set in the Central Designer application at the control level.

ITEMLABEL

Abbreviation for the item, which appears in itemsets or as a column heading in repeating page summaries.

ITEMQUESTION

Item question, as displayed on a form.

CONTROLID

Numeric identifier for the control with which the item is associated.

CONTROLREV

Revision number for the control with which the item is associated.

CALCULATED

Item is calculated:

0 - No

1 - Yes

SDVREQUIRED

Item is marked SV Required.

0 - No

1 - Yes

RANDOMIZE

Not used.

ITEMREQUIRED

Item is required.

ITEMREFNAME

RefName for the item.

DISPLAYOVERRIDE

Item display mode:

1 - Read-only
2 - Editable
3 - Hidden

ITEMHELPURL

URL for the sponsor-provided item Help.

ITEMDESIGNNOTE

Design note for the item, 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