IRV_SECTION_REVS

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

Column Name (Key indicator) Column Description
SECTIONID (PK) Numeric identifier for the section.
SECTIONREV (PK) Revision number for the section.
FIRSTREV

This is the first revision of the section:

0 - No

1 - Yes
CURRENTREV

This is the most current revision of the section:

0 - No

1 - Yes
SECTIONREFNAME RefName for the section.
SECTIONHEADER Section title.
SECTIONNOTE Section note, as displayed below the section name in the user interface.
REPEATINGSECTION

Section contains an itemset:

0 - No

1 - Yes
SECTIONDESIGNNOTE Design note for the section, as provided by the study designer.
INITIALROWCOUNT
One of the following values:
  • Repeating Data itemset — Number of rows in the itemset.
  • Add Entry itemset — 0
  • Non-repeating item—Null
ROWCOUNTFIXED
One of the following values:
  • Repeating Data itemset — 1
  • Add Entry itemset — 0
  • Non-repeating item—Null
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.

Parent topic: Study design metadata