Wiki: IMLN

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)

Displayed Value	Notes
Fixed	These are pre-delivered system values provided by High Line. New values cannot be added to these lexicons."User Defined" lexicon values will be marked as "obsolete" and will be removed during a full seed load (i.e. during a major release)
User Defined	These are pre-delivered system values provided by High Line. These may contain preloaded values which should not be removed, however customers may add new addition values to lexicons of this type.
Partially Fixed	These are lexicons that will allow additional user defined values (Same as User Defined).
Obsolete	These are Lexicons are no longer used. Lexicons created by users with any type other than "User Created" will be marked as Obsolete when SEED data is loaded. Any lexicon values associated to the incorrect lexicons will be removed.
User Created	These are lexicons created by users. These lexicons will not be modified 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. This should be in Upper case if value is character.

Displayed: The displayed value is what is presented to the users when they do a drop down on the lexicon.

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.

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.

----

Click to create a new notes page