DEFINE USER FIELDS#

The Define User Fields (IMUF) screen allows you to create and maintain the user fields used by the associated table within the system.

User fields may be defined in any table that allows them. When you wish to enter a user field, you may select the User Fields icon, or select from the menu. When user fields exist for a record, the User Field icon will "light" up by changing color. User-defined fields are stored in the database as character fields, regardless of how they may be represented or defined to the user.

The definition data for the Define User Fields screen is stored in the P2K_AM_TABLE_DETAILS and P2K_AM_USER_FIELDS tables.

Table
The table that will contain the user defined field. This table must be permitted to have user defined fields.

User Field Info #

Seq #
This specifies the order that fields are to be displayed on the user fields form.
User Field
This field identifies the name of the user field. Field names may be alphanumeric, or contain the dollar ( $ ), pound sign ( # ) or underscore ( _ ) and must start with a letter.
Prompt
this field displays how the user field will be identified on the column.
Prompt (FRE)
If the form is to be displayed in a second language, this field allows you to provide an alternate language name for the user field. (On the example screen, the second language is identified as French, ‘Prompt (FRE)’.)
Field Type
This field defines the type of data is to be contained within the user field. The types of fields supported are Date, Number, and Char (alphanumeric)
Required
If this toggle is turned on, this field becomes a required entry. That is, a blank entry is invalid.
Format Mask
If there is some special formatting required for the field, the edit mask is defined in this field. This is typically used for date fields, to specify the format the date is to be shown in (DD-Mon-YYYY)
Lexicon Name
If the field is to have limited values to choose from, you may wish to define a lexicon to contain those values. The name of the lexicon would be entered here, or may be chosen from a list. The lexicon must exist prior to selecting the name.
If a lexicon code (IMLN) is associated with a User Defined Field, and the user defined field is added to a form, the value of the lexicon will be displayed on the form, however the User Defined Field will be stored on the P2K_AM_USER_FIELD_VALUES table as Saved Value-Displayed Value.

Example if user updates the UDF on a form by selecting a value from the associated lexicon X_YES_NO. "Yes" will display on the form and "Y-Yes" will be saved on the P2K_AM_USER_FIELD_VALUES table (This will be visable using the UDF lookup or will be the value returned if using the P2K_SMGLX function).

User Field Usage
This field indicates if the user field is user defined or pre-loaded with the software.


Notes #

Click to create a new notes page