RT_MD_DATADICTIONARY
The controls for a form are mapped into zero or more columns in the RT_MD_DATADICTIONARY table. A column can contain either an arbitrary value or a list of predefined values (Checkbox, Pulldown, Units, and so on). For an arbitrary value, a column is represented by a single row in the RT_MD_DATADICTIONARY table, and for a list of predefined values, a column is represented by multiple rows that correspond to all potential values of the column.
The RT_MD_DATADICTIONARY table contains information about each form, section, item, itemset, and control that exists in each study version for a study, and is essential for the generated clinical table customization process.
Note: This table contains language-dependent data.
Columns in the RT_MD_DATADICTIONARY table
RT_MD_DATADICTIONARY |
RT_MD_DATADICTIONARY |
---|---|
TABLENAME |
Clinical table name. |
COLUMNNAME |
Clinical column name. (The logic used to build this column name is described in the clinical table description.) |
COLUMNTYPE |
Generated column type: 1 - COLTYPE_TEXTFLOAT |
COLUMNORDER |
Order of the column in the view. |
FORMREFNAME |
Form RefName. |
SECTIONREFNAME |
Section RefName. |
ITEMREFNAME |
Item RefName. |
CHILDITEMREFNAME |
Childitem RefName (for Itemsets). |
CTL0REFNAME |
Top level control RefName. |
CTL1REFNAME |
Second level control RefName. |
CTL2REFNAME |
Third level control RefName. |
CTL3REFNAME |
Fourth level control RefName. |
CTL4REFNAME |
Fifth level control RefName. |
RAWCOLUMNNAME |
Generated name (typically item RefName + control RefName). |
COLUMNDBTYPE
|
Generated DB column type: 0 - CLOB (for string objects where length is defined as > 1000) 1 - String 2 - Integer 3 - Float 4 - Datetime |
COLUMNVALUEREFNAME |
|
COLUMNFLOATPRECISION |
Column precision. Used only for Float text controls and is NULL for all other columns. |
FORMNAME |
Form name. |
SECTIONHEADER |
Section header. |
ITEMQUESTION |
Item question. |
CONTROLCAPTION |
Control caption. |
SECTIONORDER |
Order of the section on the form. |
ITEMORDER |
Order of the item within a section on the form. |
CHILDITEMORDER |
Child item order (for items within itemsets only). |
VIEWLABEL |
Report topic name. |
VIEWDESC |
Report topic description, from the form description. |
COLUMNFOLDER |
Report topic folder. Can have English or Japanese folder names. Only one of the three predefined folders is allowed:
|
COLUMNENABLE |
If value is zero, this column is suppressed from the clinical table and clinical report topic. |
COLUMNLABEL |
Corresponding Cognos model report element name. |
COLUMNDESC |
Corresponding Cognos model report element description. |
COLUMNVALUE |
Column value. One of the set of values pertain to the clinical view column/clinical report element. |
SASDATASETNAME |
Null value. Reserved for future use. |
SASFIELDNAME |
|
SDSDOMAIN |
|
SDSVARNAME |
|
FORMTYPE |
Type of form. |
ITEMSET |
Indicates whether an item is part of an itemset. 0 - The item is not part of an itemset. 1 - The item is part of an itemset. |
CONTROLTYPE |
Control type: 1 - ELEMENTTYPE 2 - PULLDOWNTYPE 5 - TEXTBOXTYPE 6 - CALCULATIONTYPE 7 - CONTROLGROUPTYPE 8 - RADIOGROUPTYPE 9 - CHECKBOXGROUPTYPE 10 - DATETIMETYPE |
CH0TYPE |
Control type of the top-level control. |
CH1TYPE |
Control type of the second level control. |
CH2TYPE |
Control type of the third level control. |
CH3TYPE |
Control type of the fourth level control. |
CH4TYPE |
Control type of the fifth level control. |
REPEATINGVISIT |
Indicates whether the visit is repeating. 0 - Visit is not repeating. 1 - Visit is repeating. |
REPEATINGFORM |
Indicates whether the form is repeating. 0 - Form is not repeating. 1 - Form is repeating. |
REPEATINGITEM |
Indicates whether the item is repeating. 0 - Item is not repeating. 1 - Item is repeating. |
FORMID |
DBUID for the form. |
FORMREV |
Revision number for the form. |
SECTIONID |
DBUID for the section |
ITEMID |
DBUID for the item. |
CHILDITEMID |
DBUID for the child item in an itemset. |
CONTROLID |
DBUID for the control. |
CONTROLREV |
Revision number for the control. |
CONTROLREFNAME |
Control RefName. |
CID0 |
DBUID for the top-level nested control. |
CID1 |
DBUID for the second level nested control. |
CID2 |
DBUID for the third level nested control. |
CID3 |
DBUID for the fourth level nested control. |
CID4 |
DBUID for the fifth level nested control. |
SECORD |
Order of the section on the form. |
ITEMORD |
Order of the item in the section. |
CHILDITEMORD |
Order of the child item in the itemset. |
CONTROLDEPTH |
Depth of nesting for the control. |
CH1ORD |
Order of the first level child item. |
CH2ORD |
Order of the second level child item. |
CH3ORD |
Order of the third level child item. |
CH4ORD |
Order of the fourth level child item. |
FORMMNEMONIC |
Mnemonic for the form. |
FORMNOTE |
Form note. |
FORMDESIGNNOTE |
Form design note |
ITEMLABEL |
Item label. |
SINGLECHILDCONTROL |
Indicates whether the control has a single child. 0 - Control has no children. 1 - Control has one child. |
CONTROLNAME |
Name of the control. |
CONTROLDESIGNNOTE |
Design note for the control. |
THESAMECONTROLCOUNT |
Number of times the control exists in the study design. |
TXT_MAXLENGTH |
Maximum length for a text field. |
TXT_DATATYPE |
Data type of the object. |
TXT_PRECISION |
Precision associated with a text box with a data type of FLOAT. 0 - Control can have any precision. n - Number of decimal places in precision. |
DATE_DISPLAYMASK |
Mask for date components to display. 1 - Year information is displayed. 2 - Month information is displayed. 4 - Day information is displayed. |
DATE_REQUIREDMASK |
Mask for date components that are required. 1 - Year information is required. 2 - Month information is required. 4 - Day information is required. |
DATE_UNKNOWNMASK |
Mask for date components that are not required. 1 - Year information is not required. 2 - Month information is not required. 4 - Day information is not required. |