This page (revision-9) was last changed on 26-Nov-2021 10:22 by JEscott

This page was created on 26-Nov-2021 10:22 by JMyers

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note
9 26-Nov-2021 10:22 4 KB JEscott to previous
8 26-Nov-2021 10:22 3 KB JEscott to previous | to last
7 26-Nov-2021 10:22 3 KB JEscott to previous | to last
6 26-Nov-2021 10:22 3 KB JEscott to previous | to last
5 26-Nov-2021 10:22 3 KB JMyers to previous | to last
4 26-Nov-2021 10:22 3 KB JMyers to previous | to last
3 26-Nov-2021 10:22 3 KB JMyers to previous | to last
2 26-Nov-2021 10:22 3 KB JMyers to previous | to last
1 26-Nov-2021 10:22 3 KB JMyers to last

Page References

Incoming links Outgoing links
IMLOVL
IMLOVL

Version management

Difference between version and

At line 9 removed one line
The definition data for the Maintain List of Values screen is stored in the [P2K_AM_LIST_OF_VALUES] and [P2K_AM_LIST_OF_VALUES_COLUMNS] tables.
At line 11 changed 27 lines
;[List of Values|LOV_CODE]: This field will provide the name of the list of values being defined.
;[Data Source|DATA_SOURCE_NAME]: This field indicates the name of the source of the LOV’s data. Non-updatable e.g. For an LOV of positions, the Positions table (P2K_cm_positions) will be listed.
;[Title|LOV_TITLE]:This field provides the title of the LOV which will appear at the top of the LOV box.
;[LOV Title (FRE)|LOV_TITLE_TRANSLATE]: If the form is to be displayed in a second language, this field allows you to provide an alternate language name for the LOV.
;[LOV Usage|LOV_USAGE]: This field will indicate if the LOV is Pre-loaded (system provided), User Defined or Obsolete.
;[Where Clause|WHERE_CLAUSE_CODE]: The Where Clause corresponds to an SQL statement and dictates how the data in the LOV can be filtered.
;:The drop down menu for this field displays all the Where Clauses defined.
;:For example, suppose you have created an LOV that will provide a list of positions, however, you would like to see only those positions in the Finance department. You would indicate here that the retrieved data be restricted to the Finance department.
;[Replacing LOV|MLOV_ID_REPLACE]:This field may be used to indicate that the LOV in focus was created to replace a system provided LOV. Replacement LOVs are used to customize the application to meet a client's needs.
;[Exclude From CACHE|EXCLUDE_FROM_CACHE]: This toggle is used to exclude the LOV from the system's cache. This may be done so for performance reasons.
;[Purpose|PURPOSE]:This field provides a quick description of the data source. Non-updatable
;[#|COLUMN_NUMBER]:The sequence number indicates the order in which the columns in the LOV box will appear.
;[Column|COLUMN_NAME_LK]:Use this field to indicate the information to go into the columns. You will make your choice from the selection provided in the drop down menu.
;:The information in this field will be derived from the data source.
;[Display As|COLUMN_TITLE]:This field allows you to give a title to the column in the LOV box.
;[Column Title (FRE)|COLUMN_TITLE_TRANSLATE]: If the form is to be displayed in a second language, this field allows you to provide an alternate language name for the column. (On the example screen, the second language is identified as French, ‘Prompt (FRE)’.)
;[Width|COLUMN_WIDTH]:This field indicates the width of the column in the LOV box.
;[Default|SORT_DIRECTION]: Sort Order
;[Column Usage|COLUMN_USAGE]: This field will indicate if the LOV is Pre-loaded (system provided), User Defined or Obsolete.
;:Whenever you update an LOV, the information needs to be loaded into the system. If you do not load the information, the LOV will not reflect the changes until the system has been restarted.
;[Clear LOV|ACT_CLEAR_LOV]: This field clears the old information provided in the LOV. The new information will not be reloaded until the first time a user accesses the LOV. This may cause a time delay for that user.
;[Load LOV|ACT_LOAD_LOV]:This field will loads new information into the LOV. This means that the first user who accesses the new LOV will not experience a time delay. You can use this button to test the system and see if the information loads properly and in a timely manner.
----
![Notes|Edit:Internal.IMLOVL]
[{InsertPage page='Internal.IMLOVL' default='Click to create a new notes page'}]
List of Values
This field will provide the name of the list of values being defined.
Data Source This field indicates the name of the source of the LOV’s data. Non-updatable
e.g. For an LOV of positions, the Positions table (P2K_cm_positions) will be listed.
Title
This field provides the title of the LOV which will appear at the top of the LOV box.
LOV Title (FRE) If the form is to be displayed in a second language, this field allows you to provide an alternate language name for the LOV. (On the example screen, the second language is identified as French, ‘Prompt (FRE)’.)
LOV Usage This field will indicate if the LOV is Pre-loaded (McKessonHigh Line provided), User Defined or Obsolete.
Where Clause The Where Clause corresponds to an SQL statement and dictates how the data in the LOV can be filtered.
The drop down menu for this field displays all the Where Clauses defined in the Main
For example, suppose you have created an LOV that will provide a list of positions, however, you would like to see only those positions in the Finance department. You would indicate here that the retrieved data be restricted to the Finance department.
Replacing LOV
Purpose This field provides a quick description of the data source. Non-updatable
Type This field categorizes the data source into a specific type. Non-updatable
This currently will be a table.
Columns to be Displayed in LOV
#
The sequence number indicates the order in which the columns in the LOV box will appear.
Column Use this field to indicate the information to go into the columns. You will make your choice from the selection provided in the drop down menu.
The information in this field will be derived from the data source.
Display As
This field allows you to give a title to the column in the LOV box.
Column Title (FRE) If the form is to be displayed in a second language, this field allows you to provide an alternate language name for the column. (On the example screen, the second language is identified as French, ‘Prompt (FRE)’.)
Width
This field indicates the width of the column in the LOV box.
Default Sort Order
Column Usage
This field will indicate if the LOV is Pre-loaded (McKessonHigh Line provided), User Defined or Obsolete.
Whenever you update an LOV, the information needs to be loaded into the system. If you do not load the information, the LOV will not reflect the changes until the system has been restarted.
Clear LOV
This field clears the old information provided in the LOV. The new information will not be reloaded until the first time a user accesses the LOV. This may cause a time delay for that user.
Load LOV
This field will loads new information into the LOV. This means that the first user who accesses the new LOV will not experience a time delay.
You can use this button to test the system and see if the information loads properly and in a timely manner.
This page (revision-9) was last changed on 26-Nov-2021 10:22 by JEscottTop