Dictionary entry form

The Dictionary Entry form was redesigned to provide an Advanced view and additional fields. You might need to configure the form to see all fields.

Table 1. Dictionary Entry form
Field Description
Table

Defines the table in which the element is created.

Note: This list shows only the tables that meet the scope protections for adding fields. See .
Type

Defines the field type of the column or, if the Type is Collection, indicates that the dictionary entry represents the table.

You can change the type of a field. To preserve existing data, only change between logical types that map to the same physical type on the database. For example, Choice and String.

Active Enables or disables the field. When this check box is cleared, the field is not used by the system.
Read only

Determines whether users can change the field value. When this check box is selected, users cannot change the value. The data for the field is calculated and displayed by the system.

Note: You can override this option for extended tables.
Audit

Enables or disables auditing for a table. Turning on Auditing (History) for a Table.

Note: This option only applies to tables.
Text index

Determines whether searches index the text in a table.

Note: This option only applies to tables. To exclude fields from indexing, see Remove an Index for a Specific Field.
Column label Defines a unique label for the column. The label appears on list headers and form fields for the column.
  • Updating the Column label field also updates the label in the language file (for the current language).
  • When you create a new column, the column name is populated automatically based on the label, which is prefixed with u_ to indicate that it is custom. For example, if you enter Activity Description as the column label, the column name defaults to u_activity_description.
Column name
Defines the field name of the column. When you create a new field, this name is populated automatically based on the label and a prefix as follows:
  • For a field on a table in a different scope, the name is prefixed with the scope to indicate that it is custom and not part of that application.
  • For a field on a table in the same scoped application, the name does not have a prefix, which indicates that it is part of the application.
  • For a field in a global application the name is prefixed with u_ to indicate that it is custom.

You cannot modify the prefix; however, you can modify the rest of the name. The name can contain only lowercase, alphanumeric ASCII characters and underscores (_). You cannot change the name of an existing dictionary record.

Max length

Provides a logical limit for the size of string fields to determine how the system displays them in the user interface and how to map them to physical database data types.

String fields with a length under 255 characters appear as a single-line text fields. String fields with a length over 254 characters appear as a multi-line text box.

The system maps the field length to the closest physical data type available on the database. In some cases this results in significantly more available length than originally specified. For example, entering a length of 50 maps to the closest physical data type of VARCHAR(100), which provides up to a 100 character limit or double the requested field length. Likewise, entering a length of 1000 maps to the closest physical data type of MEDIUMTEXT, which provides up to a 4000 character limit or four times the requested field length.

Note:
  • You can only change this value for a String field. Changes for any other type of field are ignored.
  • Users on an Oracle instance cannot increase the maximum length of a string field to anything greater than 4000 through the application UI as this requires the CLOB datatype in Oracle. To increase beyond this size, log an incident with technical support to request the change.
  • To prevent data from being lost, only decrease the length of a string field when you are developing a new application and not when a field contains data. A warning appears if a change to a custom field will result in data loss. For a base system field, you cannot make a change that will result in data loss.
Mandatory

Determines whether this field must contain a value to save a record. For more information, see Creating Mandatory Fields.

Note: You can override this option for extended tables.
Display

Indicates that this field is the display value for reference fields. Set this to true for the one field whose value you want to use as the text displayed in links to this table on lists and forms. By default, the Number field is the display value for all task tables.

Note:
  • This option does not control whether a list or form displays this field as part of the layout. Instead, see List Configuration and Personalizing Forms.
  • The display value becomes part of the form title when viewing an individual record from a table.
  • You can set a different display value on an extended table than the display value on a parent table by using a dictionary override.
Attributes [Advanced view] Alters the behavior of a field or functionality that depends on the field. For more information, see Dictionary Attributes. Attributes can be overridden for extended tables with dictionary overrides. You can also configure attributes for this dictionary entry through the Attributes related list.
Default Value
Use dynamic default [Advanced view] Allows you to specify a default value that is generated dynamically based on a dynamic filter.
Dynamic filter value [Advanced view] Specifies the dynamic filter that determines the default value if the Use dynamic default option is selected.
Default value Specifies the default value of the field for any new record. Ensure that this value uses the correct field type. For example, an integer field uses a default value of 2 but cannot use a default value of two. These values can be overridden with dictionary overrides.
Reference Specification
Reference

Makes the field into a reference field.

If you enter a name that does not match an existing table, a new table is created when you save your changes to the dictionary record. If the current table has a module in the application navigator, a module for the new table is automatically created in the same application menu.

