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:

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.