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 Column Name	RT_MD_DATADICTIONARY Column Description
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 2 - COLTYPE_TEXTNUM 3 - COLTYPE_TEXTSTR 4 - COLTYPE_TEXTBLOB 5 - COLTYPE_DATE 6 - COLTYPE_MONTHYEAR 7 - COLTYPE_DATESTR 8 - COLTYPE_TIME_HM 9 - COLTYPE_TIME_HMS 10 - COLTYPE_TIMESTR 11 - COLTYPE_YEAR 12 - COLTYPE_MONTH 13 - COLTYPE_UNITNORMALIZED 14 - COLTYPE_UNITCODE 15 - COLTYPE_UNITLABEL 16 - COLTYPE_CHILDSELCODE 17 - COLTYPE_CHILDSELLABEL 18 - COLTYPE_VISITINDEX 19 - COLTYPE_FORMINDEX 20 - COLTYPE_ITEMINDEX 21 - COLTYPE_DOV 22 - COLTYPE_DELETEDFORM 23 - COLTYPE_DELETEDITEM 24 - COLTYPE_ITEMNOTDONEREASON 25 - COLTYPE_FORMMNEMONIC 26 - COLTYPE_VISITMNEMONIC 27 - COLTYPE_VISITORDER 28 - COLTYPE_SUBJECTINITIALS 29 - COLTYPE_SITENAME 30 - COLTYPE_SITEMNEMONIC 31 - COLTYPE_SITECOUNTRY
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: 1 - String 2 - Integer 3 - Float 4 - Datetime
COLUMNVALUEREFNAME	If the column uses a list of pre-defined values, the value RefName. For Units, the unit RefName. For a radio or checkbox control, the child control RefName. For a drop-down list, the element RefName.
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: Basic Data Additional Data Incomplete Data Reasons
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.