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_VIEWDICTIONARYColumn Name RT_MD_VIEWDICTIONARYColumn 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.