RT_CV_MODELDICTIONARY
The RT_CV_MODELDICTIONARY is created from the RT_MD_DATADICTIONARY, and is used to create the Cognos labels that appear in the Reporting and Analysis module.
Columns in the RT_CV_MODELDICTIONARY view
RT_CV_MODELDICTIONARY |
RT_CV_MODELDICTIONARY |
---|---|
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. |
COLUMNTYPE |
Generated column type: 1 - COLTYPE_TEXTFLOAT |
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. |
VIEWNAME |
Name of the view. |
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. |
COLUMNNAME |
Column name. |
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 |
|
ITEMID |
Numeric identifier for the item. |