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.

Column Name 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:

0 - CLOB (for string objects where length is defined as > 1000)

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 Null value. Reserved for future use.
SDSDOMAIN Null value. Reserved for future use.
SDSVARNAME Null value. Reserved for future use.
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.

Parent topic: Clinical metadata