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) |
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. |
Partially Fixed | These are lexicons that will allow additional user defined values. |
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) |
User Defined | These are lexicons that are expected to be populated by customers. These may contain preloaded values which should not be removed. |
- 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.
- 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.
----