IRV_MD_FORMS_CONTROLS

This view contains one row for each control in every form installed into the study.

If (itemset = 0):

• ItemID—ItemID (ItemType 0).
• RootcontrolID—Root control for the item on which the control exists.
• I_ and C_ attributes—Attribute columns for item on which the control exists, and the item's root control.
• ChildItemID, CI—Null. (Only itemsets have child items.)
• ChildID and CC_—Attributes of the control described by the row.
• Child1-4—Nested controls of the item on which the control exists. (For example, if child1-4 is an array, then ChildID is the control ID located at array index ChildDepth.)

If (itemset = 1):

• ItemID—ItemID (ItemType 1).
• I_—Attribute columns for the itemset in which the control exists.
• ChildItemID/ChildItemOrder—Determines which item in the itemset is described by the row.
• CI_ attributes—Attributes for the itemset item on which the control exists.
• C_ attributes—Attributes of the root control of the itemset item on which the control exists.
• Child controls—Described the same as they are for non-itemset items.

Note:

ItemID always refers to the ultimate parent item, which is the item that comes from the PF_SECTIONITEM table. ItemID refers to either an item or an itemset.

Column Name (Key indicator)	Column Description
MDFCID	Unique numerical identifier.
FORMID (PK)	Numeric identifier for the form on which the control exists.
FORMREV (PK)	Revision number for the form on which the control exists.
FORMREFNAME	RefName for the form on which the control exists.
FORMNAME	Name of the form on which the control exists.
FORMMNEMONIC	Abbreviated name for the form on which the control exists.
FORMTYPE	Type of form on which the control exists: 1 - CRF 3 - Enrollment 4 - Custom 5 - Custom trial 6 - Custom Admin 7 - Custom Rules 8 - Custom Auth 101 - Monitor Regdoc 102 - Monitor Visit Report
FORMNOTE	Form note, as displayed below the form name in the user interface, for the form on which the control exists.
FORMHELPURL	URL for the sponsor-provided form Help.
QUESTIONWIDTH	Question width for the item on which the control exists.
FORMCONTROLWIDTH	Width of the control.
REPEATINGFORM	Form on which the control exists appears 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 on which the control exists, as provided by the study designer.
FORMSECTIONORDER (PK)	Order within the form for the section in which the control exists.
SECTIONID (PK)	Numeric identifier for the section in which the control exists.
SECTIONREV (PK)	Revision number for the section in which the control exists.
NUMBERSTART	Indicates where to start numbering the items within the section in which the control exists.
NUMBERTYPE	Identifies the numbering scheme used for items within the section in which the control exists: 0 - Numeric 1 - Alphanumeric
SECTIONREFNAME	RefName for the section in which the control exists.
SECTIONHEADER	Title of the section in which the control exists.
SECTIONNOTE	Section note, as displayed below the section name in the user interface, for the section in which the control exists.
REPEATINGSECTION	Section in which the control exists contains an itemset: 0 - no 1 - yes
SECTIONDESIGNNOTE	Design note for the section in which the control exists, as provided by the study designer.
SECTIONITEMORDER (PK)	Order of the item in which the control exists within the section.
ITEMID (PK)	Numeric identifier for the item on which the control exists.
ITEMREV (PK)	Revision number for the item on which the control exists.
ITEMSET	Item on which the control exists is an itemset: 0 - No 1 - Yes
I_ITEMTYPE	Type of the study object on which the control exists: 0 - item 1 - itemset
I_ITEMLAYOUT	Layout for the item or itemset on which the control exists, as set in the Central Designer application at the control level.
I_ITEMQUESTION	Question, as displayed on a form, for the item or itemset on which the control exists. (Always NULL for itemsets.)
I_ITEMLABEL	Abbreviation in itemsets or as a column heading in repeating page summaries for the item or itemset on which the control exists.
I_CALCULATED	Item or itemset on which the control exists is calculated: 0 - No 1 - Yes
I_SDVREQUIRED	Item or itemset on which the control exists is marked SV Required: 0 - No 1 - Yes
I_RANDOMIZE	Item or itemset on which the control exists is randomized.
I_ITEMREQUIRED	Item or itemset on which the control exists is required.
I_ITEMREFNAME	RefName for the item or itemset on which the control exists.
I_ITEMHELPURL	URL for the sponsor-provided Help for the item or itemset on which the control exists.
I_DISPLAYOVERRIDE	Display mode for the item or itemset on which the control exists: 1 - Read-only 2 - Editable 3 - HiddenItem or itemset
I_ITEMDESIGNNOTE	Design note for the item or itemset on which the control exists, as provided by the study designer.
CHILDITEMORDER	Order in an itemset of the child item on which the control exists.
CHILDITEMID (PK)	Numeric identifier for the child item on which the control exists.
CHILDITEMREV (PK)	Revision number for the child item in which the control exists.
KEYITEM	Child item on which the control exists is part of unique key (see ITEMSETUNIQUEKEY): 0 - No 1 - Yes
ITEMSETUNIQUEKEY	Each combination of items having KEYITEM=1 must be unique within the itemset: 0 - No 1 - Yes
CI_ITEMTYPE	Type for the itemset on which the control exists. (Always 0 for items.)
CI_ITEMLAYOUT	Layout for the itemset on which the control exists, as set in the Central Designer application at the control level.
CI_ITEMQUESTION	Question for the itemset on which the control exists, as displayed on a form.
CI_ITEMLABEL	Abbreviation for the itemset on which the control exists, which appears in the itemset or as a column heading in repeating page summaries.
CI_CALCULATED	Itemset on which the control exists is calculated: 0 - No 1 - Yes
CI_SDVREQUIRED	Itemset on which the control exists requires source verification: 0 - No 1 - Yes
CI_RANDOMIZE	Itemset on which the control exists is randomized.
CI_ITEMREQUIRED	Itemset on which the control exists is required: 0 - No 1 - Yes
CI_ITEMREFNAME	RefName for the itemset on which the control exists.
CI_ITEMHELPURL	URL for the sponsor-provided Help for the itemset on which the control exists.
CI_DISPLAYOVERRIDE	Display mode for the itemset on which the control exists (overridden by itemset property): 1 - Read-only 2 - Editable 3 - Hidden
CI_ITEMDESIGNNOTE	Design note for the child item on which the control exists, as provided by the study designer.
C_CONTROLID (PK)	Numeric identifier for the control (root control for nested controls).
C_CONTROLREV (PK)	Revision number for the root control.
C_CONTROLREFNAME	RefName for the root control.
C_CONTROLNAME	Name of the root control.
C_CONTROLTABLE	Name of the table containing attributes specific to the type of control.
C_CONTROLTYPE	Root control type: 1 - Simple control 2 - Drop-down list 3 - Listbox control 5 - Text control 6 - Calculated control 7 - Group control 8 - Radio control 9 - Checkbox group 10 - Date control
C_CONTROLLAYOUT	Root control layout: 1 - Horizontal 2 - Vertical 3 - No wrapping
C_CAPTION	Root control caption.
C_CONTROLALIGNMENT	Root control alignment: 1 - Left 2 - Center 3 - Right 4 - Top 5 - Middle 6 - Bottom
C_CAPTIONALIGNMENT	Caption alignment with respect to the root control: 1 - Left 2 - Center 3 - Right 4 - Top 5 - Middle 6 - Bottom
C_HEIGHT	Root control height.
C_UNITDISPLAYTYPE	Units within the control display as: 1 - A single element 2 - Radio buttons 3 - Drop-down list
C_CONTROLDESIGNNOTE	Design note for the root control, as provided by the study designer.
PARENTID	Numeric identifier for the parent control (for nested control).
PARENTREV	Revision number for the parent control.
P_C_ORDER	Order in which the parent control appears in the nested control.
CHILDDEPTH	Level (0-4) at which the child control is nested within the item.
CHILDORDER	Order in which the child control appears in the itemset.
CHILDSELECT	Value to associate with the parent control when this child control is selected. (If blank, the InForm application generates a value of the format "!pf!{CONTROLGUID}".)
CC_CONTROLID	Numeric identifier for the control (for nested control).
CC_CONTROLREV	Revision number for the control.
CC_CONTROLREFNAME	Child control RefName.
CC_CONTROLNAME	Child control name.
CC_CONTROLTABLE	Name of the table containing attributes specific to the type of control.
CC_CONTROLTYPE	Child control type: 1 - Simple control 2 - Drop-down list 3 - Listbox control 5 - Text control 6 - Calculated control 7 - Group control 8 - Radio control 9 - Checkbox group 10 - Date control
CC_CONTROLLAYOUT	Child control layout: 1 - Horizontal 2 - Vertical 3 - No wrapping
CC_CAPTION	Child control caption.
CC_CAPTIONID	Numeric identifier for Child control caption.
CC_CONTROLALIGNMENT	Child control alignment: 1 - Left 2 - Center 3 - Right 4 - Top 5 - Middle 6 - Bottom
CC_CAPTIONALIGNMENT	Child caption alignment with respect to the child control: 1 - Left 2 - Center 3 - Right 4 - Top 5 - Middle 6 - Bottom
CC_HEIGHT	Child control height.
CC_UNITDISPLAYTYPE	Units within the child control display as: 1 - A single element 2 - Radio buttons 3 - Drop-down list
CC_CONTROLDESIGNNOTE	Child control design note, as provided by the study designer.
CHILD1ID (PK)	Numeric identifier for the first child control.
CHILD1REV (PK)	Revision number for the first child control.
CHILD1ORDER (PK)	Order in which the first child control appears in the itemset.
CHILD1SELECT	First child control value to associate with the parent control when this child control is selected. (If blank, the InForm application generates a value of the format "!pf!{CONTROLGUID}".)
CHILD2ID (PK)	Numeric identifier for the second child control.
CHILD2REV (PK)	Revision number for the second child control.
CHILD2ORDER (PK)	Order in which the second child control appears in the itemset.
CHILD2SELECT	Second child control value to associate with the parent control when this child control is selected. (If blank, the InForm application generates a value of the format "!pf!{CONTROLGUID}".)
CHILD3ID (PK)	Numeric identifier for the third child control.
CHILD3REV (PK)	Revision number for the third child control.
CHILD3ORDER (PK)	Order in which the third child control appears in the itemset.
CHILD3SELECT	Third child control value to associate with the parent control when this child control is selected. (If blank, the InForm application generates a value of the format "!pf!{CONTROLGUID}".)
CHILD4ID (PK)	Numeric identifier for the fourth child control.
CHILD4REV (PK)	Revision number for the fourth child control.
CHILD4ORDER (PK)	Order in which the fourth child control appears in the itemset.
CHILD4SELECT	Fourth child control value to associate with the parent control when this child control is selected. (If blank, the InForm application generates a value of the format "!pf!{CONTROLGUID}".)
CHILD5ID (PK)	Numeric identifier for the fifth child control.
CHILD5REV (PK)	Revision number for the fifth child control.
CHILD5ORDER (PK)	Order in which the fifth child control appears in the itemset.
CHILD5SELECT	Fifth child control value to associate with the parent control when this child control is selected. (If blank, the InForm application generates a value of the format "!pf!{CONTROLGUID}".)
CREATEDATETIME	Date and time when the reported form was started; that is, when a user entered data on the form or triggered a rule that entered data on the form.
CREATEDBYUSERID	User ID of the user who started the form by entering data on the form or triggering a rule that entered data on the form.
MODIFIEDDATETIME	Date and time when the reported form was most recently started or modified; that is, when a user entered or modified data on the form or triggered a rule that entered or modified data on the form.
MODIFIEDBYUSERID	User ID of the user who started or modified the form by entering or modifying data or triggering a rule that entered or modified data on the form.