MAINTAIN LEXICONS#
Lexicons are an application concept where a finite list of values is presented to the user in translatable language, for control over data entry.
The Maintain Lexicons (IMLN) screen shows lexicons supplied by Personality as well as user-defined lexicons.
The definition data for the Maintain Lexicon screen is stored in the P2K_AM_LEXICON_NAMES and P2K_AM_LEXICON_VALUES tables.
- Lexicon Name
- This field is used to define a name for the lexicon. Supplied lexicons are pre-defined with "X_" (e.g. X_APPROVAL_STATUS).
- Lexicon Type
- This field allows you to define the type of lexicon being defined. Note that User Created lexicons will not be updated during a full seed load (i.e. during a major release)
- Length
- This field indicates the number of characters in the saved value of the lexicon. This does not affect the displayed value of the lexicon
- Country Sensitive
- If the lexicon is applicable to a specific country, you will indicate ‘Yes’ in this field.
- Saved Value
- The saved value is what any programming or application logic looks for.
- Displayed
- The displayed value is what is presented to the users when they do a drop down on the lexicon.
- Sort
- The sort column is not currently used.
- Usage
- This field determines the value's usage, i.e. Pre-loaded, Obsolete, User-Defined. Note that values that are User Defined are not touched during a full seed load (i.e. during an upgrade). If the user is of a User Created type, also please ensure that all values are user Defined.
- Legislation
- This field allows the user to assign a legislation to a lexicon value. This is typically used for taxation purposes.
- Meaning
- This provides the user with additional information on the values.
- High Value
- This field is used when there is a range, with the Saved Value being the Low Value and this field containing the High Value of the range. This is currently not used for any lexicons supplied with the system.
----
