RT_MD_VIEWDICTIONARY

Each row in the RT_MD_VIEWDICTIONARY table represents a column in the CV, DV, or RD views and contains instructions on how these views are built.

Each row in the RD_DATADICTIONARY table has a corresponding row in the RT_MD_VIEWDICTIONARY table, and each of these rows has a VIEWTYPE of RD.

RT_MD_VIEWDICTIONARY table

RT_MD_VIEWDICTIONARY Column Name	RT_MD_VIEWDICTIONARY Column Description
VIEWNAME	Name for the view.
COLUMNNAME	Column name.
VIEWTYPE	Type of view. CV—Clinical view. DV—Data Viewer view. RD—RDE view. DI—Clinical view with date and state data for items and itemsets.
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	Order of the child item in the itemset.
COLUMNORDER	Relative order of the column in the RD view.
EXPRESSION	SQL expression that is used to obtain data for this column.