Use reference qualifier [Advanced view] Specifies the type of qualifier to use:
  • Simple: A set of choice lists where you can specify a reference qualifier condition.
  • Dynamic: A dynamic filter that you can use to build the qualifier.
  • Advanced: A static encoded query string or JavaScript code that you can use to build the qualifier.
Reference qual condition Specifies a condition when the reference qualifier runs if the Simple qualifier type is selected.
Dynamic ref qual [Advanced view] Specifies the dynamic filter that determines the reference qualifier when the Dynamic qualifier type is selected.
Reference qual [Advanced view] Filters the records available for a reference field if the Advanced qualifier type is selected. Reference qualifiers can be overridden with dictionary overrides.
Reference key [Advanced view] Identifies a field other than sys_id to use as the unique identifier for reference fields.
Reference cascade rule [Advanced view] Defines what happens to a record if the record it references is deleted. Select one of the following:
  • Clear: clears the references (default).
  • Delete: deletes all referencing records.
  • Restrict: prevents record deletion if there is a referencing record.
  • None: does not change referencing records.
Reference floats [Advanced view] Enables the Edit button on related lists for one-to-many relationships.
Dynamic creation [Advanced view] For reference fields, determines whether entering a value that does not match an existing record creates a new record on the referenced table. If selected, use the Dynamic creation script field to define how to create the new record.
Dynamic creation script [Advanced view] When the Dynamic creation field is selected, allows you to enter a script for creating a record on the referenced table.
Dependent Field
Dependent on field [Advanced view]

Specifies a field on which the current field depends. For more information, see Configuring Dependent Fields

Note: You can override this value for extended tables.
.
Choice List Specification
Choice
Allows users to see a list of suggested values in one of the following ways:
  • Drop-down menu without -- None --
  • Drop-down menu with -- None --
  • Suggestion

If a choice is used, either define a choice list or use the fields Choice table and Choice field to copy choices from another field elsewhere in the dictionary.

Choice table [Advanced view]

Populates the field choices with the same values as another choice field. If the Choice field is set to anything besides None, select a table to draw choice values from. The field Choice field must also be populated.

For example, if Choice table is set to the Incident [incident] table, this field has the same choice list as one of the choice fields on Incident. Choice field (see below) determines which field.

Choice field [Advanced view]

Populates the field choices with the same values as another choice field. If the Choice field is set to anything besides None, select a field from the table you selected for Choice table. For example, if the Choice table field is set to the Incident [incident] table, and Choice Field is set to Priority, this field has the same choices as the Priority field on Incident, even if those choices change.

Note: This field must be a choice field.
Calculated Value
Calculated [Advanced view]

Determines whether the value of the field is calculated from other values. If selected, use the Calculation field to define how the calculation is performed. When sorting or grouping by a calculated field, the sort order is based on the field value from the last time the field was updated, not the last time the field was displayed.

Note: In relation to business rules, calculated fields are populated first before any business rule, even a before business rule, is run. Calculated fields are then populated again if necessary after any before business rules run.
Calculation [Advanced view] When the Calculated field is selected, allows you to enter a script for calculating the value of the field. These can be overridden for extended tables with dictionary overrides. You can use the current object in this script. Just as with access control rules, the script can:
  • Evaluate to true or false.
  • Return an answer variable set to true or false.
  • Set a field value directly, such as: current.display_name="name".
Additional fields
Class Identifies the table that the current table extends. Tables that do not extend other tables specify their own name in this field. For more information, see Tables and Classes.
Defaultsort

Obsolete. See Default list sort order.

Size class Determines whether the platform handles this table as a large table by reducing the amount of memory stored for each row during queries. There is a scheduled job which runs and sets the value of this field.
Spell check Enables or disables spell check on the field. For more information, see Adding Spell Check to a Field.
Unique

Requires the field value to be unique.

Warning: Making a field unique when the corresponding table already has different values for that field causes data loss. Before you enforce uniqueness on a field, verify that no records in the table for the field have values, or that they all have the same value.
UI action
Default view or Advanced view Changes the form view to the default or advanced view. The fields change based on the view. If you are using the default view, you must write a script to accomplish the same tasks that advanced view fields provided.
Related Lists
Access Controls Provides access to the Access control rules that permit or limit access to the data in the table.
Choices Provides access to the options in the choice list field you are editing.
Dictionary overrides Provides access to the dictionary overrides for this field.
Attributes Provides access to the dictionary attributes for this entry.
Labels Provides access to the labels used for the table or field you are editing.