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.
|
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. |
Parent topic: RDE design