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. |
Parent topic: Study design metadata