RD_DATADICTIONARY

The RD_DATADICTIONARY table (Data Dictionary) describes how RD views are mapped to clinical forms, is built from the RT_CV_MODELDICTIONARY table, and contains metadata for each control in a study, or a description of the control.

Note:

The RD_DATADICTIONARY table contains language-dependent data.

RD_DATADICTIONARYColumn Name RD_DATADICTIONARYColumn Description
RD_VIEWNAME Name of the RD view:
  • If the form does not contain any itemsets, RD_<FormRefName>.
  • If the form contains one or more itemsets, RD_<FormRefName_ItemsetRefName>.
  • If the form contains one or more itemsets, and the itemsets do not have RefNames, RD_<FormRefName>_<Count>.

RD view names are truncated to 30 characters. If duplicate RD view names exist, each view is assigned the name that corresponds to the value in the TABLENAME column in the view, prefixed with RD_. If the value in the TABLENAME column includes a prefix, the prefix is removed, and replaced with RD_.

For example, if two views named RD_AdverseEvent exist, one might be named RD_AE, and the other might be named RD_AdverseEvent.

Note:

When you migrate to the Oracle InForm 7.0.1 release, names of truncated RD views may change.
RD_COLUMNNAME Column name, truncated and appended with the following, where appropriate, so that the column name contains a maximum of 30 characters.
  • _DTS—Datetime string in ISO format.
  • _TMS—Time string in ISO format.
  • _DTR—Date time as entered, including UNK and NUL.
  • _TMR—Time as entered, including UNK and NUL.
  • _N—Normalized item.
  • _NU—Normalized unit.
  • _U—Unit item.
  • _C—Code item.
  • _ND—Not done item.

For more information about column naming conventions for RD views, see Column naming conventions for RD views.
RD_RAWCOLUMN Untruncated RD column name.
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

32 - COLTYPE_SUBJECTNUMBERSTR

33 - COLTYPE_FORMFIRSTDATE

34 - COLTYPE_FORMLASTDATE
COLUMNORDER Relative order of the column in the RD view.
FORMREFNAME Form RefName.
SECTIONREFNAME Section RefName.
ITEMREFNAME Item RefName.
CHILDITEMREFNAME Child item 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 Untruncated column name.
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.

0 - Unlimited precision.

n - Number of decimal places for the precision.

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 Order of the child item in the itemset.
VIEWLABEL Report topic name.
VIEWDESC Report topic description, from the form description.
COLUMNFOLDER Report topic folder. 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 query subject.
COLUMNLABEL Corresponding Cognos model report topic item name.
COLUMNDESC Corresponding Cognos model report topic item description.
COLUMNVALUE Column value. One of the set of values pertain to the clinical view column/clinical report topic item.
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 Form type:

1 - CRF

3 - Enrollment

4 - Custom

5 - Custom study

6 - Custom Admin

7 - Custom Rules

8 - Custom Auth

101 - Monitor Regdoc

102 - Monitor Visit Report
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 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.
HEIGHT Control height.

Parent topic: RDE design