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.

Column Name	Column Description
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	Untruncated column name.
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
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.
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: Basic Data Additional Data Incomplete Data Reasons
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 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.
ITEMID	Numeric identifier for the item.