Attributes of transactional form structure columns
What they are for¶
The content of the columns can be supplemented by defining attributes for the following aspects:
- the column data format
- the type of data contained in the column
- a table of element values
Defining attributes is particularly useful for text- and amount-type columns for which the only information available when the form is created is the format and data type (field type). The system uses those values to guide the data entry when the form is run.
For example, if the column is meant to contain the value of an element of a dimension, the system will show a window in the data entry form with a list of the available elements for that dimensions.
The use of attributes is also useful for managing dictionary-type filters recalled by SQL queries in text- or amount-type columns. In this case, the elements of a column’s dictionary filter are filtered on the basis of the query syntax and may depend on the values of the elements of other columns (see Dictionaries).
Attribute details¶
A column’s attributes can be accessed from the administrator user’s web interface, following the path: Setup & Admin > Forms management tile > Elements > link Definition > Actions (
) > Details and positioning the cursor over the Attributes section.
Every attribute is identified by the following elements:
- a property, which indicates the name of the attribute,
- a value, which can be selected from a list of values proposed by the system or inserted manually by the user depending on the chosen key.
The following attributes are available for transactional form columns.
| Attribute | Description |
|---|---|
| New table elements | Only for text-type columns with Field type set to DIMENSION (dimension). Adds the elements inserted in the column in the data entry step as new items in the relevant elements table. |
| Generate code automatically | Only for text-type columns with Field type set to DIMENSION (dimension) and with New table elements selected. Allows you to specify whether the code of the new table element is generated automatically by the system based on the FORM_<10 random uppercase letters> convention or inserted manually by the user. |
| Size | Only for text-type columns with Field type set to DIMENSION (dimension). Allows you to select the available values for the column from a drop-down menu containing the CCH Tagetik dimensions (scenario, period, entity, etc.) |
| Field to which it refers | Only for text-type columns with Field type set to DIM_DES (Dimension description). Allows you to select, as values, the text-type field names to which the description refers. |
| Language | Only for text-type columns with Field type set to DIM_DES (Dimension description). This defines the table language on which the descriptions of the entered elements must be saved. Possible values: - Write on all languages (default value): saves the entered descriptions on all the managed table languages. - Write on the user’s language: saves the entered descriptions only on the table language associated with the user. - Specify: saves the descriptions on the managed table languages specified by the user. |
| Field to which it refers | Only for text-type columns with Field type set to HIERARCHY (Hierarchy). Allows you to select, as values, the text-type field names to which the description refers. |
| Hierarchy code | Only for text-type columns with Field type set to HIERARCHY (Hierarchy). This defines the table language on which the descriptions of the entered elements must be saved. Possible values: - Write on all languages (default value): saves the entered descriptions on all the managed table languages. - Write on the user’s language: saves the entered descriptions only on the table language associated with the user. - Specify: saves the descriptions on the managed table languages specified by the user. |
| Excel combo | Only for text-type columns with Field type set to DIMENSION (Dimension), that are associated with a dictionary and refer to a CCH Tagetik dimension. This allows you to associate a search window with the column to facilitate the selection of elements. Note: a window for searching by code and description is present for dimension fields by default. To change this behaviour, manually insert the Excel "combo" attribute. |
| Only description | Only for text-type columns with Field type set to DIMENSION (Dimension), that are associated with a dictionary and associated with a CCH Tagetik dimension. Allows you to see the description only, instead of the code/description pair, when reading the column. |
| Read only on already existing rows | Makes the column non-editable on the existing rows of the form. |
| Query code field | Only for columns with which a SQL Query-type dictionary is associated. Name of the query field used to define the dictionary to show on the code column. |
| Query description field | Only for columns with which a SQL Query-type dictionary is associated. Name of the query field used to define the dictionary to show on the description column. |
| Decode the Unicode text automatically | Only for text-type columns. Activates support for Unicode characters on the column. |
| Separator for multiple selection | Defines the separator value. |
| Monthly splitting | Only for amount-type columns |