Specifying Attributes for a New Field Definition

Access the field definition window for a new field definition.

All field types share the following property settings.

Note:

Multiple views of this dialog box are available, depending on which field type you select. Fields that are common to all views are documented first.

Field or Control Description

Label ID

Enter a unique identifier for the field that is less than 18 characters, without spaces, and in uppercase. Make this the default label by selecting the Def check box in the last column; otherwise, the first label is the default. You can set only one field label as the default.

Note: You can specify multiple labels for one field and change them at runtime using PeopleCode. Label IDs must contain alphanumeric characters only and cannot consist entirely of spaces.

See Using Multiple Labels.

Long Name

Enter up to 30 characters. The name that you enter here appears as the RFT Long option for a page field. This label is also used for the tool tip, or hover text, for links at runtime if it is different from the assigned display value of the link.

Note: Do not use the \ (backslash) character in the long name of cubes and members. Unexpected behavior might occur.

Short Name

Enter up to 15 characters as an alternate name to use on pages and reports if you have insufficient space to display the long name. If you leave this field blank, the system automatically copies the first 15 characters of the long name into this field. The name that you enter here appears as the RFT Short option for a page field.

Note: If you name the field the same as the default label ID, you can identify it more easily when using PeopleCode.

Note: Do not use the \ (backslash) character in the short name of cubes and members. Unexpected behavior might occur.

Def (default)

When you enter the first label ID, the system automatically selects the Def check box. The system uses this default field if you have multiple labels. You can have only one default field.

Not Used

This check box is always read-only in the field definition properties dialog box. You can change its value using PeopleCode, causing the field to be:

  • Skipped as part of the unique index.

  • Exposed to PeopleCode for read and write operations.

  • Ignored in Query.

  • Ignored in PS/nVision.

  • Unavailable to users in search pages or list boxes if it is a search key or list box item.

See PeopleCode Language Reference: SetDBFieldNotUsed function.

Chart Field

This field is read-only in the field definition properties dialog box. It is used for character fields and by financial applications to specify a usage pattern. You can change the value using PeopleCode.

Encrypt

Select this option to encrypt the field using Oracle Transparent Data Encryption (TDE).

Note: The Encrypt option is disabled for field types that do not support encryption, for database platforms other than Oracle, as well as for Oracle database versions that do not support TDE.

See Data Management: Encrypting Fields.