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_DATADICTIONARY table
RD_DATADICTIONARY |
RD_DATADICTIONARY |
---|---|
RD_VIEWNAME |
Name of the RD view:
|
RD_COLUMNNAME |
Column name, truncated and appended with the following, where appropriate, so that the column name contains a maximum of 30 characters.
|
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 |
|
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:
|
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 |
|
SDSDOMAIN |
|
SDSVARNAME |
|
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 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. |
HEIGHT |
Control height. |