RD_VIEWDICTIONARY

The RD_VIEWDICTIONARY view is created from the join of the RT_MD_VIEWDICTIONARY table and the RD_DATADICTIONARY table. It also contains unit information from the RD_GCV_V_UNITLIST table.

RD_VIEWDICTIONARYColumn Name	RD_VIEWDICTIONARYColumn Description
VIEWNAME	Name for the RD view.
COLUMNNAME	Column name.
VIEWTYPE	Type of view. Always RD.
LANGUAGEID	ID for the locale.
CLAUSE	Indicates how to gather data to insert into this table (SELECT or FROM).
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
SECTIONORDER	Order of the section in the view.
ITEMORDER	Order of the item.
CHILDITEMORDER	Child item order (for items within itemsets only).
COLUMNORDER	Relative order of the column in the RD view.
EXPRESSION	SQL expression that is used to obtain data for this column.
TABLENAME	Table name.
TAB_COLUMN	Table column.
COLUMNDBTYPE	Generated DB column type: 0 - CLOB (for string objects where length is defined as > 1000) 1 - String 2 - Integer 3 - Float 4 - Datetime
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.
TXT_MAXLENGTH	Maximum length for a text field.
RD_TIME_STR	Reserved for internal use.
CV_PREFIX	Reserved for internal use.
HEIGHT	Control height.
UNITLEN	Length of the unit control.
UNITSYMBOL	Symbol string for the unit control.
BASEUNIT	Base unit for the control.