Text controls

Text controls

A text control is always mapped to at least one column.

View column name	View column type	Report element name	Report element folder
<CoreColumnName>— (Generally <ItemRefName>_ <ControlRefName>)	VARCHAR2(N)—If the control datatype is CHARACTER and its MAXLENGTH value is 255 or less. N is equal to the MAXLENGTH value. CLOB—If the control datatype is CHARACTER and its MAXLENGTH value is more than 255. Only the first 32000 characters of entered text are mapped. NUMBER—If the control datatype is INTEGER. FLOAT—If the control datatype is FLOAT.	<CoreItemName>— A name generated according to control mapping logic, generally the item question or item label prefixed by the control caption or control RefName.	Basic Data

If the data type of a text control is NUMERIC or FLOAT and has assigned units, the text control is mapped to three additional columns if there is more than one associated unit. A single unit may be read-only and cannot be selected.

View column name	View column type	Report element name	Report element folder	Content
N_<CoreColumnName>	NUMBER	Normalized ~ <CoreItemName>	Additional Data	Normalized value generated by associated unit rule from entered data.
UC_<CoreColumnName>	VARCHAR2	Unit Code ~ <CoreItemName>	Additional Data	Coded value of selected unit, which represents UNITREFNAME attribute.
U_<CoreColumnName>	VARCHAR2	Unit ~ <CoreItemName>	Basic Data	Value of selected unit, which represents UNITSYMBOL attribute.

The following examples illustrate mapping a character text control.

Figure 4-22 Oracle Central Designer Properties Browser view

Figure 4-23 MedML definition

Figure 4-24 Display in the Oracle InForm application

Figure 4-25 Database view

Figure 4-26 Cognos model

Figure 4-27 Oracle Central Designer Properties Browser view

Figure 4-28 MedML definition

Figure 4-29 Display in the Oracle InForm application

Figure 4-30 Database view

Figure 4-31 Cognos model