Table of Contents
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.
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.